Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE SEQUENCE [dbo].[BikePartIdHelper]
- AS [int]
- START WITH 1
- INCREMENT BY 1
- MINVALUE 0
- MAXVALUE 2147483647
- CACHE
- GO
- CREATE TABLE [dbo].[BikeParts](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [BikeParts_GUID] AS ((replace(CONVERT([varchar](10),getdate(),(101)),'/','')+replace(CONVERT([varchar],getdate(),(8)),':',''))+right(replicate('0',(4))+CONVERT([varchar],[BikePart_ID]),(4))) PERSISTED,
- [BikePart_ID] [int] NOT NULL,
- [BikePart_Name] [varchar](100) NULL,
- CONSTRAINT [PK_BikeParts] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[BikeParts] ADD DEFAULT (NEXT VALUE FOR [dbo].[BikePartIdHelper]) FOR [BikePart_ID]
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement