Facebook
From Thundering Elephant, 6 Years ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 210
  1. /*
  2. This script was created by Visual Studio on 14.03.2018 at 08:49.
  3. Run this script on wojtek-lenovo.Bestia_UsrGimnarys_kopia1 (WOJTEK-LENOVO\wgwiz) to make it the same as wojtek-lenovo.Bestia_UsrGimnarys (WOJTEK-LENOVO\wgwiz).
  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. UPDATE [dbo].[ad_Xslt] SET [xs_DataDo]='20170930 00:00:00.000' WHERE [xs_ID]=N'7cd3aec1-be90-4a2e-8ea5-8269d449472c'
  19. INSERT INTO [dbo].[ad_Xslt] ([xs_ID], [xs_NazwaXslt], [xs_DataOd], [xs_DataDo], [xs_Kolejnosc]) VALUES (N'64a47dde-66b0-4dd9-be27-1d1ddce10882', N'PaczkaSprawozdan_7.xslt', '20171001 00:00:00.000', NULL, 7)
  20.