Stored procedures - 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

Stored procedures

Author

Topic

Mpilo
Yak Posting Veteran

52 Posts

Posted - 2008-09-10 : 06:51:20

Still dont get the solution
with my stored procedure
:ALTER PROCEDURE [dbo].[cityselects]
@CityName varchar(30)='',
@ProvinceName varchar(30)=''
AS
BEGIN
SELECT CityName
FROM City INNER JOIN provincedata
ON City.provincedatano = provincedata.provincedatano
WHERE provincedata.provincedataname = @ProvinceName
END

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-09-10 : 08:21:09

continue from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110352

Are you having problem with the Stored procedure or the ASP coding ?

When run your stored procedure in Query Analyser or SSMS, are you getting the result you expected ?

If not, show us your table structure, sample data and what is the expected result

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources