You don't have to be going to a stored procedure to use parameter inputs and the fact the data is being set tells me you aren't actually passing null in.

C#.NET

string...

Be sure you alter the file names if you resotre to the same server as it can overwirte your existing database. I would suggest do on another server for safety.

I don't agree with Bill Gates and Jim. A great programmer is not always set in the first 3-4 years, sometimes it takes longer especially if they are teaching themselves...

What exactly do you mean, filter to remove from the string, filter to remove / include from a return set?

A common trick used is by using a flag in your parameters and something like this

AND (total_balance = IsNull(NullIf(@Balance,0),total_balance))

Which is @Balance = 0 (or is null even) then all records...

I would ask what the purpose of the code actually is. There might be a good reason and there might not. It might also be the way they have always...

Backups have no relationship to FILEGROUPS.

The bennefit of multiple backups files in a spanned format is that one thread per backup device is created and operating. However if they are...

Thanks, my brain is still asleep. Well if anyone needs TSQL I will leave posted.

SQL Server does the best job determining what it needs because that can vary based on your databases needs, sometimes it can get large but you really should let SQL...

see if this doesn't help

--------------------start code---------------------------

set nocount on

DECLARE @x table (REC_ID int, PAT_ID int, ALERG_ID int, VALID_FROM datetime)

INSERT @x Values(1,101,1,'20070318')

INSERT @x Values(2,101,1,'20070418')

INSERT @x Values(3,101,1,'20070425')

INSERT @x Values(4,101,2,'20070425')

INSERT @x Values(5,102,2,'20070726')

INSERT @x Values(6,102,2,'20071221')

INSERT...

You are right should not have made any difference if the SELECT returns rows then the UPDATE should have affected them. Can you post your tables DDL so we can...

Based on what you have said and done I assume when you application makes the call to load the data using parameters you are adding using "" as the value...

Look at the topic "Query Window Statistics Pane" in SQL BOL.

What was the error you recevied as I have never had a problem with importing Access [Date/Time] into SQL Server datetime datatype. Or are you using text in Access with...

No reason to use Regular Expressions. The only thing that will trip up IsNumeric with regards to preference is money and decimal all you do is something like this

declare @x...