/TypeScript/T sql if exists multiple conditions

T sql if exists multiple conditions

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'X' AND COLUMN_NAME = 'Y') 
AND EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Z' AND COLUMN_NAME = 'A')

BEGIN
    UPDATE [dbo].[X] 
        SET Y= (SELECT inst.[A] FROM [dbo].[Z] s WHERE s.[B] = [dbo].[x].[B]);
END    
GO

-1

Source: stackoverflow.com

Similar codes

0 vote131 views1 answer
Which of the foolowing ia an element of pallette that holds multiple elements of nspecific purpose
TypeScript
19 votes157 views5 answers
Delete all documents in a collection mongodb
TypeScript
0 vote142 views1 answer
2. Write a program to draw this. Assume the innermost square is 20 units per side, and each successive square is 20 units bigger, per side, than the one inside it.
TypeScript
0 vote133 views1 answer
Typescript record optional
TypeScript
2 votes135 views2 answers
Typeorm find orderby
TypeScript
0 vote203 views1 answer
Get keys of an array angualr
TypeScript
1 vote133 views1 answer
"send" and "transfer" are only available for objects of type "address payable", not "address".
TypeScript
0 vote137 views2 answers
To move a directory with its contents in terminal in linux
TypeScript
0 vote136 views1 answer
Disadvantages of automation
TypeScript
1 vote142 views1 answer
Ionic 3 open link external
TypeScript