/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 vote190 views1 answer
Update multiple documents with different field value by id set. Mongoose
TypeScript
0 vote221 views1 answer
Graphql?query={__schema{types{name,fields{name}}}}
TypeScript
0 vote190 views1 answer
Total infosys employees
TypeScript
-1 vote187 views1 answer
Flutter get height of status bar
TypeScript
0 vote189 views1 answer
Remove dots and commas java
TypeScript
3 votes182 views2 answers
Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.
TypeScript
0 vote195 views1 answer
From __future__ import unicode_literals import youtube_dl ydl_opts = {} with youtube_dl.YoutubeDL(ydl_opts) as ydl: ydl.download(['VideoURL'])
TypeScript
0 vote202 views1 answer
"Which of the following is the best description of the interior structure of a highly evolved high-mass star late in its lifetime but before the collapse of its iron core?"
TypeScript
0 vote186 views1 answer
From date and to date validation in angular 8
TypeScript
0 vote206 views1 answer
Angular child routes not working
TypeScript