SQL´æ´¢¹ý³Ì»ù´¡Óï·¨
Ò».×¢ÊÍ
-- µ¥ÐÐ×¢ÊÍ£¬´ÓÕâµ½±¾ÐнáÊøÎª×¢ÊÍsql Óï·¨£¬ÀàËÆC++£¬c#ÖÐ//
/* … */ ¶àÐÐ×¢ÊÍ£¬ÀàËÆC++£¬C#ÖÐ/* … */
¶þ.±äÁ¿£¨int£¬ smallint£¬ tinyint£¬ decimal£¬float£¬real£¬ money £¬smallmoneysql Óï·¨£¬ text £¬image£¬ char£¬ varchar¡£¡£¡£¡£¡£¡££©
Óï·¨£º
DECLARE
{
{@local_variable data_type}
} [£¬...n]
ÀýÈ磺
declare @ID int --ÉêÃ÷Ò»¸öÃûΪ@IDµÄ±äÁ¿£¬ÀàÐÍΪintÐÍ
Èý.ÔÚSQL Server´°¿ÚÖдòÓ¡³ö±äÁ¿µÄÖµ
Óï·¨£º
PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr
ËÄ.±äÁ¿¸³Öµ
ÀýÈ磺
--´ÓÊý¾Ý±íÖÐÈ¡³öµÚÒ»ÐÐÊý¾ÝµÄID£¬¸³Öµ¸ø±äÁ¿@id£¬È»ºó´òÓ¡³öÀ´
Declare @ID int
Set @ID = (select top(1) categoryID from categories)
Print @ID
ÔÚSQLÖУ¬ÎÒÃDz»ÄÜÏñ´úÂëÄÇÑùÖ±½Ó¸ø±äÁ¿¸³Öµ£¬ÀýÈç@id = 1£¬Èç¹ûÒª´ïµ½ÕâÑùµÄ¹¦ÄÜ£¬¿ÉÒÔÕâÑùд£º
Declare @ID int
Set @ID = (select 1) -- ÀàËÆ @ID=1
Select @id=1 -- ÀàËÆ @ID=1
Print @ID
Îå.±äÁ¿ÔËËã(+£¬-£¬*sql Óï·¨£¬/£¬……)
ÒÔϱØÒªÊ±ºòÊ¡ÂÔ±äÁ¿ÉêÃ÷
Set @ID = (select 1+5) --ÀàËÆ @ID=1+5
Set @ID=(select 1-@ID) --ÀàËÆ @ID=1-@ID
Áù.±È½Ï²Ù×÷·û
? >(greater than).
? <(less than).
? = (equals).
? <= (less than or equal to).
? >= (greater than or equal to).
? != (not equal to).
? <>(not equal to).
? !< (not less than).
? !> (not greater than).
ûʲô˵µÄ
Æß.Óï¾ä¿é£ºBegin … end
½«¶àÌõÓï¾ä×÷Ϊһ¸ö¿é£¬ÀàËÆÓëC++£¬C#ÖеÄ{ }
ÀýÈ磺
Begin
Set @ID1 = (select 1)
Set @ID2 = (select 2)
End
°Ë.If£¬ if…else…
Óï·¨£º
IF Boolean_expression
{sql_statement | statement_block}
[ELSE
{sql_statement | statement_block}]
ÀýÈ磺
If @id is not null
Print ‘@id is not null
if @ID = 1
begin
Set @ID = (select 1 + 1)
end
else
begin
set @ID=(select 1+2)
end
ÉÏÃæµÄÀý×ÓÓõ½Á˱ȽϲÙ×÷·û£¬Óï¾ä¿é£¬ºÍIFµÄÓï·¨¡£
¾Å.Ö´ÐÐÆäËû´æ´¢¹ý³Ì EXEC
ÀýÈç
EXEC dbo.[Sales by Year] @Beginning_Date=’1/01/90’£¬ @Ending_Date=’1/01/08’
Ê®.ÊÂÎñ
Óï·¨£º
BEGIN TRAN[SACTION] [transaction_name | @tran_name_variable]
ÀýÈç
BEGIN TRAN
-- ×öijЩ²Ù×÷£¬ÀýÈçIn
Ïà¹ØÎĵµ£º
sysobjects ±í
ÔÚÊý¾Ý¿âÄÚ´´½¨µÄÿ¸ö¶ÔÏó£¨Ô¼Êø¡¢Ä¬ÈÏÖµ¡¢ÈÕÖ¾¡¢¹æÔò¡¢´æ´¢¹ý³ÌµÈ£©ÔÚ±íÖÐÕ¼Ò»ÐС£Ö»ÓÐÔÚ tempdb ÄÚ£¬Ã¿¸öÁÙʱ¶ÔÏó²ÅÔڸñíÖÐÕ¼Ò»ÐС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
name sysname ¶ÔÏóÃû¡£
Id int ¶ÔÏó±êʶºÅ¡£
xtype char(2) ¶ÔÏóÀàÐÍ¡£¿ÉÒÔÊÇÏÂÁжÔÏóÀàÐÍÖеÄÒ»ÖÖ£º
C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFA ......
ÎÒÏëÃæÊÔ¹ýÈí¼þ¿ª·¢µÄÅóÓѶ¼»áÅöµ½sql·½ÃæµÄÃæÊÔÌ⣬Õâ¸ö¿ÉÒÔ˵ÊÇÃæÊԱؿ¼µÄ¡£ÕâÀïÄü¸¸öÀý×Ó¿ªÍØÒ»ÏÂ˼·¡£
1.
ÓÐÕâÑùÒ»Õűí
½ÌʦºÅ
ÐÇÆÚ
ÊÇ·ñÓпÎ
1
1
ÓÐ
2
3
ÓÐ
1
2
ÓÐ
1
2
ÓÐ
ÒªµÃ³öÕâÑùµÄÊý¾Ý£º
ÐÕÃû
ÐÇÆÚÒ»
ÐÇÆÚ¶þ
ÐÇÆÚÈý
ÐÇÆÚËÄ
ÐÇÆÚÎå
1
1
......
Ó¦ÓÃIDS·ÀÖ¹SQL×¢Èë¹¥»÷
http://www.cnhacker.com/Hacker/Skills/200807/t20080731_6187.html
Ŀǰ£¬Õë¶ÔÓ¦Óü°Æäºǫ́Êý¾Ý¿âµÄÓ¦Óü¶ÈëÇÖÒѾ±äµÃÔ½À´Ô½²þâ±£¬ÈçSQL×¢Èë¡¢¿çÕ¾µã½Å±¾¹¥»÷ºÍδ¾ÊÚȨµÄÓû§·ÃÎʵȡ£ËùÓÐÕâЩÈëÇÖ¶¼ÓпÉÄÜÈÆ¹ýǰ̨°²È«ÏµÍ³²¢¶ÔÊý¾ÝÀ´Ô´·¢Æð¹¥»÷¡£
ΪÁ˶Ը¶ÕâÀàÍþв£¬ÐÂÒ»¼¶±ðµÄ°²È«ÍÑÓ±¶ø³ö£ ......
ÎÞÂÛÊÇʹÓÃÊÖ¹¤ÊÔ̽»¹ÊÇʹÓð²È«²âÊÔ¹¤¾ß£¬¶ñÒâ¹¥»÷Õß×ÜÊÇʹÓø÷ÖÖ¹î¼Æ´ÓÄãµÄ·À»ðǽÄÚ²¿ºÍÍⲿ¹¥ÆÆÄãµÄSQL·þÎñÆ÷ϵͳ¡£¼ÈÈ»ºÚ¿ÍÔÚ×öÕâÑùµÄÊÂÇé¡£ÄãÒ²ÐèҪʵʩͬÑùµÄ¹¥»÷À´¼ìÑéÄãµÄϵͳµÄ°²È«ÊµÁ¦¡£ÕâÊÇÀíËùµ±È»µÄ¡£ÏÂÃæÊǺڿͷÃÎʺ͹¥ÆÆÔËÐÐSQL·þÎñÆ÷µÄϵͳµÄÊ®ÖÖ¹î¼Æ¡£
1.ͨ¹ý»¥ÁªÍøÖ±½ÓÁ¬½Ó
ÕâЩÁ¬½Ó¿ÉÒÔÓÃÀ´¹¥»÷ûÓзÀ ......