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

AcessÓëSQLµÄÇø±ð

AcessÓëSQLµÄÇø±ð 
ÒÔÏÂ總結ÁË×Ô¼ºÔÚ項Ä¿ÖÐËùÓöµ½µÄÓÐ關Acess與SQL²î異µÄһЩµØ·½£º
1£¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
¡¡¡¡access±íʾΪ:#1981-28-12#
¡¡¡¡SQLSERVER2000±íʾΪ:''1981-02-12''
¡¡¡¡2,SQLÓï¾äÇø±ð£¬_select,_updateÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
¡¡¡¡µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUPDATEÓï¾ä¶Ô±È:
¡¡¡¡SQLSERVERÖиüжà±íµÄUPDATEÓï¾ä:
¡¡¡¡_updateTab1
¡¡¡¡SET a.Name = b.Name
¡¡¡¡from Tab1 a,Tab2 b
¡¡¡¡WHERE a.ID = b.ID;
¡¡¡¡Í¬Ñù¹¦ÄܵÄSQLÓï¾äÔÚACCESSÖÐÓ¦¸ÃÊÇ
¡¡¡¡_updateTab1 a,Tab2 b
¡¡¡¡SET a.Name = b.Name
¡¡¡¡WHERE a.ID = b.ID;
¡¡¡¡¼´:ACCESSÖеÄUPDATEÓï¾äûÓÐfrom×Ó¾ä,ËùÓÐÒýÓÃµÄ±í¶¼ÁÐÔÚUPDATE¹Ø¼ü×Öºó.
¡¡¡¡¸üе¥±íʱ:¶¼Îª:
¡¡¡¡_updatetable1 set ab='12',cd=444 where ....
¡¡¡¡3,deleteÓï¾ä
¡¡¡¡accessÖÐɾ³ýʱÓÃ:_delete* from table1 where a>2 ¼´Ö»Òª°Ñ_selectÓï¾äÀïµÄ_select»»³Édelete¾Í¿ÉÒÔÁË¡£
¡¡¡¡sqlserve ÖÐÔòΪ: _deletefrom table1 where a>2 ¼´Ã»ÓÐ*ºÅ
¡¡¡¡4£¬as ºóÃæµÄ¼ÆËã×Ö¶ÎÇø±ð
¡¡¡¡accessÖпÉÒÔÕâÑù:_selecta,sum(num) as kc_num,kc_num*num as all_kc_num ¼´¿ÉÒÔ°ÑASºóµÄ×ֶε±×÷Ò»¸öÊý¾Ý¿â×ֶβÎÓë¼ÆËã¡£
¡¡¡¡sqlserver ÖÐÔòΪ:_selecta,sum(num) as kc_num,sum(num)*num as all_kc_num ¼´²»¿ÉÒÔ°ÑASºóµÄ×ֶε±×÷Ò»¸öÊý¾Ý¿â×ֶβÎÓë¼ÆËã¡£
¡¡¡¡5£¬[.]Óë[!]µÄÇø±ð
¡¡¡¡accessÖжà±íÁªºÏ²éѯʱ:_selecttab1!a as tab1a,tab2!b tab2b from tab1,tab2 ,ÖмäµÄAS¿ÉÒÔ²»Òª¡£
¡¡¡¡sqlserve ÖÐÔò:_selecttab1.a as tab1a,tab2.b tab2b from tab1,tab2 ,ÖмäµÄAS¿ÉÒÔ²»Òª¡£
¡¡¡¡6,ÁªºÏ²éѯʱ£¬
¡¡¡¡accessÖжà±íÁªºÏ²éѯ:'_selecta,b from(
¡¡¡¡_selecta,b from tab1 where a>3 union _selectc,d from tab2 ) group by a,b
¡¡¡¡sqlserve ÖÐÔò'_selecta,b from(
¡¡¡¡_selecta,b from tab1 where a>3 union _selectc,d from tab2 ) tmptable group by a,b¼´Òª¼ÓÒ»¸öÐéµÄ±ítmptable£¬±íÃûÈÎÒâ¡£---
¡¡¡¡7£¬accessÉý¼¶µ½sqlserverʱ£¬
¡¡¡¡¿ÉÒÔÓÃsqlserverµÄÊý¾Ýµ¼È빤¾ßµ¼ÈëÊý¾Ý£¬µ«Òª×ö±ØÒªµÄ´¦Àí¡£
¡¡¡¡accessÖеÄ×Ô¶¯±àºÅ£¬²»»á×Ô¶¯×ª»»SQLÖеÄ×Ô¶¯±àºÅ£¬Ö»ÄÜת»»ÎªintÐÍ£¬Òª°ÑËüÊÖ¹¤¸Ä³É±êʶ×ֶΣ¬ÖÖ×ÓΪ1£¬°ÑËùÓе¼Èë±»sqlserverת»¯³ÉµÄÒÔn¿ªÍ·µÄ×Ö¶ÎÀàÐ͵ÄnÈ¥µô£¬Èçnvarchar->varchar.


Ïà¹ØÎĵµ£º

javaÀàÖÐдsqlÓï¾ä£¬²éѯÌõ¼þ°üº¬»»ÐÐ

detachedCriteria.add(Restrictions.or(
       Restrictions.like("chengBanDanWeiIds", rForm.getChengBanDanWeiIds()+(char)13, MatchMode.START),
       Restrictions.or(
          &n ......

SQLÖд洢¹ý³ÌÖÐSQLÓï¾äµÄµ¥ÒýºÅºÍË«ÒýºÅÎÊÌâ

    Ö£ÖØÉùÃ÷һϣ¬ÕâÆªÈÕÖ¾ÊÇÎÒCopyµÄ£¬²»ÊÇ×Ô¼ºÐ´µÄ£¬ÎÒ»¹Ã»ÄÇôǿ£¡(×Ðϸ¿´Ò»Ï£¬ÓÐÓá£)
¹ØÓÚSQLÓï¾äÖеÄË«ÒýºÅ¡¢µ¥ÒýºÅ£º
£¨1£©ÏÈÀ´¿´Ò»¸ö×î¼òµ¥µÄSQLÓï¾ä
            Insert Into users(username) values("СÍõ")
    ´ó¼ÒÀ´¿ ......

asp.netÁ¬½ÓsqlÓõÄSqlHelper

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Collections;
using System.Data.SqlClient;
namespace DAL
{
    /// <summary>
    /// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
    /// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦Óà ......

sqlÖлñÈ¡×Ö·û´®ÖеÄ×Öĸ,Êý×Ö,·ÇÊý×Öº¯Êý

sql»ñÈ¡×Öĸ:
CREATE FUNCTION dbo.F_Get_STR (@S VARCHAR(100))
RETURNS VARCHAR(100)
AS
BEGIN
    WHILE PATINDEX('%[^a-z]%',@S)>0
          BEGIN
              &n ......

SQL 2005 xml ´¦ÀíµÄһЩsample

USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ