這個意思?Alter Table TEST Add New_ID As Convert(Varchar(10), GetDate(), 112) + Cast(ID As Varchar)
--創建測試表 Create Table TEST(ID Int Identity(1, 1), Name Varchar(10)) GO --增加字段 Alter Table TEST Add New_ID As Convert(Varchar(10), GetDate(), 112) + Cast(ID As Varchar) GO --測試 Insert TEST(Name) Select 'A' Union All Select 'B' Union All Select 'C'Select * From TEST GO --刪除測試環境 Drop Table TEST --結果 /* ID Name New_ID 1 A 200706091 2 B 200706092 3 C 200706093 */
Create Table TEST(ID Int Identity(1, 1), Name Varchar(10))
GO
--增加字段
Alter Table TEST Add New_ID As Convert(Varchar(10), GetDate(), 112) + Cast(ID As Varchar)
GO
--測試
Insert TEST(Name) Select 'A'
Union All Select 'B'
Union All Select 'C'Select * From TEST
GO
--刪除測試環境
Drop Table TEST
--結果
/*
ID Name New_ID
1 A 200706091
2 B 200706092
3 C 200706093
*/