mojocube的博客

insert into address (id,parentId,name) values (100000,0,'中国');insert into address (id,parentId,name) values (110000,100000,'北京');insert into address (id,parentId,name) values (110100,110000,'北京市');insert into address (id,parentId,name) values (110101,1.

use master go declare @dbname varchar(20) set @dbname='OA' ---这是数据库名称 declare @sql nvarchar(500) declare @spid int--SPID 值是当用户进行连接时指派给该连接的一个唯一的整数 set @sql='declare get...

右键作业，新建作业，如图：到步骤，新建步骤：输入脚本（路径名称要根据实际情况修改）：USE MASTERRESTORE DATABASE [CMS]FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\CMS.bak'WITH REPLACE,MOVE...