MSSQL´æ´¢¹ý³ÌʵÀý
Create proc RegisterUser
(
@usrName varchar(30)
,@usrPasswd varchar(30)
,@age int
,@PhoneNum varchar(20)
,@Address varchar(50)
)
as
begin
--ÏÔʾ¶¨Òå²¢¿ªÊ¼Ò»¸öÊÂÎñ
begin tran
insert into user
(
userName
,userPasswd
)
values
(
@usrName
,@usrPasswd
)
if @@error<>0
begin
--²Ù×÷ʧ°Ü£¬ÔòÊÂÎñ»Ø¹ö
rollback tran
--·µ»Ø´æ´¢¹ý³Ì£¬²¢ÉèÖ÷µ»ØÂëΪÊÂÎñ²Ù×÷ʧ°Ü
return £1
end
--²åÈëÓÃÐÅÏ¢
insert into userdoc(
userName
,age
,sex
,PhoneNumber
,Address)
values(
@Usrname
,@age
,@PhoneNum
,@Address)
if @@error<>0
begin
--²Ù×÷ʧ°Ü£¬ÔòÊÂÎñ»Ø¹ö
rollback tran
return £1
end
--Èç¹û²Ù×÷Ö´ÐÐÕýÈ·£¬ÔòÌá½»ÊÂÎñ
commit tran
return 0
end
Ïà¹ØÎĵµ£º
Ò»¡¢ÈÏʶË÷Òý
¡¡¡¡(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒà ......
MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖƽá¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
......
-- ÈÎÒâ½øÖÆת»»Îª10½øÖÆ
-- Àý 0FA ת»»Îª 16½øÖÆ select dbo.f_BinaryToInt('0123456789ABCDEF', '0FA')
CREATE function dbo.f_BinaryToInt(@BinaryFormate varchar(100), @num varchar(200))
--@BinaryFormate Ϊ×Ô¶¨ÒåµÄ½øÖƸñʽ
--@num ΪҪת»»³É10½øÖƵÄ×Ô¶¨ ......
---xml²ð·ÖÒÔ²»¶¨¿Õ¸ñΪ·Ö¸î·ûºÅµÄ×Ö·û´®
--²âÊÔÊý¾Ý
if object_id('[tb]') is not null drop table [tb]
create table [tb]([a] varchar(200))
go
insert [tb]
select 'aaaa bbbb cccc dddd'
insert [tb]
select 'eeeeee ffff hhhh   ......
/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*PLU ......