造轮子之--SQL

case when then else end用法###

http://www.cnblogs.com/prefect/p/5746624.html

查看表的数据解释###

SELECT 
c.[name] AS 字段名,
cast(ep.[value] AS varchar(100)) AS [字段说明]
FROM sys.tables AS t
INNER JOIN sys.columns AS c ON t.object_id = c.object_id
LEFT JOIN sys.extended_properties AS ep ON ep.major_id = c.object_id AND ep.minor_id = c.column_id
WHERE t.name='ComplaintLogInfoFollowUp'
AND ep.class =1

还原数据库

RESTORE DATABASE Siemens_SITL
FROM DISK = 'E:MSSQLBackupSiemens_SITL.bak'
WITH MOVE 'Siemens_SITL' TO 'E:MSSQLDataSiemens_SITL.mdf',
MOVE 'Siemens_SITL_log' TO 'E:MSSQLDataSiemens_SITL.ldf',
STATS = 10, REPLACE
GO