SQL SERVER Tutorials
SQL Introduction
SQL Commands
Joins
Inner Join
Left Join
Right Join
Full Join
Sql Primary Key
Sql Foreign Key
Sql Server Tips
More Select Statements
Stored Procedure
User Defined Functions
Difference between Stored Procedures and Functions
Performance Tuning of Stored Procedure
Sql Views
Triggers
What is an Index
Clustered Index
Non Clustered Index
Difference between Clustered Index and Non Clustered Index
Using temp table in Stored Procedure of SQL Server
Passing datatable as parameter to Stored Procedure in ADO.Net C#
SQL Commands
Joins
Inner Join
Left Join
Right Join
Full Join
Sql Primary Key
Sql Foreign Key
Sql Server Tips
More Select Statements
Stored Procedure
User Defined Functions
Difference between Stored Procedures and Functions
Performance Tuning of Stored Procedure
Sql Views
Triggers
What is an Index
Clustered Index
Non Clustered Index
Difference between Clustered Index and Non Clustered Index
Using temp table in Stored Procedure of SQL Server
Passing datatable as parameter to Stored Procedure in ADO.Net C#
SQL Server Tips & Tricks for better performance
In this article, let us see the tips and tricks used in Sql server.When I create a table in SQL Server and save it, if I try to edit the table design, like change a column type from int to varchar, I get this error.
ERROR:- Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created.
Solution to solve the above Error:
Open SQL SERVER Editor, Go to Tools menu.To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.
