Hi,
I am writing a vb.net2005 program that needs to create a stored procedure
with SqlServerProjec t Template.
Now, I have two questions for this stored procedure.
1) How can I import and execute the .dll in this Stored Procedures?
2) How can I connect the Web Service and get the result in this Stored
Procedures?
-------------------------------------------------------------------
Partial Public Class StoredProcedure s1
<Microsoft.SqlS erver.Server.Sq lProcedure()> _
Public Shared Sub GetTable()
Dim strSQL As String = "SELECT * FROM Table1"
Using conn As New SqlConnection(" context connection=true ")
Using cmd As New SqlCommand
With cmd
.Connection = conn
.CommandText = strSQL
.CommandType = CommandType.Tex t
conn.Open()
SqlContext.Pipe .ExecuteAndSend (cmd)
.Connection.Clo se()
End With
End Using
End Using
End Sub
End Class
-------------------------------------------------------------------
Thanks!