T-SQL

Comparing ways to get rowcount from a database table.

posted @ Thursday, February 25, 2010 10:07 AM | Feedback (1)

Stop a SQL job in the first 5 days of the month, but report success

posted @ Tuesday, February 02, 2010 1:12 PM | Feedback (0)

Useful T-SQL queries on BizTalk Filter, Send Port, Receive Location, etc.

posted @ Wednesday, January 20, 2010 11:33 AM | Feedback (0)

BizTalk transaction even cover an "AFTER INSERT" trigger

posted @ Wednesday, December 30, 2009 12:25 PM | Feedback (0)

Final note on creating PDF using SSRS and SSIS

posted @ Tuesday, December 08, 2009 2:19 PM | Feedback (0)

Tricks to format XML properly for output from a SQL query

posted @ Thursday, December 03, 2009 1:44 PM | Feedback (0)

Calling SSRS report using either T-SQL or SSIS

posted @ Tuesday, November 24, 2009 2:53 PM | Feedback (0)

T-SQL extract multiple child node attribute data out of an XML datatype.

posted @ Monday, November 23, 2009 4:48 PM | Feedback (0)

Cannot do a reliable convert in the where clause for comparison

posted @ Tuesday, November 03, 2009 6:09 PM | Feedback (1)

Create synonym for all tables from another server or linked server object

posted @ Thursday, September 24, 2009 1:48 PM | Feedback (0)

Full T-SQL Archive

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski