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.
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
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.