?????SQL??似?????
???????????? ???????[ 2016/2/26 10:59:40 ] ????????SQL ?????
????1.?????????????????
????Alter TABLE [dbo].[CustomerBackupConfig] Add [Stamp] [timestamp] NULL
????GO
????2.??????????????????
????Alter Table tblStates Add [TaxRate] money not null default 0??
????[Transit] int not null default 0
????GO
????3.???????????????
????Alter Table [dbo].[tblOrder] Drop Column [CookieID]
????GO
????4.?????????????ε????
????Alter Table [dbo].[tblOrder] Alter Column [CookieID] int not null
????GO
????5.????????
????Drop Table tblTaxRate
????GO
????6.???????????????????????????????????????
????Alter TABLE [dbo].[OrderPackageOption] Drop CONSTRAINT [FK_OrderPackageOption_OrderPackage]
????ALTER TABLE [dbo].[OrderPackageOption] ADD
????CONSTRAINT [FK_OrderPackageOption_OrderPackage] FOREIGN KEY
????(
????[OrderPackageID]
????) REFERENCES [dbo].[OrderPackage] (
????[OrderPackageID]
????)
????GO
????7. ?????????????????????????????????????????????????????????????
????ALTER TABLE [dbo].[Account] ADD
????CONSTRAINT [FK_Account_State] FOREIGN KEY
????(
????[StateID]
????) REFERENCES [dbo].[State] (
????[StateID]
????)??
????CONSTRAINT [FK_Account_TimeZones] FOREIGN KEY
????(
????[TimeZoneID]
????) REFERENCES [dbo].[TimeZones] (
????[timeid]
????)
????GO
????Alter table [dbo].[Account] NoCheck Constraint [FK_Account_TimeZones]
????GO
????8. ????????????鵱?????
????ALTER TABLE [dbo].[Account] With NoCheck
????ADD CONSTRAINT [FK_Account_AccountType]
????FOREIGN KEY
????(
????[TypeID]
????) REFERENCES [dbo].[AccountType] (
????[TypeID]
????)
????GO
????9????????????????????????????????identity_insert??????????????????????????????е??飬?????в????????
????set identity_insert [dbo].[PSTNUsageNotes] on
????--????????ж?PSTNUsageNotes??????????????
????set identity_insert [dbo].[PSTNUsageNotes] off
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11