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
Ïà¹ØÎĵµ£º
aspÏνÓMssqlµÄ°ì·¨¼°³£¼ûµÄ²î´í
//µÚÒ»ÖÖд·¨£º
MM_conn_STRING = "Driver={SQL Server};server=(local);uid=sa;pwd=;database=infs;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open MM_conn_STRING
SET RS=SERVER.CreateObject("ADOBD.recordset")
SQL="SELECT * from TABLE ORDER BY ID DESC"
R ......
Ò»¡¢ÈÏʶË÷Òý
¡¡¡¡(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒà ......
ÍøÕ¾¸ü»»¿Õ¼äµÄʱºò£¬¾³£»áÒòΪMSSQLÊý¾Ý¿âÃû²»Í¬£¬µ¼Ö´Ӿɿռ䱸·ÝµÄÊý¾Ý¿âÔÚпռ仹ԺóÎÞ·¨Õý³£Ê¹Óá£Õâʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ý½«Êý¾Ý¿â±íµÄËùÓÐÕßÐÞ¸ÄΪ"dbo"À´½â¾öÕâ¸öÎÊÌ⣬¾ßÌåµÄ·½·¨ÈçÏ£º
´ò¿ª"Microsoft SQL Server"µÄ“ÆóÒµ¹ÜÀíÆ÷”£¬µã¿ªÒªÐ޸ĵÄÊý¾Ý¿â£¬Ñ¡Ôñ¹¤¾ßÀ¸Éϵē¹¤¾ß” ......
--1. ´´½¨±í£¬Ìí¼Ó²âÊÔÊý¾Ý
CREATE TABLE tb(id int, [value] varchar(10))
INSERT tb SELECT 1, 'aa'
UNION ALL SELECT 1, 'bb'
UNION ALL SELECT 2, 'aaa'
UNION ALL SELECT 2, 'bbb'
UNION ALL SELECT 2, 'ccc'
--SELECT * from tb
/**//*
id value
----------- ----------
1 aa
1 bb
2 aaa
......
---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   ......