- 博客(3)
- 资源 (1)
- 收藏
- 关注
原创 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 1131
原创 对比两张表中不一致的字段
SELECT *FROM (SELECT NAME,XTYPE,LENGTH FROM syscolumns s WHERE id=object_id('TABLE_A')) AFULL 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 1648
原创 查找数据库中具有相同表结构的表
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 501
SQL.Prompt
2015-11-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人