Results 1 to 2 of 2

Thread: passing parameter to view

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 2003
    Location
    india
    Posts
    273

    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

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width