代码搜索结果

USE Pubs GO EXEC Sp_addrolemember 'sleauthors','SmallFish' GO

USE Pubs GO EXEC sp_addrole ‘sleauthors’ GO

USE Pubs GO EXEC Sp_droprolemember 'sleauthors','SmallFish' GO

USE pubs GO IF EXISTS(SELECT name FROM sysobjects WHERE name = 'Oakland_authors' AND type = 'P') DROP PROCEDURE Oakland_authors GO USE pubs GO CREATE PROCEDURE Oakland_authors AS SELECT a

USE pubs IF EXISTS (SELECT name FROM sysobjects WHERE name = 'pub_info2' AND type = 'P') DROP PROCEDURE pub_info2 GO CREATE PROC pub_info2 @pubname varchar(40) = 'Algodata Infosystem

Use College EXEC sp_helpfilegroup

DECLARE @proc_name varchar(30) SET @proc_name = 'sp_who' EXEC @proc_name

USE College GO EXEC sp_helpdb College GO

USE Pubs GO DROP PROCEDURE REPTQ1 GO

USE College GO EXEC sp_dboption 'College', 'OFFLINE', 'True' GO