select d.name,a.name ,b.name ,a.length, a.isnullable from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U'
解决方案 »
- 高分求 SQL
- phpmyadmin(Mysql)怎么访问操作界面啊?
- sql 怎么写???
- 从表中检索出检索出第一最小值,第二最小值,第三最小值
- 在线等:sql bcp 导入导出 时 如何能不让其显示 开始复制...已向 SQL Server 发送了 1000 行。总共发送了: 1000
- 求一统计SQL语句.
- 急!急求一句超难的sql语句,
- 一个程序要对不同服务器的不同数据库操作(增加/删除/修改记录),如果对其中的任一个表操作失败,则全部回滚.如何实现呀.
- 问题?
- 如何同时统计本日,本月,本年以及同期,与同期比数据
- 在sql server数据库中有个一字段用来记录当前时间,这个字段默认值设置,带年月日和时分秒,字段类型是datetime吗
- 请问这个问题怎么解决+只要实现就送分
union all
select 'bb',name from bb..sysobjects where xtype='U'
union all
select 'bb',name from bb..sysobjects where xtype='U'
Drop table ##tmp
Create table ##tmp(database_name varChar(20),table_name varChar(20))
Declare @database_name varchar(20),@table_name varChar(20)
Declare Cu_A Cursor For Select data_name=Cast(name as varChar(20))
from master..sysdataBases where status=16 --status=16为用户数据库
Open Cu_A
Fetch Cu_A Into @database_name
while @@Fetch_Status=0
begin
Exec('Use '+@database_name)
Declare Cu_B Cursor For Select Table_name=Cast(name as VarChar(20))
From sysobjects where xtype='U' and Status>0
Open Cu_B
Fetch Cu_B Into @table_name
while @@Fetch_Status=0
begin
Insert Into ##tmp values(@database_name,@table_name)
Fetch Cu_B Into @table_name
end
Close Cu_B
deallocate Cu_B
Fetch Cu_A Into @database_name
end
Close Cu_A
Deallocate Cu_A
Select * from ##tmp
select 'tt' as DBName,name as TBName from tt..sysobjects where xtype='U'
union all
select 'bb',name from bb..sysobjects where xtype='U'
declare @sql varchar(8000)
declare @dbname varchar(100)select @sql=''
declare #aa cursor for select name from master.dbo.sysdatabases where name not in('master','model','msdb','tempdb') --如果 Northwind 和 pubs 数据库不需要显示,则需要加入到条件中
open #aa
fetch next from #aa into @dbname
while @@fetch_status=0
begin
select @sql=@sql+' union all select '''+@dbname+''' as 数据库名,name as 表名 from ['
+@dbname+'].dbo.sysobjects where xtype=''U'''+char(13)
fetch next from #aa into @dbname
end
close #aa
deallocate #aa
select @sql=right(@sql,len(@sql)-11)
if @sql<>''
exec( @sql)
else
print '未有用户数据库'