DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 637 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

Stories recently tagged with 'storedproc' Subscribe to this feed
17
kicks
published 2 months, 17 days ago, submitted by cheetahtech cheetahtech 2 months, 18 days ago

spoiledtechie.com — When life throws you hard balls, you can either step back and take a swing or bunt the hell out of it. I just recently went to an information session on T-SQL, Stored Procedures and now LINQ. These folks discussed stored procedures and why they are so important in the world today. read more...

Add a comment 2 comments | category: | Views: 503
tags: , , , , | tag it

3
kicks
submitted by xerratus 11 months, 27 days ago

xerratus.com — This one has been plaguing me for years: What is the best way to create a dynamic stored procedure that allows null inputs to filter results? Today, while working on another request to come up with a dynamic stored procedure for a specific report a client wants, I had an epiphany. If I use isnull() in conjunction to with the actual value, I can get the desired results, no matter what input(s) are null -if any or all. read more...

Add a comment add a comment | category: | Views: 3
tags: , , , | tag it

 

Sponsored Link: www.carlist.ie

Search:

Ads by The Lounge