demo009.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

--Use the sp_executesql system stored procedure to execute a Unicode string.
--sp_executesql supports parameter substitution similar to the RAISERROR statement.


DECLARE @DbName nvarchar(20),
                  @TableName nvarchar(20),
                  @SQLString nvarchar(100)

SET @DbName = N'NorthwindSQL'
SET @TableName = N'飞狐工作室'

SET @SQLString = N'USE '+@DbName+CHAR(13)
SET @SQLString = @SQLString + N' SELECT * FROM '+@TableName+CHAR(13)
SET @SQLString = @SQLString + N'WHERE 姓名 LIKE ''许%'''

EXEC sp_executesql @SQLString