/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

2 votes132 views1 answer
Jquery selector attribute value starts with
TypeScript
0 vote157 views1 answer
How to make objects move in roblox studio with a loop
TypeScript
0 vote134 views1 answer
How to send data between components in react using link
TypeScript
0 vote120 views1 answer
Sort an arraylist of objects in java
TypeScript
0 vote136 views1 answer
Whats is the use Notes.create(note) .then((data) => { res.send(data); }) .catch((err) => { res.status(500).send({ message: err.message || 'Some error occurred while create the Notes', }); });
TypeScript
0 vote119 views1 answer
Angular 9 remove text after white space
TypeScript
1 vote127 views2 answers
Common legend for multiple plots in r
TypeScript
0 vote121 views1 answer
Match a string that starts and ends with the same vowel
TypeScript
0 vote169 views1 answer
Marine traffic embeeded map in basic html
TypeScript
3 votes122 views1 answer
Python all elements not in list
TypeScript