110,534
社区成员
发帖
与我相关
我的任务
分享
use theDB
GO
IF OBJECT_ID('theProc','P') IS NOT NULL
DROP PROC theProc
GO
CREATE PROC theProc
@input INT
AS
BEGIN
SELECT * FROM [dbo].[table] WHERE numer1=@input AND numer1=numer2;
END
GO
然后点运行生成存储过程
C#中调用存储过程
//.................
SqlCommand com = new SqlCommand("theProc", con);
com.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = com.ExecuteReader();
if(dr.Read())
{
true;
}
eles
{
false;
}
//.............