Author: ERP Consultors

Use of BETWEEN Operator in SQL: (1) “BETWEEN” operator is used to get values within the specified range. (2) Syntax of “BETWEEN” statement is: SELECT column1, column2, …FROM table_nameWHERE column1 BETWEEN value1 AND value2; (3) Let’s take an example to get records according to the “No.” column is equal to the assigned values as shown. (4) Select the …

Use of IN operator in SQL: (1) “IN” operator is used where multiple conditions are executed. It is a shortcut of the “OR” operator. It is used with the “WHERE” clause. (2) Syntax of “IN” statement is: SELECT column1, column2, …FROM table_nameWHERE column1 IN (value1,value2… valueN); (3) Let’s take an example to get records according to the “Country …

Use of SELECT TOP Statement in SQL: (1) “SELECT TOP” statement is used to get a specific number of records. (2) Syntax of “SELECT TOP” statement is: SELECT TOP number column1, column2, …FROM table_name; (3) Let’s take an example to get specify records from the Vendor table as shown. (4) Select the database in the SQL server and click …

Use of CREATE DATABASE Statement in SQL: (1) “CREATE DATABASE” statement is used for creating a new database. (2) Syntax of “CREATE DATABASE” statement is: CREATE DATABASE databasename;CREATE DATABASE databasename ON PRIMARY (Name =N’Databasename_Data’,FILENAME= N’Pathe’)LOG ON (Name = N’Databasename_Log’,FILENAME= N’Pathe’); (3) Let’s create two databases in the below examples. One is created in by default path …

Use of OR Operator in SQL: (1) “OR” operator is used where multiple conditions are executed. It shows records if any of the condition is true. (2) Syntax of “OR” statement is: SELECT DISTINCT column1, column2, …FROM table_nameWHERE Cond1 OR Cond2 OR CondN; (3) Let’s take an example to get records according to the “No.” & “Country Region Code” …

Use of AND operator in SQL: (1) “AND” operator is used where two conditions are executed. It shows records when all conditions are true. (2) Syntax of “AND” statement is: SELECT DISTINCT column1, column2, …FROM table_nameWHERE Cond1 AND Cond2 AND CondN; (3) Let’s take an example to get records according to the “No.” & “Address” columns are equal to …

SQL ORDER BY Statement: (1) “ORDER BY” statement used for sorting records in the table from the database. (2) Syntax of “ORDER BY” statement is: SELECT DISTINCT column1, column2, …FROM table_nameORDER BY Col1, Col2….; (3) Let’s take an example to sort records according to the “Address” column in the “Vendor table”. (4) Select the database in the SQL server …

SQL WHERE Statement: (1) “WHERE” statement use for filtering records in table from database. (2) Syntax of “WHERE” statement is: SELECT DISTINCT column1, column2, …FROM table_nameWHERE condition; (3) Lets take an example to select only values from the “Country_Region Code” column in the “Vendor table” according to the condition. (4) Select database in SQL server and click on “New …

SQL SELECT DISTINCT Statement: (1) “SELECT DISTINCT” statement used to select unique records in the table from the database. (2) Syntax of “SELECT DISTINCT” statement is: SELECT DISTINCT column1, column2, …FROM table_name; (3) Let’s take an example to select only distinct/unique values from the “Country_Region Code” column in the “Vendor table”. (4) Select the database in the SQL server …

Microsoft D365 Business Central Process Flow: Purchase to Pay: Sales to Receive: General Vouchers: Inventory: Job Work: Production Planning: How to Install SQL Management StudioHow to convert SQL Query into JSON Format in SQL ServerSkip Sales Order Document deletion when it is fully postedHow to Find Base Application Object in BC D365Dynamics 365 Business Central pricing– Microsoft …