Testing the ISNULL function : Variable « Transact SQL « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Transact SQL
  3. Variable
4>
5> DECLARE   @intTest int
6> SELECT    ISNULL(@intTest,5)
7> SELECT    @intTest = 37
8> SELECT    ISNULL(@intTest,5)
9> GO

-----------
          5

(1 rows affected)

-----------
         37

(1 rows affected)
1>








20.2.Variable
20.2.1.Working with Variables
20.2.2.Use right function with a variable
20.2.3.Testing the ISNULL function
20.2.4.SELECT LEFT(@FullName, 5)
20.2.5.Global variable names begin with an @@ prefix.
20.2.6.XML type variable
20.2.7.Varchar type variable
20.2.8.Use if statement to check a variable
20.2.9.A variable can be assigned a value from a subquery
20.2.10.Use aggregate function with variables
20.2.11.Use Local Variables in where clause
20.2.12.A SQL script that uses variables
20.2.13.Local variables used for searches
20.2.14.Pass variable to a user-defined function
20.2.15.Use one variables in like function