Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ºÍorcalÁ½ÌõÓï¾ä - Oracle / ¸ß¼¶¼¼Êõ

SQL code:

sql2005£¬sql2008
SELECT
±íÃû=CASE WHEN a.colorder = 1 THEN d.name ELSE '' END,
±í˵Ã÷=CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END ,
×Ö¶ÎÐòºÅ=a.colorder ,
×Ö¶Îà ......

¡¾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 ???
----------------------------------------------------
  ......

mssqlÊý¾ÝתÒƵ½mysql - PHP / »ù´¡±à³Ì

×î½ü¹«Ë¾»»Êý¾Ý¿â£¬mssql »» mysql ¡£´ó¼ÒÓÐʲôºÃµÄ·½·¨°¡£¡
  ²»ÓÃphpת»»£¬´æÔÚÊý¾ÝÄ£Ð͵ÄÎÊÌâ¡£±¾È˺ÜÏëÓÃphp£¬¿ÉÊÇmssqlÀ©Õ¹Ôõô¶¼¼ÓÔز»ÉÏ£¬¸ãÁËÒ»Ììû¸ãÃ÷°×£¡»·¾³ÊÇ£ºapache2.2.4£¬php5.3.2£¨°²×°³ ......

MSSQL ÐÐÊýͳ¼ÆµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÁ½¸ö±í£¬ÊýÁ¿¼¶ÔÚ3000w×óÓÒ£¬
Ïë²é¿´¾ßÌåµÄÊýÁ¿£¬ÓÃselect Count(*) ËÙ¶ÈÌ«Âý£¬
֮ǰ¿´µ½ËµÔÚsysindexesÖÐÓÐrows ÁУ¬ µ«ÊÇÎÒ·¢ÏÖ£¬ÕâÁ½¸öµÄÖµ²»Ò»Ñù£¬Ôõô»ØÊ°¡£¿
лл
ÓÐÈËÄܻشðÒ»ÏÂÂð? ²»ÊǺÜÃ÷°×°¡

Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ