generate restore script 2016-10-18 wo 電腦小知識 DECLARE @name VARCHAR(50) — database name DE[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
Select Top 2015-06-07 wo 電腦小知識 select top 2 * from (select top 4 *[……]查看全部 Database, Example Query, MSSQL, Program
RestoreDB_sql 2015-04-02 wo 電腦小知識 RESTORE FILELISTONLY FROM DISK = ‘D:DBBackupxxxxxx[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
Delete duplicate row SQLQuery 2014-12-01 wo 電腦小知識 –loop 幾多 SET ROWCOUNT 0–check and delete[……]查看全部 Database, Example Query, MSSQL, Program
SQL get Child Parent 2014-12-01 wo 電腦小知識 –http://forums.asp.net/t/1849469.aspx –get par[……]查看全部 Database, Example Query, MSSQL, Program