|
-
Mar 25th, 2004, 08:26 AM
#1
Thread Starter
Hyperactive Member
passing parameter to view
Hello Dear
I am tring to pass the parameter to the View.It is giving me the syntax error
the code for your ref is :
alter VIEW temp_v_area
@area as varchar(15)
AS
SELECT *
FROM AREA
WHERE (AREANAME = @area)
please revert to me with possible solutions
I dougt whetherview accepts parameter?
Thanks in advance
PPCC
-
Mar 28th, 2004, 10:00 PM
#2
Hyperactive Member
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|