19Apr/110
Passing a nullable/blank field to a WHERE statement
I’ve used this piece of code in many places lately to check if a field is nullable or blank – used mainly as a default value.
AND
(
@ResultType = ” OR
@ResultType ” AND ResultType IN(@ResultType)
)… Continue reading
5Apr/110
grant execute for a stored proc to application role
simple script incase you forget:
grant exec on to… Continue reading
Email Subscription
Latest Tweets
Good to see Barca & Real knocked out. Looking forward to Bayern & Dortmund #UCL - posted on 02/05/2013 06:42:32
Recent Comments
- loev on Click Frenzy 2013
- Joey on CodeIgniter – Bonfire
- peter on CodeIgniter – Bonfire
- Hakan on Uncaught Sys.ScriptLoadFailedException: Sys.ScriptLoadFailedException
- Joey on CodeIgniter – Bonfire
Categories
- afl (5)
- C# (30)
- ColdFusion (30)
- CSS (6)
- HTML5 (3)
- iPhone (19)
- Java (3)
- PHP (6)
- SQL (14)
- Stuff (105)
- Tennis (2)
Tags
apple
aspxgridview
c#
Cfwheels
chrome
code
code examples
coldfusion
css
database
devexpress
errors
examples
firefox
framework
fusebox
gmail
google
html
images
iOS
iOS5
ipad
iphone
iPhone3gs
iPhone4
iPhone4s
ipod
iTunes
java
javascript
Microsoft
mssql
myer
mysql
outlook
php
programs
server
sql
strings
svn
videos
windows
xampp
Advertising
Archives
- May 2013
- April 2013
- January 2013
- December 2012
- November 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- September 2009
- July 2009
- May 2009