Error in Stored procedure - 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

Other Forums

SQL Server 6.5 \ SQL Server 7.0

Error in Stored procedure

Author

Topic

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-03-19 : 09:26:10

I am getting an error as Incorrect syntax near ".".

Can some body help
Here is the code.I am trying to create stroed procedure


Create Procedure sp_GetFileList(@sFileids nvarchar(100))
as
select b.Filename,b.FilePath,b.fileid,b.fsize,b.modifieddate, _
a.softID,a.softName,a.displayName,a.Softpath,a.type from softwaredetails b,mstsoftware a where a.softid=b.softid and a.softid in (@sFieldids)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-19 : 09:28:13

try


select b.[Filename]

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-03-19 : 09:32:01

Thanks Khan,
Now the error is "Must declare the variable '@sFieldids'."

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-03-19 : 10:03:38

I got it.Sorry I have misspelled the declartion of the sFieldids
Thanks to every one

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-03-20 : 00:04:03

Dear All ,
Now I am facing one problem.When I execute the sp using one varriable like
sp_GetFilelist 1 ,it is working .But Now I want to call the sp with more than one arguments like
'1','2'.But I am getting an error that so many arguments.How can I solve this problem

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources