From .NET TO SQL
- by Berlioz
How do you pass a value from your DAL to your sproc so that the ISNULL function will do it's job.
Particularly the DATE value coming from my .NET assembly.
In T-SQL an INSERT STMNT and in the VALUES clause, the line of interest goes like this;
ISNULL(@myparm_forcolumn9, @myparm_forcolumn9). What value do I pass from .NET to make this line in my sproc work universally, so I don't have to write a millions INSERT SPROCS for every combination of columns??? I just want to write one stored procedure(sproc) that will handle all INSERTS in my universe.
