WayneS (4/27/2009)

---

zsysop (4/27/2009)

---

Thanks, but wouldn't this still update all of the columns for where any of the passed in params are not equal? I would like it to update only...

Yeah i guess i do need to do 5 or more updates at once then. There are some procs with 20 params so i was looking for away around the...

Peso (4/27/2009)

---

create procedure update_user

(

@id int,

@name nvarchar(100),

@type nvarchar(6),

@add_date date,

@email varchar(50),

@phone int

)

as

set nocount on

UPDATEuser

setname=@name

, type=@type

, add_date=@add_date

, email =@email

, phone=@phone

WHEREid =@id

and (

name @name

or type @type

or add_date @add_date

or...

Okay that works but what if i were to pass in an invalid POST Direction and in the table it was null, then it would still match wouldnt it?

I...

Okay so i tried that code and i still couldnt get a match.

Now i also tried a simple select statement and did a comparison between

if column is null and column...

Ah Thanks!

So would this be okay?

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sp_GetStreetType]

(

@addrNumber [VarChar] (8),

@addrDirection [VarChar] (2),

...