If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database.
Answer Posted / ramakrishna
select text from sysindexes
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Define full outer join in sql server joins?
List the ways in which dynamic sql can be executed?
What is the recursive stored procedure in sql server?
Where do we use trace frag?
Explain a join?
What are the steps you should follow to start sql server in single-user mode?
How to enter date and time literals in ms sql server?
How to insert and update data into a table with "insert" and "update" statements?
What is meant by indexing?
What is the difference between cartesian product and cross join?
What is wide table?
What are the difference between “where” and “having” clause in sql server?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is a database table?
How will you optimize a stored procedure optimization?