daily pastebin goal
22%
SHARE
TWEET

Untitled

a guest Apr 16th, 2018 51 in 1 day
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2. This script was created by Visual Studio on 2018-04-16 at 20:49.
  3. Run this script on 127.0.0.1,17000.aiorhpdemo (ibm\Gsue44) to make it the same as 127.0.0.1,17000.aiorhp_dworoliwski_copy (ibm\Gsue44).
  4. This script performs its actions in the following order:
  5. 1. Disable foreign-key constraints.
  6. 2. Perform DELETE commands.
  7. 3. Perform UPDATE commands.
  8. 4. Perform INSERT commands.
  9. 5. Re-enable foreign-key constraints.
  10. Please back up your target database before running this script.
  11. */
  12. SET NUMERIC_ROUNDABORT OFF
  13. GO
  14. SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
  15. GO
  16. /*Pointer used for text / image updates. This might not be needed, but is declared here just in case*/
  17. DECLARE @pv binary(16)
  18. BEGIN TRANSACTION
  19. DELETE FROM [_def].[cust_dims] WHERE [cd_id]=182
  20. DELETE FROM [_def].[cust_dims] WHERE [cd_id]=1203
  21. DELETE FROM [_def].[cust_dims] WHERE [cd_id]=2016
  22. INSERT INTO [_def].[Widgets] ([wd_id], [wd_link], [wd_headline], [wd_frame]) VALUES (11, N'/htres/rsvAbbrv/GetMealSummary', N'Ilość posiłków na następny dzień', N'/htres/rsvr/rsvmeal2list')
  23. INSERT INTO [_def].[Widgets] ([wd_id], [wd_link], [wd_headline], [wd_frame]) VALUES (12, N'/htres/rsvAbbrv/EventSummary', N'Ilość imprez na następny dzień', N'/ev/event/evlist')
  24. SET IDENTITY_INSERT [rsv].[tb_restype] ON
  25. INSERT INTO [rsv].[tb_restype] ([rm_id], [rm_name]) VALUES (1, N'Pokój')
  26. INSERT INTO [rsv].[tb_restype] ([rm_id], [rm_name]) VALUES (2, N'Posiłek')
  27. INSERT INTO [rsv].[tb_restype] ([rm_id], [rm_name]) VALUES (3, N'Sala konferencyjna')
  28. INSERT INTO [rsv].[tb_restype] ([rm_id], [rm_name]) VALUES (4, N'Boisko')
  29. INSERT INTO [rsv].[tb_restype] ([rm_id], [rm_name]) VALUES (5, N'Strzelnica')
  30. SET IDENTITY_INSERT [rsv].[tb_restype] OFF
  31. COMMIT TRANSACTION
  32.  
  33.  
  34.  
  35. --sal.v_order - dodać pole ord_st
RAW Paste Data
Top