̸SQL Server 2005ÖеÄT

 ¡¡1¡¢varchar(max)¡¢nvarchar(max)ºÍvarbinary(max)Êý¾ÝÀàÐÍ×î¶à¿ÉÒÔ±£´æ2GBµÄÊý¾Ý£¬¿ÉÒÔÈ¡´útext¡¢ntext»òimageÊý¾ÝÀàÐÍ¡£
CREATE TABLE myTable
(
id INT,
content VARCHAR(MAX)
)
¡¡¡¡2¡¢XMLÊý¾ÝÀàÐÍ
¡¡¡¡XMLÊý¾ÝÀàÐÍÔÊÐíÓû§ÔÚSQL ServerÊý¾Ý¿âÖб£´æXMLƬ¶Î»òÎĵµ¡£
¡¡¡¡´íÎó´¦Àí Error Handling
¡¡¡¡1¡¢ÐµÄÒì³£´¦Àí½á¹¹
¡¡¡¡2¡¢¿ÉÒÔ²¶»ñºÍ´¦Àí¹ýÈ¥»áµ¼ÖÂÅú´¦ÀíÖÕÖ¹µÄ´íÎó¡£Ç°ÌáÊÇÕâЩ´íÎ󲻻ᵼÖÂÁ¬½ÓÖжϣ¨Í¨³£ÊÇÑÏÖس̶ÈΪ21ÒÔÉϵĴíÎó£¬ÀýÈ磬±í»òÊý¾Ý¿âÍêÕûÐÔ¿ÉÒÉ¡¢Ó²¼þ´íÎóµÈµÈ¡££©¡£
¡¡¡¡3¡¢TRY/CATCH ¹¹Ôì
SET XACT_ABORT ON
BEGIN TRY
£¼core logic£¾
END TRY
BEGIN CATCH TRAN_ABORT
£¼exception handling logic£¾
END TRY
@@error may be quired as first statement in CATCH block
¡¡¡¡4¡¢ÑÝʾ´úÂë
USE demo
GO
¡¡¡¡--´´½¨¹¤×÷±í
CREATE TABLE student
(
stuid INT NOT NULL PRIMARY KEY,
stuname VARCHAR(50)
)
CREATE TABLE score
(
stuid INT NOT NULL REFERENCES student(stuid),
score INT
)
GO
INSERT INTO student VALUES (101,'zhangsan')
INSERT INTO student VALUES (102,'wangwu')
INSERT INTO student VALUES (103,'lishi')
INSERT INTO student VALUES (104,'maliu')
¡¡¡¡--µ÷ÓÃÒ»¸öÔËÐÐʱ´íÎó
SET XACT_ABORT OFF
BEGIN TRAN
INSERT INTO score VALUES (101,90)
INSERT INTO score VALUES (102,78)
INSERT INTO score VALUES (107, 76) /* Íâ¼ü´íÎó */
INSERT INTO score VALUES (103,81)
INSERT INTO score VALUES (104,65)
COMMIT TRAN
GO
SELECT * from student
SELECT * from score
¡¡¡¡--ʹÓÃTRY...CATCH¹¹Ô죬²¢µ÷ÓÃÒ»¸öÔËÐÐʱ´íÎó
SET XACT_ABORT OFF
BEGIN TRY
BEGIN TRAN
INSERT INTO score VALUES (101,90)
INSERT INTO score VALUES (102,78)
INSERT INTO score VALUES (107, 76) /* Íâ¼ü´íÎó */
INSERT INTO score VALUES (103,81)
INSERT INTO score VALUES (104,65)
COMMIT TRAN
PRINT 'ÊÂÎñÌá½»'
END TRY
BEGIN CATCH
ROLLBACK
PRINT 'ÊÂÎñ»Ø¹ö'
SELECT ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_MESSAGE() as ErrorMessage;
END CATCH
GO
SELECT * from score
GO
¡¡¡¡¿ìÕÕ¸ôÀë Snapshot Isolation
¡¡¡¡1¡¢Ð´Èë³ÌÐò²»»á×è°­¶ÁÈ¡³ÌÐò