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
SQLQuery 2014-12-01 wo 電腦小知識 order by sort: select right(c_emp_no, len(c_emp_[……]查看全部 Database, Example Query, MSSQL, Program
check temp table 2014-12-01 wo 電腦小知識 IF OBJECT_ID(‘tempdb..##test’) IS NOT NULL BEG[……]查看全部 Database, Example Query, MSSQL, Program