Viewing 5 posts - 1 through 5 (of 5 total)
...snipped...
As you can see, this query is a maintenance problem. You should have a table called Deaths with the column Yr_Died. The table can be populated with any year. A...
September 17, 2013 at 7:28 pm
Andrew Fowler-367854 (8/26/2010)
Perry, even using .net your failover might not be seamless if you are using connection pooling. Atleast that has been my experience.
I actually tested this for a...
September 5, 2010 at 6:40 pm
Reading SQL Server Books Online (BOL) for "CREATE PROCEDURE" states that...
"All data types, except the table data type, can be used as a parameter for a stored procedure"
I had the...
August 23, 2005 at 7:47 pm
I understand what Hector is trying to do... I've encountered the same problem and used the very same approach to work around it.
The inserts into table2 are used to audit/trace...
May 19, 2005 at 5:20 pm
It is now recommended to use the TABLE variable, rather than temp tables (see SQL Books Online)
Try this instead...
ALTER PROCEDURE dbo.Product_SelectByIndexAndSize (
@index INT,
@Size INT
)
AS
SET NOCOUNT ON
DECLARE...
April 4, 2005 at 5:11 pm
Viewing 5 posts - 1 through 5 (of 5 total)