You can download SQL Northwind database bak file using below link or from Github.com. On Github script for the database is present. Official Microsoft site. DOWNLOAD… Read More »Download SQL NorthWind database BAK file
SQL database – How we can restore database. Follow below steps to restore your database: Select DatabaseName > Tasks > Restore > Database > Select… Read More »SQL Database – Steps to restore database
To get Column names of a table in SQL server use query below query: Select COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’Your_Table_Name’ For example: we will consider… Read More »SQL Server – How to get all Column names of a table
In this post I will show How we can download, install NorthWind Database in our SQL Management Studio. Install and Attach Northwind Database in SQL… Read More »Install and Attach Northwind Database in SQL Management Studio
SQL server Database as a function ‘SCOPE_IDENTITY()‘ which can be used to return the last created ID or Identity (Auto Incremented Primary Key) by the… Read More »SQL Getting Last Inserted Id using SCOPE IDENTITY
Let’s see a simple example on How we can return a parameter value using Stored Procedures in SQL server. SQL Stored Procedure Output Parameter Syntax,… Read More »SQL Server – Stored Procedure returning output parameter