s_mokhtari
پنج شنبه 06 خرداد 1389, 10:38 صبح
با سلام
من اين كد را نوشتم درجش درست فقط پيغام كه ميده متن را نشون ميده تعداد ركورد را نشونم نميده چرا
ALTER PROCEDURE [dbo].[STR_ADD_KOMISION]
(@sI int,
@dI int,
@sal nvarchar(9)
)
AS
insert into tbl_pardakh(customerid,driverid,scoolid,SAL)
SELECT dbo.Tbl_Customer.CustomerID, dbo.Tbl_Customer.DriverID, dbo.Tbl_Customer.ScoolID, dbo.Tbl_pardakh.sal
FROM dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo INNER JOIN
dbo.Tbl_pardakh ON dbo.Tbl_Scool.ScoolID = dbo.Tbl_pardakh.scoolid RIGHT OUTER JOIN
dbo.Tbl_Driver ON dbo.Tbl_pardakh.DriverID = dbo.Tbl_Driver.DriverID RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_pardakh.CustomerID = dbo.Tbl_Customer.CustomerID AND dbo.Tbl_Scool.ScoolID = dbo.Tbl_Customer.ScoolID AND
dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID
WHERE (dbo.Tbl_Customer.ScoolID = @sI) AND (dbo.Tbl_Customer.DriverID = @dI) AND (dbo.Tbl_pardakh.CustomerID IS NULL)
RAISERROR('اطلاعات با موفقيت ثبت شد',16,1,@@rowcount )
با تشكر
من اين كد را نوشتم درجش درست فقط پيغام كه ميده متن را نشون ميده تعداد ركورد را نشونم نميده چرا
ALTER PROCEDURE [dbo].[STR_ADD_KOMISION]
(@sI int,
@dI int,
@sal nvarchar(9)
)
AS
insert into tbl_pardakh(customerid,driverid,scoolid,SAL)
SELECT dbo.Tbl_Customer.CustomerID, dbo.Tbl_Customer.DriverID, dbo.Tbl_Customer.ScoolID, dbo.Tbl_pardakh.sal
FROM dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo INNER JOIN
dbo.Tbl_pardakh ON dbo.Tbl_Scool.ScoolID = dbo.Tbl_pardakh.scoolid RIGHT OUTER JOIN
dbo.Tbl_Driver ON dbo.Tbl_pardakh.DriverID = dbo.Tbl_Driver.DriverID RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_pardakh.CustomerID = dbo.Tbl_Customer.CustomerID AND dbo.Tbl_Scool.ScoolID = dbo.Tbl_Customer.ScoolID AND
dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID
WHERE (dbo.Tbl_Customer.ScoolID = @sI) AND (dbo.Tbl_Customer.DriverID = @dI) AND (dbo.Tbl_pardakh.CustomerID IS NULL)
RAISERROR('اطلاعات با موفقيت ثبت شد',16,1,@@rowcount )
با تشكر