Welcome to MSDN Blogs Sign in | Join | Help

BizTalk Distilled

Sharing the defining moments

Browse by Tags

All Tags » SQL Server   (RSS)
Using READPAST with Order By clause in SQL Server with and without Index
Folks, I recently ran into this and decided to share this with the larger community... If you wanted to do a READPAST on the table but have on 'Order By' in your SQL query, it somehow does not return any row if there is an existing lock on a row (although Read More...
Posted: Friday, September 25, 2009 2:33 PM by rgarg | 0 Comments
Filed under:
Simple example of using BizTalk Business Rules Engine (BRE) with Database
Folks, I was recently building a proof of a rules based BizTalk Application for a customer where the specific requirement was to be able to change the rules in a simplistic way so that Business Users could update the rules without having to go through Read More...
Posted: Thursday, April 23, 2009 12:37 PM by rgarg | 4 Comments
Filed under: , , , ,
Timestamp data type in SQL Server
Just looking at the timestamp data type, I realized that in SQL Server this exposes an automatically generated unique binary number (basically to help in version-stamping the rows). The timestamp data type is just an incrementing number and has nothing Read More...
Posted: Monday, October 15, 2007 4:36 PM by rgarg | 5 Comments
Filed under: ,
Page view tracker