数据库比较查询.sql

数据库通用工具

SELECT col.name  
    FROM sysobjects tab,   
         sysobjects prim,   
         sysindexes ind,   
         sysindexkeys indkey,   
         syscolumns col  
   WHERE ( tab.id = prim.parent_obj ) and  
         ( ind.name = prim.name ) and  
         ( indkey.id = ind.id ) and  
         ( indkey.indid = ind.indid ) and  
         ( tab.id = col.id ) and  
         ( indkey.colid = col.colid ) and  
         ( tab.name = 'myTable' ) AND  
         ( prim.type = 'k' )    

select @@version 
select dateformat from master.dbo.syslanguages where langid = 30
select @@langid 
exec sp_server_info 18
---------------------------
SELECT  
syscolumns.name ,           
syscomments.text ,           
systypes.name ,           
syscolumns.length ,           
syscolumns.prec ,           
syscolumns.scale ,           
syscolumns.isnullable     
FROM 
syscolumns ,           
syscomments ,           
sysobjects ,           
systypes     
WHERE ( syscolumns.cdefault *= syscomments.id) 
and   ( syscolumns.id = sysobjects.id ) 
and   ( syscolumns.xtype = systypes.xtype ) 
and   (sysobjects.xtype = 'U') 
and   (sysobjects.name = 'myTable')  
ORDER BY syscolumns.colorder ASC  

/*
create table myTable
(id int  NOT NULL,
code varchar(20)  NULL,
sgdh varchar(20)  NULL,
typeName varchar(20)  NULL,
cgPart int default(0) NULL,
cgPartName varchar(50)  NULL,
cgMan varchar(10)  NULL,
fzMan varchar(10)  NULL,
kgMan varchar(10)  NULL,
gysID int default(0) NULL,
gysName varchar(50)  NULL,
about varchar(100)  NULL,
state int default(0) NULL,
isCheck bit default(0) NULL,
chkMan varchar(10)  NULL,
chkTime datetime default(getdate()) NULL,
fillDate datetime default(getdate()) NULL,
bFanQDJ bit default(0) NULL,
zsbz bit default(0) NULL,
allJe money default(0) NULL,
payJe money default(0) NULL,
payType varchar(20)  NULL,
operTime datetime default(getdate()) NULL,
operName varchar(10)  NULL,
other varchar(50)  NULL,
chgTime datetime default(getdate()) NULL,
chgUser varchar(10)  NULL,
isUse bit default(1) NULL,
iflag int default(0) NULL,
mainId int default(0) NULL,
payTime datetime default(getdate()) NULL,
paybz bit default(0) NULL,
payLogId int default(0) NULL,
toRoom varchar(20)  NULL
primary key(id)
)
--*/