Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER PROCEDURE CallsChange
- -- Add the parameters for the stored procedure here
- @ID int,
- @CS int
- AS
- BEGIN
- -- SET NOCOUNT ON added to prevent extra result sets from
- -- interfering with SELECT statements.
- SET NOCOUNT ON;
- -- Insert statements for procedure here
- INSERT INTO [ctlCalls]
- ([InsertDate])
- VALUES
- (GETDATE())
- UPDATE [ctlOrders]
- SET
- [DeliverymanID] = NULL
- ,[CallId] = (select SCOPE_IDENTITY () )
- ,[CurrentStatus] = 1
- WHERE ID = @ID
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement