SQL SERVER 2005 ´æ´¢¹ý³Ì
USE AdventureWorks
GO
CREATE PROC spEmployee
AS
SELECT * from Humanresources.Employee
EXEC spEmployee
ALTER PROC spEmployee
AS SELECT EmployeeID from Humanresources.Employee
drop proc spEmployee
ALTER PROC spEmployee
@LastName nvarchar(50) = NULL
AS
IF @LastName IS NULL
SELECT * from HumanResources.Employee
ELSE
SELECT c.LastName,c.FirstName,e.*
from Person.Contact c
INNER JOIN HumanResources.Employee e
ON c.ContactID = e.ContactID
WHERE c.LastName LIKE @LastName + '%'
EXEC spEmployee
BEGIN TRY
CREATE TABLE OurIFTest
(
COL INT PRIMARY KEY
)
END TRY
BEGIN CATCH
DECLARE @MyOutParameter int
IF ERROR_NUMBER() = 2714
BEGIN
PRINT 'WARNING SHIPPING CREATE AS TABLE ALREADY EXISTS'
EXEC dbo.uspLogError @ErrorLogID = @MyOutParameter OUTPUT
PRINT 'A ERROR WAS LOGGED.THE ERROR ID WAS ' + CAST(@MyOutParameter AS VARCHAR)
END
ELSE
RAISERROR('SOMETHINGS NOT GOOD HAPPENED THIS AROUND',16,1)
END CATCH
DROP TABLE OurIFTest
CREATE TABLE OurIFTest
(
COL INT PRIMARY KEY
)
IF @@ERROR != 0
PRINT 'PROBLEM'
ELSE
PRINT 'EVERYTHING ID OK !'
CREATE PROC spTestRETURN
AS
DECLARE @MyMessage varchar(50)
DECLARE @MyOtherMessage varchar(50)
SELECT @MyMessage = 'HI,IT''S THAT LINE BEFOR THE RETURN'
PRINT @MyMessage
RETURN
SELECT @MyOtherMessage = 'SORRY,BUT WE WON''T GET THIS FAR'
RETURN @MyOtherMessage
RETURN
ALTER PROC spTestRETURN
AS
DECLARE @MyMessage varchar(50)
DECLARE @MyOtherMessage varchar(50)
SELECT @MyMessage = 'HI,IT''S THAT LINE BEFOR THE RETURN'
PRINT @MyMessage
RETURN 100
SELECT @MyOtherMessage = 'SORRY,BUT WE WON''T GET THIS FAR'
PRINT @MyOtherMessage
RETURN
DECLARE @ReturnVal int
EXEC @ReturnVal = spTestRETURN
SELECT @ReturnVal
DECLARE @Error int
INSERT INTO Sales.Individual
(CustomerID,ContactID)
VALUES
(0,0)
SELECT @Error = @@ERROR
PRINT ''
PRINT 'THE VALUE OF ERROR IS ' + CONVERT(VARCHAR,@Error)
PRINT 'THE VALUE OF @@ERROR IS ' + CONVERT(VARCHAR
Ïà¹ØÎĵµ£º
±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......
ÎÊÌâ
ÈçºÎÈÃT-SQL²âÊÔÌ×¼þ°Ñ²âÊÔÓÃÀý½á¹ûÖ±½ÓдÈëÎı¾Îļþ
Éè¼Æ
ʹÓÃActiveX¼¼ÊõʵÀý»¯Ò»¸öFileSystemObject¶ÔÏó£¬È»ºóͨ¹ýOpenTextFile()ºÍWriteLine()·½·¨Ö±½Ó°Ñ²âÊÔ½á¹ûдÈëÎļþ¡£
·½°¸
declare @fsoHandle int,@fileID int
exec sp_OACreate 'Scr ......
Ò»¡¢ÏÂÔØ°²×°
1¡¢SQL Server 2005 Express Edition
ÏÂÔØ SQL Server 2005 Express Edition£¨ÏÂÔØÒ³Ã棩£º
http://msdn.microsoft.com/vstudio/express/sql/download/
°²×°ÍêÊý¾Ý¿âºóÉèÖÃICP/IPÐÒéÆô¶¯£¨ÕâÒ»²½²»ÄÜÉÙ£¬Ä¬ÈÏÊÇTCP/IP²»ÆôÓõģ©£¬¾ßÌåÈçÏ£º
£¨1£©´ò¿ªSQL Server Configuration Manager
£¨2£©×ªµ½SQL S ......
drop table #t
create table #t(req_spid int,obj_name sysname)
declare @s nvarchar(4000)
,@rid int,@dbname sysname,@id int,@objname sysnam ......
ÎÒÃÇÔÚ×öºÜ¶àÏîĿʱ¶¼ÒªÉæ¼°µ½Êý¾Ý¿â£¬ÌرðÊÇһЩ±È½Ï´óÐ͵ÄwebÏîÄ¿£¬¸üÊÇÓнϴóµÄ²¢·¢´¦Àí£¬ËùÒÔ¶ÔÊý¾Ý¿âµÄ²Ù×÷ÓпÉÄÜ»á²úÉúËÀËø£¬¶ÔÓÚÊý¾Ý¿âµÄËÀËø£¬Ò»°ãÊý¾Ý¿âϵͳ¶¼»áÓÐÒ»Ì×»úÖÆÈ¥½âËø£¬Ò»°ã²»»áÔì³ÉÊý¾Ý¿âµÄ̱»¾£¬µ«½âËøµÄ¹ý³Ì»áÔì³ÉÊý¾Ý¿âÐÔÄܵļ±ËÙϽµ£¬·´Ó³µ½³ÌÐòÉϾͻáÔì³É³ÌÐòµÄ·´Ó¦ÐÔÄܵÄϽµ£¬²¢ ......