SQL Server
hgl0220
这个作者很懒,什么都没留下…
展开
-
查找数据库中具有相同表结构的表
select b.* from (select columnsall,COUNT(*) bs from (select id,name,substring((select ','+name+CAST(xtype as varchar(10)) from syscolumns where id=a.id for xml path('')),2,100) columnsall from sysob原创 2014-06-12 15:03:47 · 512 阅读 · 0 评论 -
对比两张表中不一致的字段
SELECT * FROM (SELECT NAME,XTYPE,LENGTH FROM syscolumns s WHERE id=object_id('TABLE_A')) A FULL JOIN (SELECT NAME,XTYPE,LENGTH FROM syscolumns s WHERE id=object_id('TABLE_B')) B ON A.NAME=B.NA原创 2014-08-13 13:42:06 · 1675 阅读 · 0 评论 -
SQL SERVER实现乘法口诀表
SELECT 'X'+cast(A.NUMBER AS VARCHAR(10)) X,'Y'+cast(B.NUMBER AS VARCHAR(10)) Y,CAST(A.NUMBER AS VARCHAR(10))+'*'+CAST((CASE WHEN B.NUMBER<A.NUMBER THEN NULL ELSE B.NUMBER END) AS VARCHAR(10))+'=原创 2014-09-12 17:02:16 · 1140 阅读 · 0 评论