mssql show processing 2017-09-10 wo 電腦小知識 select P.spid , right(convert(varchar,[……]查看全部 Database, Example Query, MSSQL, Program
delete job history 2017-09-10 wo 電腦小知識 select j.name as ‘JobName’, run_date, r[……]查看全部 Database, Example Query, MSSQL, Program
transfer logins and passwords between instances of SQL Server 2016-10-18 wo 電腦小知識 –generate script from 2000 to 2005 –ref: http[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
copy MDF and generate attach 2016-10-18 wo 電腦小知識 DECLARE @name VARCHAR(50) — database name DE[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
backup all to .bak 2016-10-18 wo 電腦小知識 DECLARE @name VARCHAR(50) — database name DE[……]查看全部 backup restore, Database, Example Query, MSSQL, Program