专注于互联网--专注于架构

动态生成sql语句:动态SQL语句

1:普通SQL语句可以用Exec执行eg: Select * from tableName Exec(\'select * from tableName\') sp_executesql N\'select * from tableName\' -- 请注意字符串前一定要加N2:字段名，表名，数据库名之类作为变量时，必须用动态SQLeg: declare @fname varchar(20) set @fname = \'[name]\'Select @fname from sysobjects -- 错误Exec(\'select \' + @fname [阅读全文] [PDF]