demo9108.sql

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

/* 文件名称: Demo9108.sql */

DECLARE @DbName    nvarchar(20),
        @TableName nvarchar(20),
        @Column1   nvarchar(20),
        @Column2   nvarchar(20),
        @SQLString nvarchar(500)

SET @DbName    = N'NorthwindSQL'
SET @TableName = N'飞狐工作室'
SET @Column1   = N'姓名'
SET @Column2   = N'电话号码'

SET @SQLString = N'USE '+ @DbName + CHAR(13)

SET @SQLString = @SQLString +
                 N'SELECT '+ @Column1 + ',' + @Column2 + CHAR(13)

SET @SQLString = @SQLString +
                 N'FROM ' + @TableName + CHAR(13)

SET @SQLString = @SQLString + N'WHERE 姓名 LIKE ''陈[静淑]%'''

EXEC(@SQLString)