Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7216 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
What does COMMIT command do?
What is the contrast between sql and mysql?
How can you ensure that the database and sql server based application perform well?
Is it possible to create trigger on views?
What are the tool windows in sql server management studio? : sql server management studio
What do you understand by a stored procedure?
How you would rewrite the sql query to return the customerid sorted numerically?
What are parameterized reports?
What is the chart in report?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is the contrast between sql and pl/sql?
Explain the working of sql privileges?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
what are candidate key, alternate key and composite key? : Sql server database administration
Differentiate between a having clause and a where clause.
