Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÌá¸ßaspµÄSQLµÄÖ´ÐÐЧÂÊÌá¸ßÊý¾Ý¿â¶ÁÈ¡ËÙ¶È

·½·¨Ò»¡¢¾¡Á¿Ê¹Óø´ÔÓµÄSQLÀ´´úÌæ¼òµ¥µÄÒ»¶Ñ SQL.
ͬÑùµÄÊÂÎñ£¬Ò»¸ö¸´ÔÓµÄSQLÍê³ÉµÄЧÂʸßÓÚÒ»¶Ñ¼òµ¥SQLÍê³ÉµÄЧÂÊ¡£Óжà¸ö²éѯʱ£¬ÒªÉÆÓÚʹÓÃJOIN¡£
oRs=oConn.Execute("SELECT * from Books")
while not oRs.Eof
strSQL = "SELECT * from Authors WHERE AuthorID="&oRs("AuthorID") oRs2=oConn.Execute(strSQL)
Response.write oRs("Title")&">>"&oRs2("Name")&"<br>&q uot;
oRs.MoveNext()
wend
Òª±ÈÏÂÃæµÄ´úÂëÂý£º
strSQL="SELECT Books.Title,Authors.Name from Books JOIN Authors ON Authors.AuthorID=Books.AuthorID"
oRs=oConn.Execute(strSQL)
while not oRs.Eof
Response.write oRs("Title")&">>"&oRs("Name")&"<br>&qu ot;
oRs.MoveNext()
wend
·½·¨¶þ¡¢¾¡Á¿±ÜÃâʹÓÿɸüРRecordset
oRs=oConn.Execute("SELECT * from Authors WHERE AuthorID=17",3,3)
oRs("Name")="DarkMan"
oRs.Update()
Òª±ÈÏÂÃæµÄ´úÂëÂý£º
strSQL = "UPDATE Authors SET Name='DarkMan' WHERE AuthorID=17"
oConn.Execute strSQL
·½·¨Èý¡¢¸üÐÂÊý¾Ý¿âʱ£¬¾¡Á¿²ÉÓÃÅú´¦ Àí¸üÐÂ
½«ËùÓеÄSQL×é³ÉÒ»¸ö´óµÄÅú´¦ÀíSQL£¬²¢Ò»´ÎÔËÐУ»Õâ±ÈÒ»¸öÒ»¸öµØ¸üÐÂÊý¾ÝÒªÓÐЧÂʵöࡣÕâÑùÒ²¸ü¼ÓÂú×ãÄã½øÐÐÊÂÎñ´¦Àí µÄÐèÒª£º
strSQL=""
strSQL=strSQL&"SET XACT_ABORT ON\n";
strSQL=strSQL&"BEGIN TRANSACTION\n";
strSQL=strSQL&"INSERT INTO Orders(OrdID,CustID,OrdDat) VALUES('9999','1234',GETDATE())\n";
strSQL=strSQL&"INSERT INTO OrderRows(OrdID,OrdRow,Item,Qty) VALUES('9999','01','G4385',5)\n";
strSQL=strSQL&"INSERT INTO OrderRows(OrdID,OrdRow,Item,Qty) VALUES('9999','02','G4726',1)\n";
strSQL=strSQL&"COMMIT TRANSACTION\n";
strSQL=strSQL&"SET XACT_ABORT OFF\n";
oConn.Execute(strSQL);
ÆäÖУ¬SET XACT_ABORT OFF Óï¾ä¸æËßSQL Server£¬Èç¹ûÏÂÃæµÄÊÂÎñ´¦Àí¹ý³ÌÖУ¬Èç¹ûÓöµ½´íÎ󣬾ÍÈ¡ÏûÒѾ­Íê³ÉµÄÊÂÎñ¡£
·½·¨ËÄ¡¢Êý¾Ý¿âË÷Òý
ÄÇЩ½«ÔÚWhere×Ó¾äÖгöÏÖµÄ×ֶΣ¬ÄãÓ¦¸ÃÊ×ÏÈ¿¼Âǽ¨Á¢Ë÷Òý£»ÄÇЩÐèÒªÅÅÐòµÄ×ֶΣ¬Ò²Ó¦¸ÃÔÚ¿¼ÂÇÖ®ÁÐ ¡£
ÔÚMS AccessÖн¨Á¢Ë÷ÒýµÄ·½·¨£ºÔÚAccessÀïÃæÑ¡ÔñÐèÒªË÷ÒýµÄ±í£¬µã»÷“Éè¼Æ”£¬È»ºóÉèÖÃÏàÓ¦×ֶεÄË÷Òý.
ÔÚMS SQL ServerÖн¨Á¢Ë÷ÒýµÄ·½·¨£ºÔÚSQL Server¹ÜÀíÆ÷ÖУ¬Ñ


Ïà¹ØÎĵµ£º

ʹÓÃSQLServerÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾ä

Èç¹ûÄã¾­³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾­³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLϰ¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ­¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......

SQL Server 2005ÖÐÓ¦¹Ø×¢µÄ30¸ö֪ʶµã

<!--[if !supportLists]-->Ò»¡¢<!--[endif]-->SQL Server 2005Êý¾Ý¿â¹ÜÀíµÄ10¸ö×îÖØÒªÌØµã
<!--[if !supportLists]-->1.         <!--[endif]-->Êý¾Ý¿â¾µÏñ
ͨ¹ýÐÂÊý¾Ý¿â¾µÏñ·½·¨£¬½«¼Ç¼µµ°¸´«ËÍÐÔÄܽøÐÐÑÓÉì¡£Äú½«¿ÉÒÔʹÓÃÊý¾Ý¿â¾µÏñ£¬Í¨¹ý½«×Ô¶¯Ê§Ð§ ......

ÔÚsql serverÖйØÓÚÓαêcursorµÄʹÓÃ

--´Ë´¦Ê¹ÓÃpubs¿â
declare @myname varchar(50)
declare @fname varchar(20)
declare @lname varchar(20)
declare my_cursor cursor for
select fname,lname from employee order by emp_id
open my_cursor
fetch next from my_cursor into @fname,@lname
while @@fetch_status=0
begin
    set @ ......

ÈÃeditplusʶ±ðSQL¹Ø¼ü×Ö

Ê×ÏȾÍÊÇÒª×Ô¼º±àдһ¶Î´úÂ룬´æÎª.stx
Îļþ£¨ÀýÈçsql.stx£©£¬È»ºóÔÚeditplusµÄ²Ëµ¥À¸Tools->Configure User
Tools->Files->Setting &syntax,µãadd°´Å¥£¬ÔÚdescriptionÀ¸Î»ÌîÉÏsql,file
ExtensionsÀ¸Î»Ò²ÌîÉÏsql,Èç¹ûÓжà¸öÀ©Õ¹Ãû£¬Ö®¼äÓÓ£»”¸ô¿ª£¨ÀýÈ磺sql;db2£©,È»ºóÔÚsyntax
fileÀ¸Î»ÌîÉ ......

SQLSERVER ·ÖÒ³´æ´¢¹ý³Ì(2 ÔÚSQL2005ÏÂʹÓÃ)

֮ǰÓÐÒ»¸öSQLServerµÄ·ÖÒ³´æ´¢¹ý³Ì µ«ÊÇÐÔÄܲ»ÊÇÊ®·ÖÀíÏë
ÓÖÕÒÁËÒ»¸ö 
--SQL2005·ÖÒ³´æ´¢¹ý³Ì
/**
if  exists(select * from sysobjects where name='fenye')
drop proc fenye
**/
CREATE procedure fenye
  @tableName nvarchar(200) ,
  @pageSize int,
  @curPage int ,
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ