-> How to Configure Basic setting of SQL Server 2019 and open ‘sa’  User and activate Authentication mode.

Microsoft SQL Server 2019 – Enable Authentication and server ModeDownload

-> Learn to Create Database and tables for Beginners and set Indexes with Identity column

Microsoft SQL Server 2019 Creating Data BaseDownload

-> Add SQL Server Database Project in Visual Studio with complete Configuration and Integration

Download Integration of SQL Server With Visual Studio

SQL Server Database in Visual Studio with MVC 5Download

-> Configure MS SQL Azure Server on AQUA Data Studio

AQUA Configuration Server ConfigurationDownload



Generate sql insert script from excel worksheet

=”INSERT INTO table_name VALUES(‘”&A1&”‘,'”&B1&”‘,'”&C1&”‘)”

-> How to use two identity or auto increment column in one table in sql?

Use two Identity Columns in SQL

Create SEQUENCE MySequence Start With 100;
 go
 CREATE TABLE Complains
 (
     ComplainId INT NOT NULL PRIMARY KEY IDENTITY, 
     Complain VARCHAR(100) NULL, 
     CustomerId INT NULL, 
     TicketNo INT NOT NULL DEFAULT NEXT VALUE FOR MySequence 
     )

Convert Data from Table to XML Format using XML Path
  -> SELECT * FROM @EXAMPLE FOR XML PATH(‘Node’), ROOT(‘Root’)