Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÕâÑùµÄÓï¾äû¹ØÏµÂð£¿

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



Ïà¹ØÎÊ´ð£º

mssql´æ´¢¹ý³ÌÖÐÈÝ´í´¦Àí - MS-SQL Server / »ù´¡Àà

exec YYys 'aa' aaÊÇmssql·ÇÕýÈ·µÄÓï¾ä,
ÀïÃæÊÇͨ¹ý exec (@sql)--ÉÏÃæaaËù´«µÝµÄ²ÎÊý¾ÍÊÇ@sqlµ÷Óõģ¬Èç¹ûÈçºÎÈÃexec @sql³ö´íºó´æ´¢¹ý³ÌÄÜÊä³ö´íÎó¡£
Õâ¸ö?
Ã²ËÆºÜÄÑ,ÀàËÆÈËΪ´íÎóÖ»ÄÜ´ÓÐÐÕþ·½ÃæÈëÊÖ.

ûÀí½ ......

mssqlº¯Êý·­Òë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¹òÇó½«ÒÔϺ¯Êý·­ÒëΪ mysql µÄÓï·¨
CREATE FUNCTION workdayadd( 
@date datetime, --»ù´¡ÈÕÆÚ 
@workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý 
)RETURNS datetime 
AS 
BEGIN 
DEC ......

msSql ÐÞ¸Äʱ¼ä×Ö¶Î - MS-SQL Server / »ù´¡Àà

±íA
SQL code:
autoID outDate type resultDate
1 2010-05-10 11£º12£º03 1 null
2 2010-05-10 15£º10£º03 0 n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ