vb6的adodc控件的recordsource支持不支持带sql变量或参数的sql字符串呢??
比如,下列赋值行不行:
Adodc1.CommandType = adCmdText
Adodc1.ConnectionString = conString
Adodc1.RecordSource = str
其中:
str="DECLARE @MyCounter INT
SET @MyCounter = 0
WHILE (@MyCounter < 26)
BEGIN
INSERT INTO TestTable VALUES
(@MyCounter,
CHAR( ( @MyCounter + ASCII('a') ) )
)
SET @MyCounter = @MyCounter + 1
END"
上面是一段批处理,是将表行不行啊?