110,538
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data.SqlClient;
namespace ConsoleApp2
{
class Program
{
static void Main(string[] args)
{
//VS获取可用连接串: https://blog.csdn.net/yenange/article/details/77026214
//连接串自己改
string connString = @"Data Source=(local)\sqlserver2014;Initial Catalog=master;Integrated Security=True";
string sql = "select count(1) as cnt from master.dbo.spt_values where [type]='P' and [number]>=@n";
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@n", 0);
int cnt = Convert.ToInt32(cmd.ExecuteScalar());
Console.WriteLine("count: {0}",cnt);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.Read();
}
}
}