没有输入参数的存储过程
1首先在SQL Server中使用存储过程
CREATE procedure [dbo].[sp_fuck]
as
select Sage,Sname,Ssex
from Students
order by Sage,sname
2然后创建一个控制台应用程序项目
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace CallSp1
{
class Program
{
static void Main(string[] args)
{
//Create connection
SqlConnection conn = new SqlConnection
(@"server=./WB_JAMES;
integrated security = SSPI;
database = master"
);
try
{
conn.Open();//open connection
SqlCommand cmd = conn.CreateCommand();//create command;
cmd.Comman