SQL´æ´¢¹ý³ÌʵÀý
Àý1 ´«ÈëÒ»¸ö²ÎÊý@username,ÅжÏÓû§ÊÇ·ñ´æÔÚ
-------------------------------------------------------------------------------
CREATE PROC IsExistUser
(
@username varchar(20),
@IsExistTheUser varchar(25) OUTPUT--Êä³ö²ÎÊý
)
as
SELECT @IsExistTheUser = count(username)
from users
WHERE username = @username
GO
Àý2 ´æ´¢¹ý³Ì½áºÏÊÂÎñµÄÒ»¸öÀý×Ó£ºÌí¼ÓÓû§£¬Éæ¼°µ½Á½¸ö±í£¬Ò»¸öÓû§×ÊÁÏ±í£¬Ò»¸öÃÜÂë±í£º
Ôö¼ÓÓû§
-------------------------------------------------------------------------------
create procedure AddUser
(
@username varchar(20),--Óû§Ãû
@passwords varchar(18),--ÃÜÂë
@email varchar(100),--ÓÊÏä
@qq varchar(11),--QQºÅÂë
@imageid int--Í·Ïñ
)
as
-- ÉèÖÃNOCOUNTΪON£¬Ê¹²»ÔÙ·µ»ØÍ³¼ÆÐÅÏ¢£¨´æ´¢¹ý³ÌÖаüº¬µÄһЩÓï¾ä²¢²»·µ»ØÐí¶àʵ¼ÊµÄÊý¾Ý£¬Ôò¸ÃÉèÖÃÓÉÓÚ´óÁ¿¼õÉÙÁËÍøÂçÁ÷Á¿£¬Òò´Ë¿ÉÏÔÖøÌá¸ßÐÔÄÜ¡££©
SET NOCOUNT ON
DECLARE @CurrentError int
-- ´´½¨ÊÂÎñ, ²åÈëÊý¾Ýµ½2¸ö±í
BEGIN TRANSACTION
-- ´´½¨Óû§ÐÅÏ¢
INSERT INTO users (username, email, qq, imageid)
VALUES (@username, @email, @qq, @imageid)
select @CurrentError = @@Error
IF @CurrentError != 0
BEGIN
GOTO ERROR_HANDLER
END
-- ´´½¨Óû§ÃÜÂë
INSERT INTO Signon (username, [password])
VALUES (@username, @passwords)
select @CurrentError = @@Error
IF @CurrentError != 0
BEGIN
GOTO ERROR_HANDLER
END
-- ½áÊøÊÂÎñ
COMMIT TRANSACTION
-- »Ö¸´NOCOUNTÉèÖÃΪOFF
SET NOCOUNT OFF
-- ·µ»Ø0±íʾ³É¹¦£¬ÆäËûÔòΪʧ°Ü
RETURN 0
-- ´íÎó´¦Àí
ERROR_HANDLER:
ROLLBACK TRANSACTION
SET NOCOUNT OFF
RETURN @CurrentError
GO
Ïà¹ØÎĵµ£º
Ò»¡¢×ÛÊö
ÃüÃûºÍ±àÂë¹ý³ÌÖУ¬¶¨ÒåÓÐÒâÒåµÄÃû³Æ£¬ÒÔÒ×ÓÚÀí½â¡¢·½±ãÊéдΪÔÔò¡£
£¨1£©±ÜÃâʹÓÃÖÐÎÄ£¬¾¡Á¿Ê¹ÓÃȫƴÒô»òȫӢÎÄ£¬ÒÔ·½±ã¹ú¼Ê»¯£»
£¨2£©±ÜÃâÆ´ÒôºÍÓ¢ÎĵÄÖÐÎ÷ºÏèµ£¬È磺CAOZUO_TIME£»
£¨3£©±ÜÃâÔÚÃüÃûÖаüÀ¨¿Õ¸ñ¼°ÌØÊâ×Ö·û£»
£¨4£©±ÜÃâʹÓñ£Áô×Ö£»
£¨5£©±ÜÃâÃû³ÆÌ«³¤£¬×¢ÒâËõдµÄʹÓã¬Ëõд¹æÔòΪµ¥´Êǰ4¸ ......
×÷Õß: cnd8, ¡¡³ö´¦:ITר¼ÒÍøÂÛ̳,¡¡ÔðÈαà¼: ³Â×Óç÷,¡¡2010-04-21 13:00 ¡¡¡¡ÏÖÔÚÐèÒªÔÚһ̨·þÎñÆ÷(A)ÉϵÄÊý¾Ý¿â(Master)Àï·ÃÎÊÁíÍâһ̨·þÎñÆ÷(B)µÄÁíÍâÁ½¸öÊý¾Ý¿â(NZ ºÍ AU)¡£AU ºÍ NZ ÊÇÍøÕ¾µÄ²¿·ÖʵʱÊý¾Ý£¬Ä¿Ç°Ä³Ò»²½²Ù×÷µÄREPLICATION·½°¸ÊÇ´Ó·þÎñÆ÷Bµ½A£¬AU / NZ µÄ±í½á¹¹Í¬Master Êý¾Ý½á¹¹»ù±¾Ò»Ö¡£¡¡¡¡ÏÖÔÚÐèÒªÔ ......
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡ÔÚ¾ÙÀý˵Ã÷ÈçºÎ·Ö½âÉÏһƪÎÄÕÂÖеÄÊý¾Ýʱ£¬ÎÒÃÇÊ×ÏÈÁ˽âÒ»ÏÂXQueryºÍËüÔÚSQL Server 2005ÖÐΪ¿ª·¢ÕßÌṩµÄ¹¦ÄÜ¡£
¡ ......
ת×Ô£ºhttp://blog.csdn.net/oceanrain/archive/2006/09/26/1289188.aspx
±¾ÎÄÖ÷Òª½éÉÜͨ¹ýSQL Server2005Á¬½ÓExcelºÍAccess,È»ºó·ÃÎÊExcel¹¤×÷²¾ÖеÄÄÚÈݼ°Access±¾µØÊý¾Ý¿âÖеıíÄÚÈݵķ½·¨:
Ò».SQL Server2005ÈçºÎ·ÃÎÊExcelÎļþÖеÄÊý¾Ý£¿
1.ÔËÐÐ"¿ªÊ¼ \ ³ÌÐò \ Microsoft SQL Server 2005 \ SQL Server Manage ......