111,098
社区成员
发帖
与我相关
我的任务
分享大家帮帮忙了谢了
CREATE PROCEDURE SubDeviceGroupInsert
(
@DeviceGroupName char(20),
@Description char(60),
@DeleteFlag char(2),
@baseName varchar(15)
)
AS
declare @sql as nvarchar(3000)
set @sql=@sql+'insert into '+@baseName
set @sql=@sql+'SubDeviceGroup (DeviceGroupName,[Description],DeleteFlag)'
set @sql=@sql+' '+'values('+@DeviceGroupName+','+@Description+','+@DeleteFlag+')'
print @sql
execute sp_executesql @SQL
GO
(
@DeviceGroupName char(20),
@Description char(60),
@DeleteFlag char(2),
@baseName varchar(15)
)
AS
declare @sql as nvarchar(3000)
set @sql=@sql+'insert into '+@baseName
set @sql=@sql+'SubDeviceGroup (DeviceGroupName,[Description],DeleteFlag)'
set @sql=@sql+' '+'values('+@DeviceGroupName+','+@Description+','+@DeleteFlag+')'
print @sql
execute sp_executesql @SQL
GO
...全文
请发表友善的回复…
发表回复
股神 2006-10-28
- 打赏
- 举报
up
Knight94 2006-10-27
- 打赏
- 举报
change
set @sql=@sql+'insert into '+@baseName
set @sql=@sql+'SubDeviceGroup (DeviceGroupName,[Description],DeleteFlag)'
set @sql=@sql+' '+'values('+@DeviceGroupName+','+@Description+','+@DeleteFlag+')'
with
set @sql = ''
set @sql=@sql+'insert into '+@baseName
set @sql=@sql+'SubDeviceGroup (DeviceGroupName,[Description],DeleteFlag)'
set @sql=@sql+' '+'values('+@DeviceGroupName+','+@Description+','+@DeleteFlag+')'
set @sql=@sql+'insert into '+@baseName
set @sql=@sql+'SubDeviceGroup (DeviceGroupName,[Description],DeleteFlag)'
set @sql=@sql+' '+'values('+@DeviceGroupName+','+@Description+','+@DeleteFlag+')'
with
set @sql = ''
set @sql=@sql+'insert into '+@baseName
set @sql=@sql+'SubDeviceGroup (DeviceGroupName,[Description],DeleteFlag)'
set @sql=@sql+' '+'values('+@DeviceGroupName+','+@Description+','+@DeleteFlag+')'
liuqian0415 2006-10-27
- 打赏
- 举报
看看有什么毛病，我执行完以后什么反映都没有
