create proc dbo.SP_Test
@date datetime
as
select colxx from tablexx where timexx>@date
调用:
.net:SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_Test";
cmd.Connection = new SqlConnection(cnstr);
cmd.Parameters.add("SP_Test",DbType.DateTime,8);
cmd.Parameters["@date"].Value = DateTime.Now;
DataSet ds = new DataSet();
using(SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(ds);
}
@date datetime
as
select colxx from tablexx where timexx>@date
调用:
.net:SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_Test";
cmd.Connection = new SqlConnection(cnstr);
cmd.Parameters.add("SP_Test",DbType.DateTime,8);
cmd.Parameters["@date"].Value = DateTime.Now;
DataSet ds = new DataSet();
using(SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(ds);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货