من فقط کدتان را طوری اصلاح کردن که دیگر error نده
ALTER PROCEDURE [34]
@si int,
@name nvarchar(50)=null,
@school int=null,
@driver int=null
AS
if (@name is not null and @school is null and @driver is null)
INSERT INTO TBL_PARDAKH
SELECT TOP (100) PERCENT dbo.Tbl_Customer.CustomerID As كد, dbo.Tbl_Customer.LastName + ' ' + dbo.Tbl_Customer.FirstName AS فاميل,
dbo.Tbl_Customer.Namfader AS نامپدر, dbo.Tbl_Customer.Klas As كلاس, dbo.Tbl_Customer.Tel1 As تلفن, dbo.Tbl_Customer.Mobile1 AS همراه, dbo.Tbl_Customer.Mobile2 AS همراه2,
dbo.Tbl_Customer.Address As آدرس, dbo.Tbl_Customer.mrz AS شرح
FROM dbo.Tbl_Driver RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID LEFT OUTER JOIN
dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo ON dbo.Tbl_Customer.ScoolID = dbo.Tbl_Scool.ScoolID
WHERE (dbo.Tbl_Customer.LastName LIKE @name + '%') order by فاميل
if (@name is not null and @school is not null and @driver is null)
INSERT INTO TBL_PARDAKH
SELECT TOP (100) PERCENT dbo.Tbl_Customer.CustomerID As كد, dbo.Tbl_Customer.LastName + ' ' + dbo.Tbl_Customer.FirstName AS فاميل,
dbo.Tbl_Customer.Namfader AS نامپدر, dbo.Tbl_Customer.Klas As كلاس, dbo.Tbl_Customer.Tel1 As تلفن, dbo.Tbl_Customer.Mobile1 AS همراه, dbo.Tbl_Customer.Mobile2 AS همراه2,
dbo.Tbl_Customer.Address As آدرس, dbo.Tbl_Customer.mrz AS شرح
FROM dbo.Tbl_Driver RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID LEFT OUTER JOIN
dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo ON dbo.Tbl_Customer.ScoolID = dbo.Tbl_Scool.ScoolID
WHERE (dbo.Tbl_Customer.LastName LIKE @name + '%') and tbl_customer.scoolid=@school order by فاميل
if (@name is not null and @school is not null and @driver is not null)
INSERT INTO TBL_PARDAKH
SELECT TOP (100) PERCENT dbo.Tbl_Customer.CustomerID As كد, dbo.Tbl_Customer.LastName + ' ' + dbo.Tbl_Customer.FirstName AS فاميل,
dbo.Tbl_Customer.Namfader AS نامپدر, dbo.Tbl_Customer.Klas As كلاس, dbo.Tbl_Customer.Tel1 As تلفن, dbo.Tbl_Customer.Mobile1 AS همراه, dbo.Tbl_Customer.Mobile2 AS همراه2,
dbo.Tbl_Customer.Address As آدرس, dbo.Tbl_Customer.mrz AS شرح
FROM dbo.Tbl_Driver RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID LEFT OUTER JOIN
dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo ON dbo.Tbl_Customer.ScoolID = dbo.Tbl_Scool.ScoolID
WHERE (dbo.Tbl_Customer.LastName LIKE @name + '%') and tbl_customer.scoolid=@school and tbl_customer.driverid=@driver order by فاميل
/*name is null*/
if (@name is null and @school is null and @driver is null)
INSERT INTO TBL_PARDAKH
SELECT TOP (100) PERCENT dbo.Tbl_Customer.CustomerID As كد, dbo.Tbl_Customer.LastName + ' ' + dbo.Tbl_Customer.FirstName AS فاميل,
dbo.Tbl_Customer.Namfader AS نامپدر, dbo.Tbl_Customer.Klas As كلاس, dbo.Tbl_Customer.Tel1 As تلفن, dbo.Tbl_Customer.Mobile1 AS همراه, dbo.Tbl_Customer.Mobile2 AS همراه2,
dbo.Tbl_Customer.Address As آدرس, dbo.Tbl_Customer.mrz AS شرح
FROM dbo.Tbl_Driver RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID LEFT OUTER JOIN
dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo ON dbo.Tbl_Customer.ScoolID = dbo.Tbl_Scool.ScoolID
WHERE (dbo.Tbl_Customer.LastName LIKE @name + '%') order by فاميل
if (@name is null and @school is not null and @driver is null)
INSERT INTO TBL_PARDAKH
SELECT TOP (100) PERCENT dbo.Tbl_Customer.CustomerID As كد, dbo.Tbl_Customer.LastName + ' ' + dbo.Tbl_Customer.FirstName AS فاميل,
dbo.Tbl_Customer.Namfader AS نامپدر, dbo.Tbl_Customer.Klas As كلاس, dbo.Tbl_Customer.Tel1 As تلفن, dbo.Tbl_Customer.Mobile1 AS همراه, dbo.Tbl_Customer.Mobile2 AS همراه2,
dbo.Tbl_Customer.Address As آدرس, dbo.Tbl_Customer.mrz AS شرح
FROM dbo.Tbl_Driver RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID LEFT OUTER JOIN
dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo ON dbo.Tbl_Customer.ScoolID = dbo.Tbl_Scool.ScoolID
WHERE (dbo.Tbl_Customer.LastName LIKE @name + '%') and tbl_customer.scoolid=@school order by فاميل
if (@name is null and @school is not null and @driver is not null)
INSERT INTO TBL_PARDAKH
SELECT TOP (100) PERCENT dbo.Tbl_Customer.CustomerID As كد, dbo.Tbl_Customer.LastName + ' ' + dbo.Tbl_Customer.FirstName AS فاميل,
dbo.Tbl_Customer.Namfader AS نامپدر, dbo.Tbl_Customer.Klas As كلاس, dbo.Tbl_Customer.Tel1 As تلفن, dbo.Tbl_Customer.Mobile1 AS همراه, dbo.Tbl_Customer.Mobile2 AS همراه2,
dbo.Tbl_Customer.Address As آدرس, dbo.Tbl_Customer.mrz AS شرح
FROM dbo.Tbl_Driver RIGHT OUTER JOIN
dbo.Tbl_Customer ON dbo.Tbl_Driver.DriverID = dbo.Tbl_Customer.DriverID LEFT OUTER JOIN
dbo.Tbl_ScoolM INNER JOIN
dbo.Tbl_Scool ON dbo.Tbl_ScoolM.ScoolNo = dbo.Tbl_Scool.ScoolNo ON dbo.Tbl_Customer.ScoolID = dbo.Tbl_Scool.ScoolID
WHERE (dbo.Tbl_Customer.LastName LIKE @name + '%') and tbl_customer.scoolid=@school and tbl_customer.driverid=@driver order by فاميل