Search This Blog
I felt it's useful to post blogs on Topic of Interests on Microsoft Sql Server BI, Technical articles and links, Issues and Workarounds came across while working on Projects. Thanks for those who visit my blog. By the way, Please post your feedback if it was useful to you..
Posts
Showing posts with the label T-SQL Programming
Converting non-ansi *= or =* to SQL 92 type / ansi joins
- Get link
- X
- Other Apps
Did you know that ISNULL function can take Query as a parameter ?
- Get link
- X
- Other Apps
Passing DataTable into a StoredProcedure
- Get link
- X
- Other Apps
List of all Procedures and dependant Tables that are updated using linked server
- Get link
- X
- Other Apps
Useful T-Sql Snippets for my Reference
- Get link
- X
- Other Apps
Get the Row Counts for all tables in Database in Sql Server 2005
- Get link
- X
- Other Apps
Extract Last 12 months data if you have a Month_Code Column of the format 'YYYYMM'
- Get link
- X
- Other Apps
Populating Oracle Timestamp values into Sql Server Datetime
- Get link
- X
- Other Apps