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.
- 2 Answers
- 7425 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sumesh.tc
SELECT syscomments.text AS text
FROM sysobjects INNER JOIN
syscomments ON sysobjects.id =
syscomments.id where sysobjects.name=(stored procedure name)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Equi join and non equi join is possible with sql server?
Why use identity in sql server?
When should you use an instead of trigger?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I find query history in sql server?
What are wait types?
What is subquery? Explain the properties of a subquery?
Can you index views?
What are the kinds of subquery?
Disadvantages of the indexes?
How to remove duplicate rows from table except one?
How to connect php with different port numbers?
What is acid mean in sql server?
Can we shrink data file in sql server?
