sql 积累

1

2

--查找数据库中哪些表拥有指定的列名

select OBJECT_NAME(id) from syscolumns  where name ='ColumnName'

　　

2.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

--查找表中是否有完全重复的数据

 DECLARE@allCount INT

 DECLARE@disCount INT

  

 SET@allCount = (SELECTCOUNT(*)ASallCount FROM table)

 

 SELECTDISTINCT * INTO#temp  FROM table

 SET@disCount = ( SELECTCOUNT(*)ASdisCount FROM #temp)

 DROPTABLE #temp

  

IF(@allCount-@disCount>0)

BEGIN

    PRINT'Have complete same rows'

END

ELSE   

BEGIN

    PRINT'No complete same rows'

END

　　

3.

1

2

3

4

5

--判断某表是否存在

if object_id('tableName')IS NOT null

BEGIN

  --do what you want

END