sql server´æ儲過³Ì語·¨
-- ±äÁ¿µÄÉùÃ÷,sqlÀïÃæÉùÃ÷±äÁ¿Ê±±ØÐëÔÚ±äÁ¿Ç°¼Ó@·ûºÅ
DECLARE @I INT
-- ±äÁ¿µÄ¸³Öµ£¬±äÁ¿¸³ÖµÊ±±äÁ¿Ç°±ØÐë¼Óset
SET @I = 30
-- ÉùÃ÷¶à¸ö±äÁ¿
DECLARE @s varchar(10),@a INT
-- Sql ÀïifÓï¾ä
IF Ìõ¼þ BEGIN
Ö´ÐÐÓï¾ä
END
ELSE BEGIN
Ö´ÐÐÓï¾ä
END
DECLARE @d INT
set @d = 1
IF @d = 1 BEGIN
-- ´òÓ¡
PRINT 'ÕýÈ·'
END
ELSE BEGIN
PRINT '´íÎó'
END
-- Sql ÀïµÄ¶àÌõ¼þÑ¡ÔñÓï¾ä.
DECLARE @iRet INT, @PKDisp VARCHAR(20)
SET @iRet = 1
Select @iRet =
CASE
WHEN @PKDisp = 'Ò»' THEN 1
WHEN @PKDisp = '¶þ' THEN 2
WHEN @PKDisp = 'Èý' THEN 3
WHEN @PKDisp = 'ËÄ' THEN 4
WHEN @PKDisp = 'Îå' THEN 5
ELSE 100
END
-- Ñ»·Óï¾ä
WHILE Ìõ¼þ BEGIN
Ö´ÐÐÓï¾ä
END
DECLARE @i INT
SET @i = 1
WHILE @i<1000000 BEGIN
set @i=@i+1
END
-- ´òÓ¡
PRINT @i
-- Select INTO ´ÓÒ»¸ö²éѯµÄ¼ÆËã½á¹ûÖд´½¨Ò»¸öÐÂ±í¡£ Êý¾Ý²¢²»·µ»Ø¸ø¿Í»§¶Ë£¬ÕâÒ»µãºÍÆÕͨµÄ
-- Select ²»Í¬¡£ бíµÄ×ֶξßÓÐºÍ Select µÄÊä³
Ïà¹ØÎĵµ£º
SELECT TOP 33 id=identity(int,1,1) INTO #1 from sysobjects
SELECT A.id ,B.id,C.id,D.id,E.id,F.id
from #1 A,#1 B,#1 C,#1 D,#1 E,#1 F
WHERE A.ID<B.ID AND A.ID<C.ID AND A.ID<D.ID AND A.ID<E.ID AND A.ID<F.ID
AND B.ID<C.ID AND B.ID<D.ID AND B.ID<E.ID AND B.ID<F.ID
AND C.I ......
·½°¸Ò» ÔËÐÐmmc£¬È»ºó²Ù×÷£¬¿ØÖÆ̨–Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª–Ìí¼Ó–ÕÒµ½Microsoft SQL ÆóÒµ¹ÜÀíÆ÷–Ìí¼Ó–¹Ø±Õ–È·¶¨£¨×¢£º´Ë´¦µã»÷Ìí¼ÓÍêºó¾Í¿ÉÒԹرÕÁË£¬²»ÒªµÈ´ýÏìÓ¦£¬Èç¹ûÄã¶à´Îµã»÷ÁËÌí¼Ó£¬ºóÀ´¿ÉÒÔ¿´µ½n¶à¸ösqlÆóÒµ¹ÜÀíÆ÷¡£¡£¡££©£¬Ôٻص½¿ØÖÆ̨–Ñ¡Ïî–¿ØÖÆ̨ģʽѡÔñ”Óà ......
²éѯËÙ¶ÈÂýµÄÔÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
¡¡¡¡1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
¡¡¡¡2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
¡¡¡¡3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
¡¡¡¡4¡¢ÄÚ´æ²»×ã
¡¡¡¡5¡¢ÍøÂçËÙ¶ÈÂý
¡¡¡¡6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó(¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ÆäËûµÄ·½·¨½µµÍÊý¾ÝÁ¿)
¡¡¡¡7¡¢ ......
2009-10-08 16:05
ʲôÊÇÊÓͼ
´ó¼Ò¶¼ÖªµÀ£¬ÎÒÃǹú¼ÒÏÖÔÚ“ÉñÆß”ÉÏÌìÁË¡£´ÓÃÀ¹úµÄÔÂÇòµÇÔ¿ªÊ¼£¬ÈËÀàÉÏÌì²»ÔÙÊÇÉñ»°¡£Ìý˵£¬ÔÚÃÀ¹ú£¬ÄãÖ»Òª³ö¼¸Ê®ÍòÃÀÔª£¬Äú¾Í¿ÉÒÔÉÏÒ»´ÎÔÂÇò½øÐÐÌ«¿ÕÂÃÐУ¬ËùÒÔ£¬ÎÒÃÇÏàÐÅ£ºÔÚ²»¾ÃµÄ½«À´£¬ÉÏÌìÂÃÐн«×ß½øÎÒÃÇ°ÙÐÕµÄÉú»î£¬ÄÇÊÇÒ»¼þ¶àôÐÂÏÊÉñÆæµÄÊÂÇé° ......
http://topic.csdn.net/u/20100113/17/b52a1ef4-54a8-4333-8119-a161869c1eef.html
---------------------------------
-- Author: liangCK СÁº
-- Title : ²éÿ¸ö·Ö×éÇ°NÌõ¼Ç¼
-- Date : 2008-11-13 17:19:23
---------------------------------
--> Éú³É²âÊÔÊý¾Ý: #T
IF OBJECT_ID(' ......