YES. we can!
1.Creating a stored procedure:
Use <DatabaseName>
Go
Create Proc Proc1
(
@Parameter1 Varchar(25)
)
As
Begin
set nocount on
Select @Parameter1 [Status]
end
Go
2. Calling procedure from SELECT statement!
Use <DatabaseName>
Go
Select * from Openrowset('SQLNCLI', 'Server=<ServerName>;Trusted_Connection=yes;','Exec <DatabaseName>.dbo.Proc1 ''Dotnet Funda!''')
go
3. Result from procedure!
Status
-----------
Dotnet Funda!
Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions
Jasminej, if this helps please login to Mark As Answer. | Alert Moderator