Skip to content

Commit 3b8113e

Browse files
smpetersgithubsmpetersgithub
authored
Add files via upload
1 parent c201e02 commit 3b8113e

32 files changed

Lines changed: 74 additions & 74 deletions

‎Database Articles/Database Dependencies/SQL Scripts/01_Cross_Database_Dependencies.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ GO
4343
USE foo;
4444
GO
4545

46-
DECLARE @vTruncate SMALLINT = 0;
46+
DECLARE @vTruncate SMALLINT = 1;
4747
IF @vTruncate = 1
4848
BEGIN
4949
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -83,7 +83,7 @@ GO
8383
USE foo;
8484
GO
8585

86-
DECLARE @vDropObjects SMALLINT = 0;
86+
DECLARE @vDropObjects SMALLINT = 1;
8787
IF @vDropObjects = 1
8888
BEGIN
8989
DROP TABLE IF EXISTS dbo.tbl_example_01;
@@ -93,7 +93,7 @@ GO
9393
USE bar
9494
GO
9595

96-
DECLARE @vDropObjects SMALLINT = 0;
96+
DECLARE @vDropObjects SMALLINT = 1;
9797
IF @vDropObjects = 1
9898
BEGIN
9999
DROP VIEW IF EXISTS dbo.vw_example_01;

‎Database Articles/Database Dependencies/SQL Scripts/02_Cross_Schema_Dependencies.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ GO
4343
USE foo;
4444
GO
4545

46-
DECLARE @vTruncate SMALLINT = 0;
46+
DECLARE @vTruncate SMALLINT = 1;
4747
IF @vTruncate = 1
4848
BEGIN
4949
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -69,7 +69,7 @@ GO
6969
USE foo;
7070
GO
7171

72-
DECLARE @vDropObjects SMALLINT = 0;
72+
DECLARE @vDropObjects SMALLINT = 1;
7373
IF @vDropObjects = 1
7474
BEGIN
7575
DROP TABLE IF EXISTS schemaA.tbl_example_02_schemaA;

‎Database Articles/Database Dependencies/SQL Scripts/03_Invalid_Stored_Procedures.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -23,7 +23,7 @@ GO
2323
USE foo;
2424
GO
2525

26-
DECLARE @vTruncate SMALLINT = 0;
26+
DECLARE @vTruncate SMALLINT = 1;
2727
IF @vTruncate = 1
2828
BEGIN
2929
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -49,7 +49,7 @@ GO
4949
USE foo;
5050
GO
5151

52-
DECLARE @vDropObjects SMALLINT = 0;
52+
DECLARE @vDropObjects SMALLINT = 1;
5353
IF @vDropObjects = 1
5454
BEGIN
5555
DROP PROCEDURE IF EXISTS dbo.sp_example_03;

‎Database Articles/Database Dependencies/SQL Scripts/04_Numbered_Stored_Procedures.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -50,7 +50,7 @@ GO
5050
USE foo;
5151
GO
5252

53-
DECLARE @vTruncate SMALLINT = 0;
53+
DECLARE @vTruncate SMALLINT = 1;
5454
IF @vTruncate = 1
5555
BEGIN
5656
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -76,7 +76,7 @@ GO
7676
USE foo;
7777
GO
7878

79-
DECLARE @vDropObjects SMALLINT = 0;
79+
DECLARE @vDropObjects SMALLINT = 1;
8080
IF @vDropObjects = 1
8181
BEGIN
8282
DROP TABLE IF EXISTS dbo.tbl_example_04_a;

‎Database Articles/Database Dependencies/SQL Scripts/05_Ambiguous_References.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -42,7 +42,7 @@ GO
4242
USE foo;
4343
GO
4444

45-
DECLARE @vTruncate SMALLINT = 0;
45+
DECLARE @vTruncate SMALLINT = 1;
4646
IF @vTruncate = 1
4747
BEGIN
4848
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -68,7 +68,7 @@ GO
6868
USE foo;
6969
GO
7070

71-
DECLARE @vDropObjects SMALLINT = 0;
71+
DECLARE @vDropObjects SMALLINT = 1;
7272
IF @vDropObjects = 1
7373
BEGIN
7474
DROP FUNCTION IF EXISTS dbo.fn_example_05;

‎Database Articles/Database Dependencies/SQL Scripts/06_Part_Naming_Conventions.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -50,7 +50,7 @@ GO
5050
USE foo;
5151
GO
5252

53-
DECLARE @vTruncate SMALLINT = 0;
53+
DECLARE @vTruncate SMALLINT = 1;
5454
IF @vTruncate = 1
5555
BEGIN
5656
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -76,7 +76,7 @@ GO
7676
USE foo;
7777
GO
7878

79-
DECLARE @vDropObjects SMALLINT = 0;
79+
DECLARE @vDropObjects SMALLINT = 1;
8080
IF @vDropObjects = 1
8181
BEGIN
8282
DROP VIEW IF EXISTS dbo.vw_four_part_name_example_06;

‎Database Articles/Database Dependencies/SQL Scripts/07_Part_Naming_Conventions_Caller_Dependent.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -30,7 +30,7 @@ GO
3030
USE foo;
3131
GO
3232

33-
DECLARE @vTruncate SMALLINT = 0;
33+
DECLARE @vTruncate SMALLINT = 1;
3434
IF @vTruncate = 1
3535
BEGIN
3636
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -56,7 +56,7 @@ GO
5656
USE foo;
5757
GO
5858

59-
DECLARE @vDropObjects SMALLINT = 0;
59+
DECLARE @vDropObjects SMALLINT = 1;
6060
IF @vDropObjects = 1
6161
BEGIN
6262
DROP PROCEDURE IF EXISTS dbo.sp_example_07_a;

‎Database Articles/Database Dependencies/SQL Scripts/08_Dropping_Objects.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -34,7 +34,7 @@ GO
3434
USE foo;
3535
GO
3636

37-
DECLARE @vTruncate SMALLINT = 0;
37+
DECLARE @vTruncate SMALLINT = 1;
3838
IF @vTruncate = 1
3939
BEGIN
4040
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -60,7 +60,7 @@ GO
6060
USE foo;
6161
GO
6262

63-
DECLARE @vDropObjects SMALLINT = 0;
63+
DECLARE @vDropObjects SMALLINT = 1;
6464
IF @vDropObjects = 1
6565
BEGIN
6666
DROP VIEW IF EXISTS dbo.vw_example_08;

‎Database Articles/Database Dependencies/SQL Scripts/09_Dropping_Objects_Then_Recreating.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ GO
4343
USE foo;
4444
GO
4545

46-
DECLARE @vTruncate SMALLINT = 0;
46+
DECLARE @vTruncate SMALLINT = 1;
4747
IF @vTruncate = 1
4848
BEGIN
4949
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -69,7 +69,7 @@ GO
6969
USE foo;
7070
GO
7171

72-
DECLARE @vDropObjects SMALLINT = 0;
72+
DECLARE @vDropObjects SMALLINT = 1;
7373
IF @vDropObjects = 1
7474
BEGIN
7575
DROP VIEW IF EXISTS dbo.vw_example_09;

‎Database Articles/Database Dependencies/SQL Scripts/10_Self_Referencing_Objects.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ GO
3131
USE foo;
3232
GO
3333

34-
DECLARE @vTruncate SMALLINT = 0;
34+
DECLARE @vTruncate SMALLINT = 1;
3535
IF @vTruncate = 1
3636
BEGIN
3737
TRUNCATE TABLE foo.dbo.sql_expression_dependencies;
@@ -57,7 +57,7 @@ GO
5757
USE foo;
5858
GO
5959

60-
DECLARE @vDropObjects SMALLINT = 0;
60+
DECLARE @vDropObjects SMALLINT = 1;
6161
IF @vDropObjects = 1
6262
BEGIN
6363
DROP FUNCTION IF EXISTS dbo.fn_example_10;

0 commit comments

Comments
 (0)