select 1 from ... sqlÓï¾äÖеÄ1´ú±íʲôÒâ˼£¿
select 1 from ...£¬ sqlÓï¾äÖеÄ1´ú±íʲôÒâ˼£¿²é³öÀ´ÊǸöʲô½á¹û£¿
select 1 from table;Óëselect anycol(Ä¿µÄ±í¼¯ºÏÖеÄÈÎÒâÒ»ÐУ© from table;Óëselect * from table ´Ó×÷ÓÃÉÏÀ´ËµÊÇûÓвî±ðµÄ£¬¶¼ÊDz鿴ÊÇ·ñÓмǼ£¬Ò»°ãÊÇ×÷Ìõ¼þ²éѯÓõġ£select 1 from ÖеÄ1ÊÇÒ»³£Á¿£¨¿ÉÒÔΪÈÎÒâÊýÖµ£©£¬²éµ½µÄËùÓÐÐеÄÖµ¶¼ÊÇËü£¬µ«´ÓЧÂÊÉÏÀ´Ëµ£¬1>anycol>*£¬ÒòΪ²»Óòé×Öµä±í¡£
²âÊÔ³¡¾°£º£¨×ª×ÔÍøÂçÎÄÏ×£©
table±íÊÇÒ»¸öÊý¾Ý±í£¬¼ÙÉè±íµÄÐÐÊýΪ10ÐС£
1£ºselect 1 from table Ôö¼ÓÁÙʱÁУ¬Ã¿ÐеÄÁÐÖµÊÇдÔÚselectºóµÄÊý£¬ÕâÌõsqlÓï¾äÖÐÊÇ1
2£ºselect count(1) from table ¹Ücount(a)µÄaÖµÈçºÎ±ä»¯£¬µÃ³öµÄÖµ×ÜÊÇtable±íµÄÐÐÊý
3£ºselect sum(1) from table ¼ÆËãÁÙʱÁеĺÍ
ÔÚSQL SERVERÖÐÓà 1 ²âÊÔÁËһϣ¬·¢ÏÖ½á¹ûÈçÏ£º
1£º²âÊÔ½á¹û£¬µÃ³öÒ»¸öÐÐÊýºÍtable±íÐÐÊýÒ»ÑùµÄÁÙʱÁУ¨ÔÝÇÒÕâô½Ð£¬ÎÒÒ²²»ÖªµÀ¸Ã½Ðʲô£©£¬Ã¿ÐеÄÁÐÖµÊÇ1£»
2£ºµÃ³öÒ»¸öÊý£¬¸ÃÊýÊÇtable±íµÄÐÐÊý£»
3£ºµÃ³öÒ»¸öÊý£¬¸ÃÊýÊÇtable±íµÄÐÐÊý£»
È»ºóÎÒÓÖÓÓ2”²âÊÔ£¬½á¹ûÈçÏ£º
1£ºµÃ³öÒ»¸öÐÐÊýºÍtable±íÐÐÊýÒ»ÑùµÄÁÙʱÁУ¬Ã¿ÐеÄÁÐÖµÊÇ2£»
2£ºµÃ³öÒ»¸öÊý£¬¸ÃÊýÊÇtable±íµÄÐÐÊý£»
3£ºµÃ³öÒ»¸öÊý£¬¸ÃÊýÊÇtable±íµÄÐÐÊý×2µÄÊý
È»ºóÎÒÓÖÓøü´óµÄÊý²âÊÔ£º
1£ºµÃ³öÒ»¸öÐÐÊýºÍtable±íÐÐÊýÒ»ÑùµÄÁÙʱÁУ¬Ã¿ÐеÄÁÐÖµÊÇÎÒдÔÚselectºóµÄÊý£»
2£º»¹ÊǵóöÒ»¸öÊý£¬¸ÃÊýÊÇtable±íµÄÐÐÊý£»
3£ºµÃ³öÒ»¸öÊý£¬¸ÃÊýÊÇtable±íµÄÐÐÊý×дÔÚselectºóµÄÊý
×ÛÉÏËùÊö£ºµÚÒ»ÖÖµÄд·¨ÊÇÔö¼ÓÁÙʱÁУ¬Ã¿ÐеÄÁÐÖµÊÇдÔÚselectºóµÄÊý£»µÚ¶þÖÖÊDz»¹Ücount(a)µÄaÖµÈçºÎ±ä»¯£¬µÃ³öµÄÖµ×ÜÊÇtable±íµÄÐÐÊý£»µÚÈýÖÖÊǼÆËãÁÙʱÁеĺ͡£
Óï¾äif not exists(select 1 from deleted d join inserted i on d.ID=i.ID
and d.col1=1 and i.col1=2)
if not exists Èç¹û²»´æÔÚ
£¨..£©ÕâÀï¸ÃÊÇÑéÖ¤¸üУ¬¸üÐÂǰµÄidµÈÓÚ¸üкóµÄid,²¢ÇÒ¸üÐÂǰcolµÄÖµÊÇ1£¬¸üкóµÄÖµÊÇ2
Ïà¹ØÎĵµ£º
----start
·²ÊÇÖªµÀÊý¾Ý¿âµÄÈ˶¼ÖªµÀSQL£¬·²ÊǶÔSQLÓÐÒ»µãÁ˽âµÄÈ˶¼¾õµÃSQLºÜ¼òµ¥£¬·²ÊÇÓÐÕâÖָоõµÄÈ˶¼ÊÇSQLµÃ³õ¼¶Óû§£¬ÒòΪËûѧ»áÁËÔö²éɾ¸Ä¾ÍÒÔΪÕâ¾ÍÊÇSQLµÄÈ«²¿¡£Ä¿Ç°µÄ´ó²¿·ÖÓ¦ÓÃÈí¼þ¶¼ÊÇÒÔÊý¾Ý¿âΪÖÐÐÄ£¬Ëæ×ÅÈí¼þµÄÔËÐУ¬Êý¾ÝÁ¿»áÔ½À´Ô½´ó¡£ÈçºÎÓüò½à¡¢¸ßЧµÄSQLÓï¾ä²Ù×÷Êý¾ÝÏÔµÃÔ½À ......
µÚÒ»ÖÖ·½·¨: ʹÓÃoutput²ÎÊý
USE AdventureWorks;
GO
IF OBJECT_ID ( 'Production.usp_GetList', 'P' ) IS NOT NULL
DROP PROCEDURE Production.usp_GetList;
GO
CREATE PROCEDURE Production.usp_GetList @product varchar(40)
, @maxprice money
, ......
ʹÓþۼ¯Ë÷ÒýÓÅ»¯SQL²éѯ
Ê×ÏÈÈÃÎÒÃÇ×öÒ»¸ö²âÊÔ£¬ÏÖ´´½¨Ò»¸ö±í Ïò±íÖвåÈë²»µÈÊý¾Ý
--DROP TABLE T_UserInfo--------------------------------------
CREATE
TABLE
T_UserInfo
(
Userid
varchar(20),
UserName varchar(20)
)
--
DECLARE
@I INT
DECLARE
@ENDID INT
SELECT
@I =
1
SELECT
@ ......
1¡¢Ñ»·²åÈë²âÊÔÊý¾Ý£º
SQL>
declare
maxrecords constant int:=100;
i int :=1;
Begin
for i in 1..maxrecords loop
--²åÈëÊý¾Ý
Insert into TEST.EXAMPLE(name,phone,address) values('·ÖÒ³²âÊÔÊý¾Ý....','ÁªÏµµç»°','ÁªÏµµØÖ·');
end loop;
commit;
end;
´Ë´¦EXAMPLE±í¶¨ÒåΪ(ID number,name ......
HR·þÎñÆ÷£º ²Ù×÷ϵͳ->32λWindows2000 SP4 Êý¾Ý¿â->32λSQL Server2000
OA·þÎñÆ÷£º ²Ù×÷ϵͳ->64λWindows2003 SP2 Êý¾Ý¿â->64λSQL Server2005
OAÏî ......