Insert Update Search DATABASE TABLEs Create / Insert

CREATE TABLE [dbo].[addcustomer](
[customerID] [int] IDENTITY(1,1) NOT NULL,
[firstname] [nvarchar](20) NOT NULL,
[middlename] [nvarchar](20) NOT NULL,
[lastname] [nvarchar](20) NOT NULL,
[dob] [date] NOT NULL,
[department] [nvarchar](20) NOT NULL,
[designation] [nvarchar](20) NULL,
[contactno] [nvarchar](10) NOT NULL,
[email] [nvarchar](50) NULL,
[IsActive] [bit] NULL,
PRIMARY KEY CLUSTERED
(
[customerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]




;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

INSERT INTO [customerDB].[dbo].[addcustomer]
           ([firstname]
           ,[middlename]
           ,[lastname]
           ,[dob]
           ,[department]
           ,[designation]
           ,[contactno]
           ,[email]
           ,[IsActive])
     VALUES
           (<firstname, nvarchar(20),>
           ,<middlename, nvarchar(20),>
           ,<lastname, nvarchar(20),>
           ,<dob, date,>
           ,<department, nvarchar(20),>
           ,<designation, nvarchar(20),>
           ,<contactno, nvarchar(10),>
           ,<email, nvarchar(50),>
           ,<IsActive, bit,>)
GO

Popular posts from this blog

How to create LOGIN page in MVC || RAJESH GAMI