EXECUTION OF PROCEDURES

[ijitnoin]

If have created Views of which I assume can be called by an application to create a form or report. I am not sure how this work.

My problem mainly is how to execute a procedure to see/test the output; verifying that the results are acquate.

 

[SQLDenis]

Don't know If I understand you completely but take a look at this

create procedure prTestViews 
@id int
as

set nocount on

select * from YourView
where id = @id

set nocount off

then to test

exec prTestViews 1

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/