![]() ![]() Sys.tables and sys.columns, I used these queries to get view and stored procedure content: Next to a query that gets information from I remembered that a few years ago, I needed that same functionality, and I wrote a few scripts to search for specific dependencies in views and stored procedures. The company he works for (he is a software developer, and independant consultant) wanted to change all stored procedures, that contained functionality to calculate VAT (Value Added Tax). A few weeks ago, I received a message from an old colleague and friend Eric ( Blog | He wanted to know if I had a query in my (and I quote) “magic bag of SQL tricks”, to search through object in SQL server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |