摘要：
CREATE TABLE #t1 ( i INT , k INT ) CREATE TABLE #t2 ( i INT , k INT ) INSERT INTO #t1 ( i, k )VALUES ( 0 , 0 ) INSERT INTO #t1 ( i, k )VALUES ( 1 , 1 阅读全文
摘要：
实例一： select a.name columnname,c.name as typename,case when a.is_nullable =0 then 'Not Null' else 'Null' end as nullable,a.* from sys.columns a , sys.o 阅读全文
摘要：
CREATE TABLE #t1 ( c1 INT, c2 INT ); CREATE TABLE #t2 ( c1 INT, c2 INT ); INSERT INTO #t1 VALUES ( 1, 2 ); INSERT INTO #t1 VALUES ( 1, 3 ); INSERT INT 阅读全文