/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 vote307 views1 answer
Angular 6 checkbox checked dynamically
TypeScript
0 vote311 views1 answer
How to create instances of classes godot
TypeScript
0 vote353 views1 answer
Haskell get specific elements of a String
TypeScript
0 vote302 views1 answer
What are the testing types
TypeScript
0 vote331 views1 answer
First k digits of n*n
TypeScript
0 vote302 views1 answer
Many plants obtain glucose through the process of ----
TypeScript
1 vote321 views6 answers
Swift constraints programmatically
TypeScript
0 vote348 views1 answer
Angular modal dismisss
TypeScript
18 votes380 views3 answers
ReferenceError: fetch is not defined
TypeScript
0 vote274 views1 answer
How to show component in another component angular
TypeScript