MSSQL Transact SQL 84 codes

  1. Home
  2. MSSQL
  3. Transact SQL
1 @@VERSION
2 A simple example of the @@ERROR variable
3 Assign query result to a variable
4 Assign value from select statement to a variable
5 Assign value returned from a aggregate function to a variable with set statement
6 Assign value to a variable
7 Assigning Values with the Select Statement
8 ATAN
9 BREAK exits the WHILE structure, resuming execution after the END statement
10 BREAK stops the execution of the statements inside the block
11 Build and call dynamic statement
12 CAST @@ROWCOUNT as varchar
13 Checks for existing Product record
14 COALESCE()
15 Conditional Logic IF
16 CONTINUE stops only the current execution
17 Continue statement Demo
18 Create a Stored Procedure that raises an error
19 Create dynamic sql from user name and date
20 Create procedure to update table based on parameters passed in
21 Creating a Trigger and raise an error
22 Creating Inline User-Defined Functions
23 Declare a varchar variable
24 Declare a variable
25 Declares a local variable (@intvar) and then assigns a value to the variable
26 Define table variable
27 Delete in a stored procedure
28 Do calculation in a procedure
29 Do calculation in update statement in a procedure
30 Dynamically set the number of rows returned
31 ELSE
32 Error Handling in SQL Server 2005
33 Function to pass an array
34 Get Object property for a function
35 Get return row count
36 Grouping Code into Blocks
37 How to raise errors
38 IF and else IF
39 If and else if statement
40 IF and EXISTS function
41 If else statement
42 If statement
43 Insert all statements in a batch or to roll back the entire statement group if an error occurs
44 Insert command and variables
45 Insert data to a table in the procedure
46 Legal custorderdetails Inline Table-Valued Function
47 Local variable must be defined using the DECLARE statement
48 Log
49 LOG is the inverse of EXP, and this can be demonstrated by
50 Looping with the WHILE Statement
51 Managing Inserts Using Stored Procedures
52 Not equal sign
53 Not equal sign in SQL Server
54 Print
55 Reference variables in SQL statement
56 Returning Values
57 Rollback transaction on error
58 Select clause as a statement
59 SELECT is usually used to assign variable values
60 Set value from select statement to a variable
61 Stored procedure
62 System schemas
63 Table Variables
64 The second query waited until the next instance of the specified time
65 Update data and table join
66 Update data set returning from the function
67 Update two tables in one procedure
68 Use @Error
69 Use aggregate function in dynamic sql statement
70 Use declared variable in SQL statement
71 Use return statement to return a table from a function
72 Use while loop to insert data
73 Using @@ROWCOUNT
74 Using a dynamic sql statement in Insert select
75 Using GOTO
76 Using RETURN
77 Using SELECT to Assign Variables
78 Using SET to Assign Variables
79 Using Variables with Functions
80 Using WAITFOR
81 When multiple lines of code follow an IF statement it is best to wrap the lines in a BEGIN END block
82 While Loop Demo
83 While loop with counter
84 While with aggregate function