MSSQLµÄsqlÓï¾ä

ÎÒÔ­À´ÊÇÓÉaccessת³ÉmssqlµÄ..Ô­À´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË
ÎÒÔõôÓÃsqlÀ´×ª»¯ÄØ£¿£¨²»ÏëÔÚÆóÒµÃæ°å¹ÜÀíÖÐ¸Ä ±íÌ«¶à..£©

»¹ÓÐsmalldateµÄĬÈÏÖµ¸Ä³Égetdate()µÄÓï¾äÒªÔõôд..ллÁË

---

accessת³ÉmssqlµÄ..Ô­À´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË

Ö»ÄÜ×Ô¼º¼ÓÁË

---

²»ÄÜÓÃsqlÀ´Éý¼¶²»£¿alert table a modify ....ÕâÑùµÄ²»ÐУ¿

---

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
--*/

---

ÎÒ¾õµÃ»¹ÊÇÔÚÆóÒµ¹ÜÀíÆ÷ÉÏÃæ×ö¼òµ¥Ð©

---

ллÁË ÄÇÎÒµ½ÆóÒµÃæ°åÉϸİÉ