动态执行SQL语句

CREATE PROCEDURE MyInit
  @sTable VARCHAR(100),
  @sFields VARCHAR(512),
  @sValues VARCHAR(1024)
AS
DECLARE @sSQL VARCHAR(4096)
SET @sSQL = 'INSERT INTO ' + @sTable + ' (' + @sFields  + ') VALUES(' + @sValues + ')'
EXEC (@sSQL)
GO
DECLARE @sTable VARCHAR(50)
DECLARE @sField VARCHAR(255)
SET @sTable = 'myTable'
SET @sField = 'id, Name, Value1, Value2, Value3'
EXEC MyInit @sTable, @sField, '0, '''', 0, 0, -1' -- 默认
EXEC MyInit @sTable, @sField, '1, ''Test1'', 505, 02, 0'
EXEC MyInit @sTable, @sField, '2, ''Test2'', 505, 01, 0'
........
DROP PROCEDURE MyInit
GO