July 16, 2010

Create Table Script in Sql Server

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableName](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[ColumnName] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO

....Creates a table with ID as Primary Key with an increment 1 starting with 1

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableName](
[ID] [bigint] IDENTITY(0,1) NOT NULL,
[ColumnName] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO

....Create a table with ID as Primary Key with an increment 1 starting with 0

No comments:

SonarQube with Jenkins Setup using Docker Images

https://funnelgarden.com/sonarqube-jenkins-docker/  https://medium.com/@hakdogan/an-end-to-end-tutorial-to-continuous-integration-and-con...