create procedure sp_employee
as
begin
SELECT empid, empname, empdestination, empemail, empmobile
FROM employee
end
select empid,empname,empmobile exec sp_employee
is it correct?
select empid,empname,empmobile exec sp_employee
is it correct?
brunda kPosted Jun 6, 2012, 12:32 PM
SELECT empid,empname,empmobile FROM OPENQUERY ([SERVERNAME],'EXECUTE DatabaseName.dbo.sp_employee')
Ref:http://sqlusa.com/bestpractices2005/selectfromsproc/
VulpesPosted Jun 6, 2012, 11:56 AM