create PROCEDURE temp1
(
@Name nvarchar(255),
@test nvarchar(255),
@name_value varchar(8000)
)
as
exec('insert into '+@test+'( '+@Name+') values ('+@name_value')')
(
@Name nvarchar(255),
@test nvarchar(255),
@name_value varchar(8000)
)
as
exec('insert into '+@test+'( '+@Name+') values ('+@name_value')')
zjcxc(邹建)
(
@Name nvarchar(255),
@test nvarchar(255),
@name_value ntext
)
as
exec('insert into '+@test+'
(
'+@Name+'
)
values
(
'''+@name_value +'''
)
')
(
@Name nvarchar(255),
@test nvarchar(255),
@name_value nvarchar(8000)
)
as
exec('insert into '+@test+'
(
'+@Name+'
)
values
(
'''+@name_value +'''
)
')
(
@Name nvarchar(255),
@test nvarchar(255),
@name_value1 varchar(8000)='',
@name_value2 varchar(8000)='',
@name_value3 varchar(8000)=''
)
as
exec('insert into '+@test+'( '+@Name+') values ('+@name_value1+@name_value2+@name_value3+')')
这个里面不能用 ntext的吗?