22,209
社区成员
发帖
与我相关
我的任务
分享
Declare @str nvarchar(1000);
Declare @temp1 nvarchar(100);
set @temp1='aaa';
begin
set @str='INSERT INTO Tablename([BatchID]) VALUES('''+@temp1+''')';
PRINT @str;
EXEC sp_executesql @str;
END
-- 凑个热闹
create table Tablename(BatchID varchar(30))
go
Declare @str nvarchar(1000);
Declare @temp1 nvarchar(100);
set @temp1='aaa';
begin
-- set @str='INSERT INTO Tablename([BatchID]) VALUES('+@temp1+')';
set @str='INSERT INTO Tablename([BatchID]) VALUES(@batch)';
EXEC sp_executesql @str,N'@batch varchar(30)',@temp1
select * from Tablename
end
go
drop table Tablename
go