一行SQL代码可以做什么？

1.复制表结构

SELECT * INTO Customers_bak FROM Customers WHERE 1=2;
--或者
SELECT TOP 0 * INTO Customers_bak FROM Customers;

2.查询表里是否存在数据

SELECT TOP 1 1 FROM TB

3.随机获取一行数据

SELECT TOP 1 * FROM TB ORDER BY ID

4.查询当前数据库的所有表名

SELECT   NAME FROM SYSOBJECTS WHERE TYPE='U'

补充：SYSOBJECTS表常用TYPE的含义☞
C = CHECK 约束
P = SQL 存储过程
S = 系统基表
SN = 同义词
U = 表（用户定义类型）
V = 视图

5.查询某个表里所有的列名

select column_name from INFORMATION_SCHEMA.COLUMNS
where TABLE_CATALOG = 'BHGS' and table_name = 'Orders'

6.查询数据库中包含某字段的所有表名

select table_name from INFORMATION_SCHEMA.columns
where COLUMN_NAME = 'Name'

7.延迟10秒执行查询语句

waitfor delay '0:0:10' select * from T

8.将查询结果转换成XML格式

select * from T where ID = 1 FOR XML PATH

9.查询数据库中用到某张表的View ☆☆☆☆☆

select object_name(object_id),* from sys.sql_modules
where definition like '%tblOrders%'

10.将小数转换成百分数

SELECT CAST(CAST((0.8888*100) AS NUMERIC(18,2)) as VARCHAR(20)) + '%'

11.将数字改成千分位格式

select convert(varchar(10),cast(12345 as money),1)