Author: ERP Consultors
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 …
Convert SQl Query into JSON Format in SQL Server: (1) “SELECT” statement used for select records in table form database. (2) Syntax of “SELECT” statement is: SELECT column1, column2, …FROM table_name for JSON AUTO; (3) Let’s take an example to select records for “Vendor table” and show them in “JSON” format. (4) Select the database in the SQL server …
Select Records from Table via SQL using SELECT: (1) Before starting SQL query, understand the advantages of language. SQL stands for Structured Query Language. SQL can retrieve data from a database. SQL can insert, update, delete records in a database. SQL can create new databases. SQL can create new tables, procedure & views. (2) “SELECT” statement …
Install SQL Management Studio: (1) Go to the folder where SQL Management Studio setup is saved as shown in Fig. (2) Select SSMS-Setup-ENU and right-click on the setup and select the option “Run as administrator” as shown in Fig. (3) After doing the above steps, a new window is open and choose the option “Install” as …
AL Control Statements in Business Central: (1) AL consist of one or more statements, which are executing the information from top-down order. They are divided into the following main group as below: AL Compound Statement. AL Conditional Statement. AL Repetitive Statement. (2) AL Compound Statement: It is defined as enclosing the statements between the “BEGIN & …
