Can i use Cursor within userdefined function In sql server 2005 manage code?

Question

By using cursor i want to make one virtual table. and after that using function i want to use that virtual table format and pass value of original table and then.. i show.. virtual table.. into output..

Answer 1

Yes. But you can also use SqlDataReader to accomplish the same. Note that you might have to create a new connection from the embedded c# (instead of using SQLContext).

string queryString = "SELECT OrderID, CustomerID FROM dbo.Orders;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand(queryString, connection);
    using (SqlDataReader reader = command.ExecuteReader())
    {
       while (reader.Read())
       {
          var c1 = reader[0];
          var c2 = reader[1];
          ....
       }
       reader.Close();
    }
}

Check this for an example of how to wrap this code inside a Table-Valued-Function.