
SQL
shenlanzz
无
展开
-
还原数据库
RESTORE database cxtrade FROM DISK = D:/db2008 WITH MOVE cxtrade TO D:/Program Files/Microsoft SQL Server/MSSQL/Data/cxtrade.mdf, MOVE cxtrade_log TO D:/Program Files/Microsoft SQL Ser原创 2008-05-04 15:41:00 · 288 阅读 · 0 评论 -
附加数据库
create database cxtrade ON PRIMARY (NAME =cxtrade ,FILENAME=D:/Program Files/Microsoft SQL Server/MSSQL/Data/cxtrade.mdf) log on (NAME =cxtrade_log,FILENAME=D:/Program Files/原创 2008-05-04 15:39:00 · 433 阅读 · 0 评论 -
查出表的各个字段的所有属性
SELECT 表名 = case when a.colorder=1 then d.name else end, 表说明 = case when a.colorder=1 then isnull(f.value,) else end, 字段序号 = a.colorder, 字段名 = a.name, 标识原创 2008-05-04 15:44:00 · 612 阅读 · 0 评论