An extension of Table/View Column Information In the event that you need to find a table that has a specific column name.
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Search All Tables Function
If you have access to create functions/procedures use this script. Run the above function like this If you don’t have access to create functions/procedures use this script.
MSSQL – Table/View Column Information
Similar to MySQL – Table/View Column Information, this post will help with MSSQL tables and columns. Cleaner Result: All Tables Result:
Calculate Age Function
Two variations of the function but the purpose is to determine the difference in dates and display the result in one column. Result: 31 years,5 months,26 days Detailed Credit goes to armen at http://stackoverflow.com/users/395720/armen While his response on this URL isn’t a function it is his code that makes the…
You must be logged in to post a comment.