摘要: MSSQL为我们提供了两种动态执行SQL语句的命令。分别是EXEC和sp_executesql.实例代码:DECLARE @TableName VARCHAR(50),@Sql NVARCHAR (MAX),@OrderID INT; SET @TableName ='Orders'; SET @OrderID =10251; SET @sql = 'SELECT * FROM '+QUOTENAME(@TableName) +'WHERE OrderID = '+ CAST(@OrderID AS VARCHAR(10))+' ORDE 阅读全文
posted @ 2013-05-01 14:45 息晴海 阅读(143) 评论(0) 推荐(0) 编辑