Saving changes is not permitted in SQL Server

Error: Some time when we try to edit the table design, like change a column type from int to real, we usually get following error: Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can’t be […]

Read More

top 15 sql server interview questions with answers

Q. What is sub query and its properties? A. A sub-query is a query which can be nested inside a main query like Select, Update, Insert or Delete statements. This can be used when expression is allowed. Properties of sub query can be defined as A sub query should not have order by clause. A […]

Read More