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:
-
-
-
-
Code | MSSQL | MSSQL - Functions | SQL
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 function work http://stackoverflow.com/questions/11184476/how-to-calculate-age-in-t-sql-with-years-months-days-hours-minutes-seconds
-
-
-
-
You must be logged in to post a comment.