sql常用语句大全（SQL common sentences Daquan）.docVIP

sql常用语句大全（SQL common sentences Daquan） Learn the basic syntax of dynamic SQL statements that SQL should know 1, ordinary SQL can perform 9Kp=A with Exec? Select * from CdaFr1? Eg: tableName Wsc+A:? Exec (select * from tableName #Btn (Exec)? Sp_executesql Nselect * from tableName- please note before the string must add N%BfplhE1a? AN) OIDc? 2, field name, database name, table name. As a variable, must use dynamic SQL H2k3./Ip? =r|8#8a? Eg: |M# MB declare @fname} ? Varchar (20) WH$1[Gv7? Set @fname =FiledName @#D[C; VvrE Select @fname from tableName? - error, not error, but the result is a fixed value FiledName, not to. J! _C^, 7#? Exec (select + @fname + from tableName ) - please note plus before and after single quotes on the edge of space \Adve]kD$5? W/r;\? Of course will be changed into a string in the form of variables can also be:? Gf%y? Declare @fname varchar (20) r~j XK3 set @ fname =FiledName? - set the field name! I9mD! G? W (IfnsP? Declare @s varchar (1000) 7A _? Mu? Set @s =select + @fname + from tableNameezCY_T9m? Exec (@s) - _X$exec sp_executesql W=Q! @s? - this sentence wrong vOwTKUb? By4-}_T+A? 2#sv-v6oH? Declare @s Nvarchar (1000) - note here to nvarchar (1000) A^! Set? UOE? @s =select + @fname + from tableName (/Hv6n3Z? Exec (@s) - ix9 Hh{exec sp_executesql @s success? - this sentence right]7UXt*w? LBf0at0? 3, output parameter kz/7 E\/A?% +nO? Declare @num int, -]n, kS1S, @sqls, nvarchar (4000), EIA]sr, set, @sqls=select, count (*), from, tableName, C5@Do, exec (@sqls), A, vBkAD, QH - how do I put the exec results into a variable? F$9`I=j ~p.M^M`7E declare @num?? int, 3^={\CUh? @sqls nvarchar (4000) cI set @sqls=select (@a=count) Jsw4P? *) from tableName 2 c]: zB; exec sp_executesql N@a%? @sqls, int output, @num output *JA z^/ select @num? J3SSiM? Ft*Ow%Djzm? Declare @filename varchar (20) --set @filename =cn --Exec (select,+@filename+, from, B_duty) Set @filename =B_duty Exec (select * from+@filename) In addition, if you want to use single quotes in