Skip to main content

Posts

Showing posts with the label SQL Queries Create Insert Update Delete

SQL Queries Create Insert Update Delete

Hello everyone, I am going to share the code sample for creating query for Create, Insert,   Update and Delete in SQL Server. The Queries in detail as given below. /****** THE SQL QUERY FOR CREATE, INSERT, SELECT, UPDATE AND DELATE  ******/   --CRETAE TABLE QUERY   --START QUERY   CREATE TABLE [DBO] . [TENANT] (             [TENANTID] [BIGINT] IDENTITY ( 1 , 1 ) NOT NULL,             [NAME] [NVARCHAR] ( 50 ) NOT NULL,             [ADDRESS] [NVARCHAR] ( 2000 ) NULL,             [CONTACTNUMBER] [NVARCHAR] ( 50 ) NULL,             [WEBSITE] [NVARCHAR] ( 80 ) NULL,             [REGNID] [NVARC...