摘要：select 'select * from dbo.' + [name]from dbo.sysobjectswhere xtype = 'U'order by [name] 阅读全文

摘要：基于SQL server 2005以上的版本，查找表字段语句如下：select B.name, C.name, B.max_length, B.is_nullablefrom sys.objects Ainner join sys.columns Bon A.object_id = B.object_idinner join Sys.systypes Con B.system_type_id = ... 阅读全文