Error!
Success!

By tag: StoredProcedures

showing:  of
0
kicks

A better way to create a dynamic SQL stored procedure  (Unpublished)

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()...


Kicked By:
Drop Kicked By:
0
kicks

Passing Arrays or Tables as Parameters to a Stored Procedure  (Unpublished)

SQL Server has everything you need already in place to accept large, complicated sets of data as parameters in a stored procedure!


Kicked By:
Drop Kicked By:
0
kicks

"Global variables" in SQL Server  (Unpublished)

There's no such thing as a global variable in SQL Server. So i had to do it differently. Here's how.


Kicked By:
Drop Kicked By:
0
kicks

Is it really impossible to choose between LINQ and Stored Procedures?  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

Determine schema definitions of Stored Procedures  (Unpublished)

How to programatically retreive the schema returned by a stored procedure and store it in a DataTable.


Kicked By:
Drop Kicked By:
0
kicks

DLINQ with Stored Procedures  (Unpublished)

Scott Guthrie blogs about using DLINQ with SQL stored procedures


Kicked By:
Drop Kicked By: