Update in SQL not updating 1

[idanner]

Can anyone help with this update. If I set the values directly in the procedure it updates. If I use the arguments then it want update.

IF OBJECT_ID('dbo.spUpdateMyCustomersName')IS NOT NULL
	DROP PROC spUpdateMyCustomersName
	GO

	CREATE PROCEDURE spUpdateMyCustomersName ( 
	@arg_CompanyName VARCHAR,  
	@arg_CustomerID NCHAR )
	AS
	BEGIN
	  
	UPDATE MyCustomers SET  
	CompanyName=@arg_CompanyName 
	WHERE  
	CustomerID=@arg_CustomerID
	     
	END;

	GO
	EXEC spUpdateMyCustomersName   
        @arg_CustomerID='DUMON',
	@arg_CompanyName='Down Under Pub'

Thank you for any help.

 

[SQLSister]

WHen you set your datatypes for your input variables you need to specify how many characters you want them to contain or SQL will use the default which is 1 for varchar and I'm not sure what for nChar as I never use it. At any rate it didn;t find a match for the where clause since it didn't contain all the characters needed. Hence, no update was performed.

Questions about posting. See faq183-874

 

[idanner]

Thank you SQLSister. You were exactly right!

 

[SQLSister]

Whne you've made the same mistake yourself, it's a whole lot easier to see in someone else's code!

Questions about posting. See faq183-874