SQL Server

SQL Server: Database stuck in “Restoring” state

Problem: SQL Server: Database stuck in “Restoring” state Solution: You need to use the WITH RECOVERY option, with your database […]

Updated on     Kisan Patel

How to Import dBase Database into SQL Server?

Problems: How to convert Visual Foxpro database into SQL Server database? How to Import dBase Database into SQL Server? Import […]

Updated on     Kisan Patel

How to generate script from .sdf database?

Problem: How to generate script from sdf database? How to Convert .sdf database to .mdf database? How to migrate from […]

Updated on     Kisan Patel

Reset Identity Seed after deleting records in SQL Server

Problem: How to Reset Identity Seed after deleting records in SQL Server? Solution: The DBCC CHECKIDENT management command is used […]

Updated on     Kisan Patel

SQL Server : Bulk insert from one table to another

Problem: How to copying a huge table data into another table in sql server? Copying Data Between Servers How to […]

Updated on     Kisan Patel

SQL Server – Copy Table Schema and Data From One Database to Another Database

Problem: How to Copy Table Schema and Data From One Database to Another Database in SQL Server? Solution: If you […]

Updated on     Kisan Patel

How to Get All Months between two dates in SQL Server?

Problem: Is it possible to get all month names between two dates in SQL Server? Solution: You can do this […]

Updated on     Kisan Patel

Using aggregate functions in SQL Server

This tutorial will show you how to user aggregate functions like AVG, MIN, MAX, SUM etc in SQL Server? As […]

Updated on     Kisan Patel

Get the Installed SQL Server Name and Version?

This tutorial will show you how to know the installed SQL Server name and version? To get server name @@SERVERNAME […]

Updated on     Kisan Patel

Get Age in Year, Month and Day Format in SQL Server

This tutorial will show you how to get Age in year, month and date format in SQL Server? To get […]

Updated on     Kisan Patel