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
Ïà¹ØÎĵµ£º
order by µÄÊýÖµÐÍÁé»îʹÓÃ
select * from table_a where id=p_id order by decode(º¯Êý,'asc',1,'desc',-1)*jsny;
¿ØÖÆÊÔͼµÄ·ÃÎÊʱ¼ä£º
6.create view ...
as
select ... from where exists(select x from dual where sysdate>=8:00am and sysdate<=5:00pm)
ÃîÓÃdecodeʵÏÖÅÅÐò
select * from tabnam ......
http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
Çø×¨ÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......
@ECHO OFF
ECHO /////////////////////////////////////////////////
ECHO // Microsoft SQL Server 2005 ÕûºÏ¡¢¼¯³ÉSP3
ECHO // Author : cxygoo
ECHO // Date : 2008-12-22
ECHO /////////////////////////////////////////////////
ECHO ÔËÐдËÅú´¦Àíǰ£¬µÃ½¨Ä¿Â¼£ºC:\SQL2005,C:\SQL200 ......
´ÓdateTimeÀàÐÍÊý¾ÝÖлñÈ¡¼¾¶È£º
select cast(datepart(q,sign_date) as varchar(2))+'¼¾¶È'
Ò».sql serverÈÕÆÚʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼ä ......