34,590
社区成员
发帖
与我相关
我的任务
分享用户表加个''的问题!
declare @UserTableName as varchar(8000)
set @UserTableName=''
select @UserTableName=@UserTableName+','+'d.name='+ltrim(rtrim([Name])) from
(
select [Name] from sysobjects where xtype='u' and status>=0
)
A
set @UserTableName=stuff(@UserTableName,1,1,'')
print @UserTableName
结果:
d.name=t_fromsb_list,d.name=t_group,d.name=t_group_role
我要这个结果:
d.name='t_fromsb_list',d.name='t_group',d.name='t_group_role'
SQL 如何改写？？
set @UserTableName=''
select @UserTableName=@UserTableName+','+'d.name='+ltrim(rtrim([Name])) from
(
select [Name] from sysobjects where xtype='u' and status>=0
)
A
set @UserTableName=stuff(@UserTableName,1,1,'')
print @UserTableName
结果:
d.name=t_fromsb_list,d.name=t_group,d.name=t_group_role
我要这个结果:
d.name='t_fromsb_list',d.name='t_group',d.name='t_group_role'
SQL 如何改写？？
...全文
请发表友善的回复…
发表回复
zoulipeng 2004-12-11
- 打赏
- 举报
看见老大了...
赶紧接贴！
谢谢老大！！
赶紧接贴！
谢谢老大！！
zjcxc 元老 2004-12-11
- 打赏
- 举报
declare @UserTableName as varchar(8000)
set @UserTableName=''
select @UserTableName=@UserTableName+','+'d.name='''+ltrim(rtrim([Name]))+'''' from
(
select [Name] from sysobjects where xtype='u' and status>=0
)
A
set @UserTableName=stuff(@UserTableName,1,1,'')
print @UserTableName
set @UserTableName=''
select @UserTableName=@UserTableName+','+'d.name='''+ltrim(rtrim([Name]))+'''' from
(
select [Name] from sysobjects where xtype='u' and status>=0
)
A
set @UserTableName=stuff(@UserTableName,1,1,'')
print @UserTableName
