110,535
社区成员
发帖
与我相关
我的任务
分享
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection())
{
conn.ConnectionString = "server=xxx;pwd=***;uid=sa;database=tempdb";
conn.Open();
using (System.Data.SqlClient.SqlCommand command = conn.CreateCommand())
{
command.CommandText = @"with ce1 as(
select [dbo].[GetType]('2') as type,name
from sysobjects
)
select *
from ce1 ";
using (System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(command))
{
System.Data.DataSet ds=new DataSet();
adp.Fill(ds);
Console.WriteLine(ds.GetXml());
}
}
}