i want to update query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

i want to update query

Author

Topic

immad
Posting Yak Master

230 Posts

Posted - 2014-02-28 : 01:05:13

hi
i make a procedure and it have 4 parameter like this
@ID as int,
@ICCD as varchar(50),
@MSISDN as varchar(50),
@LENICCID as int

and i update like this

exec [EVS_SP_UpdateSimAgent]
id--------2
ICCD ------'89234184500041292711','89234184500041292737','89234184500041292836'
MSISDN -------------''
LENICCID ------------20

but it gives me this error
EVS_SP_UpdateSimAgent has too many arguments specified.

thanks for the help

immad uddin ahmed

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-02-28 : 01:19:10

[code]
exec [EVS_SP_UpdateSimAgent] 2, '89234184500041292711,89234184500041292737,89234184500041292836', '', 20
[/code]

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources