110,566
社区成员
发帖
与我相关
我的任务
分享
CREATE PROC proc_txt
(@x_content as varchar(100),
@tablename varchar(30)
)
as
declare @s varchar(100)
set @s='insert into '+ @tablename+'(context)'+'values("'+@x_content+'")'
exec(@s)
GO
execute proc_txt @x_content="'李四'",@tablename='t_text'
CREATE PROC proc_txt
(@x_content as varchar(100),
@tablename varchar(30)
)
as
declare @s varchar(100)
set @s='insert into '+ @tablename+'(context)'+'values('+@x_content+')'
exec(@s)
GO
create table t_text(ID INT IDENTITY(1,1),context varchar(100))
CREATE PROC proc_txtgc
(@x_content as varchar(100)
)
as
insert into t_text(context) values('+@x_content+')
GO
execute proc_txtgc @x_content='李四'