Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. ALTER PROCEDURE CallsChange
  2. -- Add the parameters for the stored procedure here
  3. @ID int,
  4. @CS int
  5. AS
  6. BEGIN
  7. -- SET NOCOUNT ON added to prevent extra result sets from
  8. -- interfering with SELECT statements.
  9. SET NOCOUNT ON;
  10.  
  11. -- Insert statements for procedure here
  12. INSERT INTO [ctlCalls]
  13. ([InsertDate])
  14. VALUES
  15. (GETDATE())
  16.  
  17.  
  18. UPDATE [ctlOrders]
  19. SET
  20. [DeliverymanID] = NULL
  21.  
  22. ,[CallId] = (select SCOPE_IDENTITY () )
  23.  
  24. ,[CurrentStatus] = 1
  25. WHERE ID = @ID
  26.  
  27. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement