SQL

Most Viewed first Recent First
185 1
What is database management system and it's types
In this article, I have explained what is a database management system with its advantages and types of database management system.
Type
Article
210 1
How to enable full text search on SQL Server database?

I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.

So, how can I enable full-text index to remove above error?

...
Type
Question
266 0
Drop all tables of SQL Server Database
In this article, I have provided various possible ways to delete all tables of SQL Server database, without deleting the main database.
Type
Article
2654 0
Tools to Compare Two SQL Server Database
In this article, I have provided list of various tools which can compare two SQL Server database schema and highlights the difference between the two.
Type
Article
654 0
Creating SQL Server Database using SQL Server Management Studio
In this article, I have provided step by step details with images about how to create a database in sql server using SQL Server management studio easily.
Type
Article

8642 0
How to back up SQL Server database ? (Various Ways explained)
This article explains various ways to backup SQL Server database using C#, using Powershell script, by generating scripts in SQL server or writing a script.
Type
Article
2724 0
Download AdventureWorks Database and Restore in SQL server (Step by Step)
In this article, I am going to provide steps to download AdventureWorks sample database and restore in SQL server to do sample tasks or learn SQL server with this AdventureWorks sample database.
Type
Article
7329 0
Restore (Import) database from .bak file in SQL server (With & without scripts)
In this short article, I am giving steps with images to restore database from .bak file in SQL server & I have also explained ways in sql server to restore database from bak file using script.
Type
Article
8851 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article
2800 1
Download and Install SQL Server (Step by Step procedure)
In this article, I have provided the guide to download and install sql server database on your machine with step by step procedure.
Type
Article

Page 1 of 7