Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / »ù´¡Àà

×ֶεÄĬÈÏÖµÔ¼ÊøÉúËùµÄÔ¼ÊøÃû³ÆÏµÍ³³£³£ÔÚºóÃæÌíÉÏÒ»¸öËæ»úµÄ×Ö·û´®£¬
Èç
DF__Admin__locked__014935CB
ÕâÑùÔì³ÉÒÔºóÔÚÐ޸ĸÄÔ¼ÊøµÄʱºòºÜÂé·³£¬ÔõôÉèÖò»ÈÃÊý¾Ý¿â×Ô¶¯Éú³ÉÕâÑùµÄËæ»úÃû³ÆµÄÔ¼ÊøÃû³Æ
¶øÏòÕâÑù ......

oracle ºÍMSSQLÓÐÄÄÐ©Çø±ð£¡ - .NET¼¼Êõ / C#

´ó¼Ò·¢±íÒ»ÏÂ×Ô¼ºµÄÒâ¼û°¡£¡
1 ¿ªÔ´ÐÔ²»Ò»Ñù
2 Êý¾Ý¿âÈÝÁ¿ÐÔÄܽç±ð²»Äܲ¢ÂÛ
3 ¹«Ë¾¹æÄ£ÍêÈ«²»Ò»Ñù
  OracleĿǰÊǹØÏµÊý¾Ý¿âÖв¢·¢ÐÔÄÜ×îºÃµÄ£¬Ò²µÃµ½¹«ÖÚÈϿɡ£
  Mysql³äÆäÁ¿¿ÉÒÔËã¸öÖÐÐÍÊý¾Ý¿â ......

Mssql2005 xml ²éѯ ʹÓà exist - .NET¼¼Êõ / C#

SQL code:

@uid int
@money float
If not exists(SELECT null from bc_users_table where bet_id=@uid and bet_hk_rationing.exist('/root/items[@straight_bet>'+@money+']') = 1)
--BEGIN
......

mssql ÅúÁ¿²åÈëÊý¾Ý - MS-SQL Server / ÒÉÄÑÎÊÌâ

СµÜÒªÓÃc# ×ö¸öС¹¤¾ß£¬¾ÍÊǸøÊý¾Ý¿âÖеıí¸ñÅúÁ¿²åÈëÊý¾Ý£¬ÎÒÏ뾡Á¿·ûºÏ±í½á¹¹¹ØÏµµÄÊý¾Ý²åÈë½üÀ´£¬ ±ÈÈçÒª¿¼ÂÇÖ÷Í⽡µÈÐÅÏ¢£¬±È·½Ëµ ÓÐ a b c dÈý¸ö±í£¬¶øÎÒÈçºÎÔÚÊý¾Ý¿âÖÐÈ·ÈÏÖ÷¼üºÍÍâ¼ü£¬µ½µ×¸ÃÈçºÎÈ·ÈϲåÈë˳Р......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ