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

¸´ÖÆmssqlÐеÄÎÊÌâ - Web ¿ª·¢ / ASP

ÈçÌâ
ÎÒʹÓÃ

VBScript code:
conn.execute("SET IDENTITY_INSERT [abc] On" & vbcrlf & "insert into [abc] (id,name,qq,msn) select (select top 1 id from [abc] order by id desc)+1,name,qq,msn) from [abc] where id="&sid&" & vbcrlf & "SET IDENTITY_Insert [abc] OFF")


ÕâÑù¿ÉÒÔ¸´ÖÆÐµÄÒ»ÐУ¬µ«ÊÇÈç¹ûÓкܶàÓû§Í¬Ê±Ê¹Óã¬Èç¹û²¢·¢µÄ»°£¬ÕâÀïÃæµÄselect top 1¿Ï¶¨¾Í²»¶ÔÁË£¿

Ó¦¸ÃÔõô½â¾öÄØ£¿ÓÐÁíÍâ±È½Ï·½±ãµÄ¸´ÖÆmssqlÐеķ½·¨Âð£¿

ÏÈselect³öÀ´Ò»¸ö¼Ç¼¼¯£¬ÔÙconn.execute insert intoдÈëÊý¾Ý¿â£¿


ÄãµÄÒâ˼ÊÇ£¬ÎÒÓÃIDENTITY_INSERT OnÕâÑùµÄÓï¾äû¹ØÏµÂð£¿

ÒýÓÃ
Ó¦¸Ã²»»á£¬ÓÐÊÂÎñºÍËø
Óï¾äÌ«¶àд´æ´¢¹ý³Ì£¬ÕâÑù³ÌÐòά»¤·½±ã



Ïà¹ØÎÊ´ð£º

AccessºÍMSSQLµÄÒÉÎÊ - .NET¼¼Êõ / C#

ÀÏ´óÈÃ×öÒ»¸öÈí¼þ£¬ÒªÓÃAccess£¬ËµÄܵ¥¶ÀÔËÐÐ...
ÎÒ²»Ì«¶®£¬ÄѵÀAccess²»Óð²×°¾ÍÄÜÔËÐУ¿...
ÓÃC#·ÃÎÊACCESSʱ¿ÉÒÔ²»Óð²×°£¬Ö»ÒªÓÐMDAC¾ÍÐС£

ÐèÒªÄǸö×é¼þ,MDAC,Ò»°ã¼ÆËã»ú¶¼°²×°Á˵Ä.

Acess,ÊÇOfficeÍêÈ ......

ÇóÒ»¸ömssqlµÄsqlÓï¾ä - MS-SQL Server / »ù´¡Àà

ÅжϱíÖÐÊÇ·ñÓдóÓÚ10ÌõÒÔÉϵÄÊý¾Ý£¬
Èç¹û´æÔÚÔò°´×îºÃ¼ÈëµÄʱ¼ä£¬É¾³ýµô¶àÓàµÄÊý¾Ý¡£¡£
±£³ÖÊý¾Ý±íÖÐÖ»ÓÐ10Ìõ×îеÄÊý¾Ý¡£¡£
лл¡£
select ID,count(1) from TB group by ID having count(1)>10


SQL ......

mssql null µÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

select case null
when '' then '1' 
when null then '2' --ΪʲôûÓÐÔÚÕâ¸öλÖÃÅжϳöÀ´
else '3' 
end a 
select 1 a,2 b into #a
select isnull(b,0) b from #a where a=2
--bÁÐû ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......

¡¾SOS¡¿ MSSQLÊý¾Ý¿âÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

select id,name,type from A union all 
select id,name,type from B union all 
select id,name,type from C union all where ???
----------------------------------------------------
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ