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

ÇëÎÊÈçºÎÓÃSQLÓï¾äÉèÖÃ×ֶεÄIDENETITYÊôÐÔ£¿

ÒòΪƽʱÕâÖÖ²Ù×÷±È½Ï¶à£¬Ö±½ÓÔÚÊý¾Ý¿âÉÏÊÖ¶¯ÉèÖÃΣÏÕÐԽϴó£¬ËùÒÔÏëÓÃSQLÓï¾äʵÏÖ¡£
ÔÚÍøÉÏʵÔÚËѲ»µ½½á¹û£¬ÕâÀï¸ßÊֶ࣬ϣÍûÄܵõ½´ð°¸¡£
лл¡£
ÄãÏëÔõ麼設ÖÃ?

SQL code:
--´´½¨²âÊÔ±í
CREATE TABLE t1(ID int IDENTITY,A int)
GO
--²åÈë¼Ç¼
INSERT t1 VALUES(1)
GO

--1. ½«IDENTITY(±êʶ)ÁбäΪÆÕͨÁÐ
ALTER TABLE t1 ADD ID_temp int
GO

UPDATE t1 SET ID_temp=ID
ALTER TABLE t1 DROP COLUMN ID
EXEC sp_rename N't1.ID_temp',N'ID',N'COLUMN'
INSERT t1 VALUES(100,9)
GO

--2. ½«ÆÕͨÁбäΪ±êʶÁÐ
CREATE TABLE t1_temp(ID int,A int IDENTITY)
SET IDENTITY_INSERT t1_temp ON
INSERT t1_temp(ID,A) SELECT * from t1
SET IDENTITY_INSERT t1_temp OFF
DROP TABLE T1
GO

EXEC sp_rename N't1_temp',N't1'
INSERT t1 VALUES(109999)
GO

--ÏÔʾ´¦Àí½á¹û
SELECT * from t1
/*--½á¹û:
ID A
----------------- -----------
1 1
100 9
109999 10
--*/




SQL code:
ALTER TABLE ±íÃû ALTER COLUMN ×Ö¶ÎÃû IDENTITY(1,1)


SQL code:
ALTER TABLE ±íÃû ALTER COLUMN ×Ö¶ÎÃû int IDENTITY(1,1)


²Ý¸ùÐÖ£¬ÄãµÄSQLºÃÏñÓÐÓï·¨ÎÊÌ⣬ִÐгö´í¡£¡£¡£

Tony


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ