When working with Visual Studio and Oracle you will need to download Oracle’s Visual Studio Tools. Code Samples: http://www.oracle.com/technetwork/articles/dotnet/cook-dotnet-101788.html If I thought I could legally host the file I would. Official Page: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html If the link fails to work do a search on http://www.oracle.com/ for Visual Studio ODAC 11.2 Release…
Category: SQL
Show Duplicate Records
These two queries run under different schools of thought and purpose but will help in finding duplicate records. First, if you only want to see the records that are duplicates and the amount of times they appear in the table you could run this code: Second, if you want to…
Column Name Search
An extension of Table/View Column Information In the event that you need to find a table that has a specific column name.
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…