Latest posts on "SQL"

I want to add new Column to table. But while saving, It showing this warning message and not allowed to save.

When I was tried to restore the database but the restore of database is failed and showing the following error message.

I got this following error when I tried to copy the database .mdf and .ldf files to another location.

When I tried to restore the SQL database it was failed and got the error message. " The backup set holds a backup of a database other than the existing 'DATABASE' database. "

When I tried to attach the SQL database to the local server I got this following error "access is denied".

In SQL Server we can use the SQL command to attach database to Microsoft Sql Server. Just copy the mdf file path and run with the following command.

In this video tutorial I will show how to export SQL Query results to excel using Microsoft SQL Server. After executing the SQL Query, in the results pane, click the top-left cell to highlight all the records, and then right-click the top-left cell and click "Save Results As" and give any name for it.

In this tutorial I will show you how to export data from remote server (godaddy live server) to local database. First of all create a database name in local server (any name) called “godaddyBackup”.

In this tutorial tutorial I will demonstrate you how to generate SQL Query Script for both schema and data using SQL Server management Studio 2012.

Initially I want to apply the foreign key for Student table .But the error occurred. Because of variation in data type. I got the following error “The following data type properties of the column do not match those of Data type, length, precision”