[标题]:SQL学习笔记
[内容]:SQL Server强制还原数据库脚本：

RESTORE DATABASE Test FROM DISK = 'D:\Test.bak' with replace,
move 'Test' to 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Test.mdf',
move 'GPS_Log' to 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Test_log.ldf'
SQL 统计rollup的使用：

select
isnull(Customer_No,' Total') as Customer_No,
(case when grouping(Customer_No)=1 then '' else Min(Detail_Name) end) as Detail_Name,
sum(Recei
09-1-9 12:27
[最后编辑于09-6-4 11:03]
下页
第1/3页
1 2 3

暂时还没有留言，您有什么感想赶快说说吧！

(1-300字)
返回[日志列表]