The 16th lecture ++t-sql basic knowledge

define an integer variable and a two-character variable, respectively.

Declare   @name   varchar (tendeclare   @age      smallint ,     @msg   varchar- -  Note: The value of a local variable is null before it is assigned a value

"Welcome to SQL Server 2008" to display the length of the string.

 declare   @msg                                                     int  - -  declare variable     select   @msg  =  len   (' Welcome to SQL Server 2008  ') - -        print  str  ( @msg )  - - Displays the value of the variable 

Statistics XSQK The number of students in the table, asked to display the information as "student table has XX students."

 UseXscj--Switch the XSCJ library to the current libraryDeclare   @rs    smallint                            --declaring VariablesSelect     @rs=Count(*) fromXsqk--assigning values to variablesPrint‘’--Show 1 Blank linesPrint' Students ' table in total '+ Convert(varchar(3),@rs)+' Students '

16th Lecture ++t-sql Basics