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
Ïà¹ØÎĵµ£º
×î½üÁ½ÌìÒ»Ö±ÔÚÕÛÌÚSQLÓï¾ä£¬Ã»°ì·¨£¬Ð´Êý¾Ý¿âµÄÐֵܸøÁËÁ½¸öÀý×ӾͲ»ÔÙ¹ÜÁË£¬¶øÇÒ×î½üÇë¼ÙÁË¡£½ñÌì¼Ó°à»¹ÊÇÕÛÌÚÕâôһ¸öÓï¾ä£¬×ÜÊDz»¶Ô£¬ÇëÀÏ´ó¿´ÁË¿´»¹ÊÇû¿´³öÃŵÀÀ´£¬ ÔÚSQLite Expert Professional ÀïÃæÐ´µÄÓï¾ä¶¼¿ÉÒÔÖ´Ðгɹ¦£¬µ«ÊÇÔÚAndroidµÄ¹¤³ÌÀïÃæÔõôÕÛÌھͲ»¶Ô¡£ ÓôÃÆ°¡£¬½ñÌì¼Ó°àËãÊǰ׼ÓÁË¡£
ΪÁ˲éÕÒºÍÑ§Ï ......
SQL Server ÓÅ»¯ÐÔÄܵö·½Ãæ
(Ò»).Êý¾Ý¿âµÄÉè¼Æ
¿ÉÒԲο´×î½üÂÛ̳ÉϳöÏÖÒ»¸ö¾«»ªÌûhttp://topic.csdn.net/u/20100415/10/a377d835-acbd-4815-8bcb-b367f88ac8b5.html?92227
Êý¾Ý¿âÉè¼Æ°üº¬ÎïÀíÉè ......
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'CLR', 0
GO
-- To update the currently configured value for this feature.
......
×÷Õß: cnd8, ¡¡³ö´¦:ITר¼ÒÍøÂÛ̳,¡¡ÔðÈαà¼: ³Â×Óç÷,¡¡2010-04-21 13:00 ¡¡¡¡ÏÖÔÚÐèÒªÔÚһ̨·þÎñÆ÷(A)ÉϵÄÊý¾Ý¿â(Master)Àï·ÃÎÊÁíÍâһ̨·þÎñÆ÷(B)µÄÁíÍâÁ½¸öÊý¾Ý¿â(NZ ºÍ AU)¡£AU ºÍ NZ ÊÇÍøÕ¾µÄ²¿·ÖʵʱÊý¾Ý£¬Ä¿Ç°Ä³Ò»²½²Ù×÷µÄREPLICATION·½°¸ÊÇ´Ó·þÎñÆ÷Bµ½A£¬AU / NZ µÄ±í½á¹¹Í¬Master Êý¾Ý½á¹¹»ù±¾Ò»Ö¡£¡¡¡¡ÏÖÔÚÐèÒªÔ ......
SQL Server Êý¾Ý¿â¹ÜÀí³£ÓõÄSQLºÍT-SQLÓï¾ä
1. ²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
2. ²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý
exec master..xp_msver
3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý
sp_configure
4. ²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä
select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
²é¿´Êý ......