大家帮帮忙了谢了

liuqian0415 2006-10-27 03:19:33

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

...全文

81 3 打赏收藏举报

写回复

3 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

股神 2006-10-28

打赏
举报

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+')'

liuqian0415 2006-10-27