1、在Sql Server数据库中创建存储过程
个人感觉挺有用,Mark一下。...INTO @F1,@F2
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql = @sql + ''
+ CASE WHEN @F2 IN (35,58,99,167,175,231,239,61...) then ' + CASE WHEN ' +
@F1 + ' IS NULL THEN '''' ELSE '''''''' END + ' ELSE '+' END...WHEN @F2 IN (35,58,99,167,175,231,239,61) THEN ' + CASE WHEN ' +
@F1 + ' IS NULL THEN ''''...= LEFT(@sql,LEN(@sql) - 5) + ' + '')'' FROM ' + @TableName
EXEC (@sql)
GO
2、执行存储过程
// 输入代码内容
EXEC