SQL Server

Specify auto-increment column initial value in SQL Server?

To specify see value and increment value to the auto increment column in the existing database table, we pass parameter […]

Updated on     Kisan Patel

Add column as primary key with auto-increment in existing database table

To create a new column in the existing database table as primary key and auto increment, execute following script in […]

Updated on     Kisan Patel

Create new Database User for SQL Server Database

This tutorial will explain how to create a new database user for SQL Server database in SQL Server 2008, SQL […]

Updated on     Kisan Patel

How to Backup a Database in SQL Server?

This tutorial will explain you how to take a backup of a database or create a backup file (.bak) of […]

Updated on     Kisan Patel

How to Restore a Database in SQL Server?

This tutorial will explain you how to restore a database using SQL Server Management Studio. To restore a database in […]

Updated on     Kisan Patel

How to return records in Group by a column value in SQL Server?

This tutorial will explain you how to return records in Group by a column value with HAVING and WHERE clause in […]

Updated on     Kisan Patel

SQL Server Data Types Reference

In this tutorial, we have list out the sql server data type with its range. To store any kind of […]

Updated on     Kisan Patel

How to Create Computed Column in SQL Server?

In this tutorial, you will learn how to create computed column in sql server? To create a computed column in […]

Updated on     Kisan Patel

What is View and How to Create View in SQL Server

This tutorial will explain you what is view and how to create view in SQL Server. A view in sql server […]

Updated on     Kisan Patel

Get Random Unique Value (GUID) in SQL Server?

To get a random unique value (Guid – Globally Unique Identifier) in SQL Server, we use NEWID function. SELECT NEWID() […]

Updated on     Kisan Patel