Database

ALTER PROCEDURE [dbo].[SP_SearchGroundedVehicles]
@vin varchar(17)
AS
BEGIN
SET NOCOUNT ON;
  
if count(@vin) = 17
begin
    
    SELECT V.vin 
    ,C.FirstName
    ,C.LastName
    ,C.AccountNum
    ,D.DealerShipName
    ,Contrt.MaturityDate 
    FROM ContractInfo Contrt 
    Inner Join VehicleInformation V ON Contrt.VehicleID = V.VehicleID
    Inner Join DealerShips D ON Contrt.DealerShipID = D.DealerShipID
    Inner Join Customer C ON Contrt.CustomerID = C.CustomerID
    Where VIN = @VIn
    
end
ELSE
begin
    
    SELECT V.vin 
    ,C.FirstName
    ,C.LastName
    ,C.AccountNum
    ,D.DealerShipName
    ,Contrt.MaturityDate 
    FROM ContractInfo Contrt 
    Inner Join VehicleInformation V ON Contrt.VehicleID = V.VehicleID
    Inner Join DealerShips D ON Contrt.DealerShipID = D.DealerShipID
    Inner Join Customer C ON Contrt.CustomerID = C.CustomerID
    
end

public void DoStuff(string arg)
{
    if (arg)
    {
        DoSomething();
    }
    else
    {
        DoSomethingElse();
    }
}

create proc SP1 @arg1 varchar(100)<br />
as <br />
	select @arg1 = 'select * from emp where empid in(' +  @arg1 +')'<br />
<br />
	exec (@arg1)