Use test Go If Object_id('ProcedureName') Is Not Null Drop Proc ProcedureName Go Create Proc ProcedureName (@input int) As Select @input+1 As x Go Exec ProcedureName 1/* x ----------- 2*/
USE Works; GO IF OBJECT_ID ( 'uspEmployees', 'P' ) IS NOT NULL DROP PROCEDURE uspEmployees; GO CREATE PROCEDURE uspEmployees(@str varchar(10)) AS SELECT * FROM table GO调用 :
Go
If Object_id('ProcedureName') Is Not Null
Drop Proc ProcedureName
Go
Create Proc ProcedureName
(@input int)
As
Select @input+1 As x
Go
Exec ProcedureName 1/*
x
-----------
2*/
USE Works;
GO
IF OBJECT_ID ( 'uspEmployees', 'P' ) IS NOT NULL
DROP PROCEDURE uspEmployees;
GO
CREATE PROCEDURE uspEmployees(@str varchar(10))
AS
SELECT * FROM table
GO调用 :
using(SQlconnection conn = new SQlconnection("连接字符串"))
{
SqlDataCommand cmd = new SqlDataCommand();
cmd.connection = conn;
cmd.CommandText="uspEmployees";
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@str",SqlDbType.Varchar);
cmd.Parameters["@str"].value="10000";
DataReader reader = cmd.ExcuteReader();
while(reader.Read())
{
////相关处理
}}
SqlConnection Conn1 = new SqlConnection();
Conn1.ConnectionString = "数据库连接字符串";
SqlCommand cmd1 = new SqlCommand("存储过程", Conn1);
cmd1.CommandType = CommandType.StoredProcedure;
Conn1.Open();
cmd1.EndExecuteNonQuery();
Conn1.Close();