求一段修改表结构的代码--不难但是可能有些麻烦!
修改前的表的脚本
CREATE TABLE [dbo].[hr_pay_rec] (
[rowid] [uniqueidentifier] NOT NULL ,
[orgid] [int] NOT NULL ,
[payday] [smalldatetime] NULL ,
[edbase] [varchar] (200) NOT NULL ,
[taxbase] [varchar] (250) NOT NULL ,
[mplus] [varchar] (250) NOT NULL ,
[mminus] [varchar] (250) NOT NULL ,
[spay] [varchar] (200) NOT NULL ,
[apay] [varchar] (200) NOT NULL ,
[tcard] [varchar] (200) NOT NULL ,
[sumoftotal] [numeric](10, 2) NOT NULL ,
[sumofactual] [numeric](10, 2) NOT NULL ,
[calcbase1] [numeric](8, 2) NOT NULL ,
[calcbase2] [numeric](8, 2) NOT NULL ,
[calcbase3] [numeric](8, 2) NOT NULL ,
[keepid] [bit] NOT NULL ,
[abstractid] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[hr_pay_rec] ADD
CONSTRAINT [DF_hr_pay_rec_rowid] DEFAULT (newid()) FOR [rowid],
CONSTRAINT [DF_hr_pay_rec_edbase] DEFAULT ('') FOR [edbase],
CONSTRAINT [DF_hr_pay_rec_taxbase] DEFAULT ('') FOR [taxbase],
CONSTRAINT [DF_hr_pay_rec_mplus] DEFAULT ('') FOR [mplus],
CONSTRAINT [DF_hr_pay_rec_mminus] DEFAULT ('') FOR [mminus],
CONSTRAINT [DF_hr_pay_rec_spay] DEFAULT ('') FOR [spay],
CONSTRAINT [DF_hr_pay_rec_apay] DEFAULT ('') FOR [apay],
CONSTRAINT [DF_hr_pay_rec_tcard] DEFAULT ('') FOR [tcard],
CONSTRAINT [DF_hr_pay_rec_sumoftotal] DEFAULT (0) FOR [sumoftotal],
CONSTRAINT [DF_hr_pay_rec_sumofactual] DEFAULT (0) FOR [sumofactual],
CONSTRAINT [DF_hr_pay_rec_calcbase1] DEFAULT (0) FOR [calcbase1],
CONSTRAINT [DF_hr_pay_rec_calcbase2] DEFAULT (0) FOR [calcbase2],
CONSTRAINT [DF_hr_pay_rec_calcbase3] DEFAULT (0) FOR [calcbase3],
CONSTRAINT [DF_hr_pay_rec_keepid] DEFAULT (0) FOR [keepid],
CONSTRAINT [DF_hr_pay_rec_abstractid] DEFAULT (0) FOR [abstractid],
CONSTRAINT [PK_hr_pay_rec] PRIMARY KEY NONCLUSTERED
(
[rowid]
) ON [PRIMARY] ,
CONSTRAINT [IX_hr_pay_rec] UNIQUE NONCLUSTERED
(
[orgid],
[payday]
) ON [PRIMARY]
GO
修改后的表
CREATE TABLE [dbo].[hr_pay_rec] (
[rowid] [uniqueidentifier] NOT NULL ,
[id] [int] IDENTITY (1, 1) NOT NULL ,
[salaryname] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[orgid] [int] NOT NULL ,
[payday] [smalldatetime] NULL ,
[edbase] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[taxbase] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mplus] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mminus] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[spay] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[apay] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[tcard] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sumoftotal] [numeric](10, 2) NOT NULL ,
[sumofactual] [numeric](10, 2) NOT NULL ,
[calcbasename] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[calcbase1] [numeric](8, 2) NOT NULL ,
[calcbase2] [numeric](8, 2) NOT NULL ,
[calcbase3] [numeric](8, 2) NOT NULL ,
[lister] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isvoucher] [tinyint] NULL ,
[keepid] [bit] NOT NULL ,
[abstractid] [bit] NOT NULL ,
[note] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[auditid] [tinyint] NOT NULL ,
[auditopinion] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[typeid] [tinyint] NOT NULL ,
[taxid] [bit] NULL ,
[operationid] [tinyint] NULL ,
[taxitem] [tinyint] NULL ,
[taxmode] [bit] NULL ,
[taxtype] [bit] NULL ,
[mergetaxtable] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[taxstartpoint] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[calcformulanote] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[salaryitemname] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[GiveState] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[hr_pay_rec] ADD
CONSTRAINT [DF_hr_pay_rec_rowid] DEFAULT (newid()) FOR [rowid],
CONSTRAINT [DF_hr_pay_rec_edbase] DEFAULT ('') FOR [edbase],
CONSTRAINT [DF_hr_pay_rec_taxbase] DEFAULT ('') FOR [taxbase],
CONSTRAINT [DF_hr_pay_rec_mplus] DEFAULT ('') FOR [mplus],
CONSTRAINT [DF_hr_pay_rec_mminus] DEFAULT ('') FOR [mminus],
CONSTRAINT [DF_hr_pay_rec_spay] DEFAULT ('') FOR [spay],
CONSTRAINT [DF_hr_pay_rec_apay] DEFAULT ('') FOR [apay],
CONSTRAINT [DF_hr_pay_rec_tcard] DEFAULT ('') FOR [tcard],
CONSTRAINT [DF_hr_pay_rec_sumoftotal] DEFAULT (0) FOR [sumoftotal],
CONSTRAINT [DF_hr_pay_rec_sumofactual] DEFAULT (0) FOR [sumofactual],
CONSTRAINT [DF_hr_pay_rec_calcbase1] DEFAULT (0) FOR [calcbase1],
CONSTRAINT [DF_hr_pay_rec_calcbase2] DEFAULT (0) FOR [calcbase2],
CONSTRAINT [DF_hr_pay_rec_calcbase3] DEFAULT (0) FOR [calcbase3],
CONSTRAINT [DF_hr_pay_rec_isvoucher] DEFAULT (0) FOR [isvoucher],
CONSTRAINT [DF_hr_pay_rec_keepid] DEFAULT (0) FOR [keepid],
CONSTRAINT [DF_hr_pay_rec_abstractid] DEFAULT (0) FOR [abstractid],
CONSTRAINT [DF_hr_pay_rec_auditid] DEFAULT (0) FOR [auditid],
CONSTRAINT [DF_hr_pay_rec_typeid] DEFAULT (1) FOR [typeid],
CONSTRAINT [DF_hr_pay_rec_taxid] DEFAULT (0) FOR [taxid],
CONSTRAINT [DF_hr_pay_rec_operationid] DEFAULT (0) FOR [operationid],
CONSTRAINT [DF_hr_pay_rec_taxitem] DEFAULT (1) FOR [taxitem],
CONSTRAINT [DF_hr_pay_rec_taxmode] DEFAULT (0) FOR [taxmode],
CONSTRAINT [DF_hr_pay_rec_taxtype] DEFAULT (0) FOR [taxtype],
CONSTRAINT [DF_hr_pay_rec_mergetaxtable] DEFAULT ('') FOR [mergetaxtable],
CONSTRAINT [DF_hr_pay_rec_taxstartpoint] DEFAULT ('') FOR [taxstartpoint],
CONSTRAINT [DF_hr_pay_rec_GiveState] DEFAULT (0) FOR [GiveState],
CONSTRAINT [PK_hr_pay_rec] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
谢谢大家了!