Viewing 9 posts - 1 through 9 (of 9 total)
I'd suggest using a case statement, too, for legibility and clarity which will help ease maintenance.
July 2, 2004 at 6:17 am
I don't know but just wondering if Oracle's transparent gateway for SQL Server might be able to help here.
April 28, 2004 at 5:35 am
sql-server-performance.com
March 11, 2004 at 6:10 am
I used coalesce in my stored procedure which has many optional input parameters as follows:
CREATE PROCEDURE sp_Example_Get
@inparm1INT= NULL
,@inparm2CHAR(1)= NULL
,@inparm3VARCHAR(10)= NULL
AS
BEGIN
Set NOCOUNT On
If @inparm1 = ''
Set @inparm1= null
If @inparm2= ''
Set...
March 5, 2004 at 7:01 am
Everything I've read has made me decide to always explicitly drop the temp tables at the end of my stored procedure in addition to checking if they exist at the...
October 30, 2003 at 6:12 am
These statistics are good indicators where indexes might enhance performance.
August 19, 2003 at 2:14 pm
try temp tables with indexes or new data type table
cursors are expensive
July 24, 2003 at 5:52 am
tek-tips.com
asp101.com
4guysfromrolla.com
devguru.com
learnasp.com
I use all of these plus googlegroups and this forum, of course!!
July 14, 2003 at 5:50 am
Viewing 9 posts - 1 through 9 (of 9 total)