the following is the SP demo:
using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlServer;
using System.Data.SqlTypes;
public partial class StoredProcedures
{
[SqlProcedure]
public static void StoredProcedure1()
{
// Put your code here
SqlConnection cn = SqlContext.GetConnection();
SqlCommand cmd = cn.CreateCommand("select @@version");
SqlContext.GetPipe().Execute(cmd);
System.Threading.Thread.Sleep(5000);
SqlCommand cmd1 = cn.CreateCommand("select * from HumanResources.Department");
SqlContext.Pipe.Execute(cmd1);
}
};
using System.Data;
using System.Data.Sql;
using System.Data.SqlServer;
using System.Data.SqlTypes;
public partial class StoredProcedures
{
[SqlProcedure]
public static void StoredProcedure1()
{
// Put your code here
SqlConnection cn = SqlContext.GetConnection();
SqlCommand cmd = cn.CreateCommand("select @@version");
SqlContext.GetPipe().Execute(cmd);
System.Threading.Thread.Sleep(5000);
SqlCommand cmd1 = cn.CreateCommand("select * from HumanResources.Department");
SqlContext.Pipe.Execute(cmd1);
}
};