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
赶紧接贴!
谢谢老大!!