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

¡¾×ª¡¿ACCESSÖÐÈçºÎÔÚSQLÓï¾äµÄWHEREÌõ¼þÖмÓÈÕÆÚÌõ¼þ

ת×Ô
http://topic.csdn.net/t/20050110/09/3711952.html
accessÖÐʱ¼äÒªÓÃ#,²»ÊÇË«ÒýºÅ  
  select   *   from   kc   where   rq   <   #2000-01-01#   and   rq>#2002-01-01#  
  ²»ÒªÓÃbetween,ËüµÄЧÂÊÌ©µÍ  
ʹÓÃ# ¶ø²»ÊÇʹÓõ¥ÒýºÅ


Ïà¹ØÎĵµ£º

¼òµ¥µÄ3¸öSQLÊÓͼ¸ã¶¨ËùÓÐSqlServerÊý¾Ý¿â×Öµä ת

Êý¾Ý¿â×Öµä°üÀ¨±í½á¹¹(·Ö2KºÍ2005£©¡¢Ë÷ÒýºÍÖ÷¼ü.Íâ¼ü.Ô¼Êø.ÊÓͼ.º¯Êý.´æ´¢¹ý³Ì.´¥·¢Æ÷.¹æÔò¡£¿ÉÒÔÔÚÆóÒµ¹ÜÀíÆ÷¡¢²éѯ·ÖÎöÆ÷Öмòµ¥Ö´ÐУ¬Ö±½ÓÁ˵±µÄ²é³öSQL2K¼°SQL2005µÄËùÓÐÊý¾Ý×ֵ䣬·½±ãÎĵµµÄ±àд£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú¡£
1. SqlServer2000Êý¾Ý¿â×Öµä--±í½á¹¹.sql
SELECT TOP 100 PERCENT --a.id,
   & ......

´æ´¢¹ý³Ì£¬ Éú³ÉSQLÓï¾ä

USE [sfaecrm]
GO
/****** ¶ÔÏó:  StoredProcedure [dbo].[proc_insert]    ½Å±¾ÈÕÆÚ: 05/29/2009 06:16:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[proc_insert] (@tablename varchar(256))
as
begin
        set ......

db2 V8µÄÓйØSQL limits

The following tables describe certain SQL
limits. Adhering to the most restrictive case can help the programmer
design application programs that are easily portable.
Table 7. Identifier Length Limits
Description
Limit in Bytes
Longest authorization
name (can only be single-byte characters) ......

ɾ³ýÖظ´Êý¾ÝµÄsql·½·¨

±íÖÐÓÐһЩ¼Ç¼ÄÚÈÝÖظ´£¬Ò²¾ÍÊÇ˵ÕâЩ¼Ç¼³ýÁËID²»Í¬Ö®Í⣬ÆäËûµÄÐÅÏ¢¶¼Ïàͬ¡£ÐèÒª°ÑÖظ´µÄ¼Ç¼±£ÁôÒ»Ìõ£¬Ê£ÏµÄɾ³ý
--µÚÒ»ÖÖ·½·¨
delete from temp where id not IN (select min(id) from temp group by col1,col2)
--¶Ôcol1,col2£¬¼´ÒªÉ¾³ýµÄÊý¾Ýcol1,col2Á½¸öÁж¼Ïàͬ,ɾ³ýid´óµÄÐÐ
--µÚ¶þÖÖ·½·¨
with a as
(sel ......

SQL ³£ÓÃÓï¾ä

(1)Êý¾Ý¼Ç¼ɸѡ£º
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃû=×Ö¶ÎÖµorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûlike'%×Ö¶ÎÖµ%'orderby×Ö¶ÎÃû[desc]"
sql="selecttop10*fromÊý¾Ý±íwhere×Ö¶ÎÃûorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûin('Öµ1','Öµ2','Öµ3')"
sql="select*fromÊý¾Ý±íwhere× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ