Create Table TestTable(cola int ,colb char(3))
go declare @MyCounter int
declare @MyCounter2 char(3)
set @MyCounter = 0
set @MyCounter =''
while(@MyCounter<26)
begin
set @MyCounter2=char(@MyCounter + ASCII('a'))
insert into TestTable (cola ,colb ) values (@MyCounter,@MyCounter2)
set @MyCounter = @MyCounter + 1
end
go
go declare @MyCounter int
declare @MyCounter2 char(3)
set @MyCounter = 0
set @MyCounter =''
while(@MyCounter<26)
begin
set @MyCounter2=char(@MyCounter + ASCII('a'))
insert into TestTable (cola ,colb ) values (@MyCounter,@MyCounter2)
set @MyCounter = @MyCounter + 1
end
go
还有就是我print"计算机"
在此上下文中不允许使用 'jsj'。此处只允许使用常量、表达式或变量。不允许使用列名。
这是为什么啊