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 'StoredProcedures' Subscribe to this feed
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

13
kicks
published 1 year, 6 months ago, submitted by terrble 1 year, 6 months ago

weblogs.sqlteam.com — SQL Server has everything you need already in place to accept large, complicated sets of data as parameters in a stored procedure! read more...

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

9
kicks
published 1 year, 8 months ago, submitted by spirit1 1 year, 8 months ago

weblogs.sqlteam.com — There's no such thing as a global variable in SQL Server. So i had to do it differently. Here's how. read more...

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

3
kicks
submitted by aabs 1 year, 9 months ago

aabs.wordpress.com — What is the elephant in the room of software engineering? We don't know how to tell which of two competing designs is the better. We can't make informed choices between architectures. Software engineering is in need of an enlightenment. read more...

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

12
kicks
published 1 year, 9 months ago, submitted by rimsystems rimsystems 1 year, 10 months ago

blogs.msdn.com — How to programatically retreive the schema returned by a stored procedure and store it in a DataTable. read more...

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

5
kicks
published 2 years, 6 months ago, submitted by gavinjoyce gavinjoyce 2 years, 6 months ago

weblogs.asp.net — Scott Guthrie blogs about using DLINQ with SQL stored procedures read more...

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

 

Sponsored Link: www.carlist.ie

Search:

Ads by The Lounge