UC知道关于SQL存储过程
来源：百度知道 编辑：UC知道 时间：2024/05/12 16:23:43
CREATE PROCEDURE sp_GetDispatchById(
@RecordId int)
AS
select r.RDetails,r.ClientName,r.CPerson, r.CTel,
r.LogPerson,r.CreateDate,r.FinishDate,d.Opinion,d.Engineer,
d.DealWithDate,d.SubmitPerson,d.SubmitDate
from Records r,ReDispatch d
where d.RecordId=r.RecordId and r.RecordId=@RecordId
GO
我看不懂 帮忙看下其详细作用和处理过程
@RecordId int)
AS
select r.RDetails,r.ClientName,r.CPerson, r.CTel,
r.LogPerson,r.CreateDate,r.FinishDate,d.Opinion,d.Engineer,
d.DealWithDate,d.SubmitPerson,d.SubmitDate
from Records r,ReDispatch d
where d.RecordId=r.RecordId and r.RecordId=@RecordId
GO
我看不懂 帮忙看下其详细作用和处理过程
创建存储过程sp_GetDispatchById 并带输入参数@Recordid (类型是int)
as 是关键字. go是执行的意思.
从select 到 go前的意思是:
查询Records,ReDispatch这两个表(缩写为r,d)中的以下几个字段:
Records表中字段:RDetails,ClientName,CPerson,CTel,LogPerson,CreateDate,FinishDate
ReDispatch表中字段:Opinion,Engineer,DealWithDate,SubmitPerson,SubmitDate
查询条件为:d.RecordId=r.RecordId and r.RecordId=@RecordId
输入参数@Recordid
查询
select r.RDetails,r.ClientName,r.CPerson, r.CTel,
r.LogPerson,r.CreateDate,r.FinishDate,d.Opinion,d.Engineer,
d.DealWithDate,d.SubmitPerson,d.SubmitDate
from Records r,ReDispatch d
where d.RecordId=r.RecordId and r.RecordId=@RecordId
创建存储过程sp_GetDispatchById
带输入参数@Recordid