/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

1 vote192 views1 answer
How to make an element be above all the other elements html
TypeScript
0 vote185 views1 answer
Http://docs.python-requests.org/en/master/user/install/
TypeScript
2 votes188 views1 answer
How long does it take to learn typescript
TypeScript
0 vote185 views1 answer
Excel separate input cell contents by space
TypeScript
0 vote209 views1 answer
Whats $_.FullName in powershell
TypeScript
0 vote191 views1 answer
Kick bots command cs go
TypeScript
26 votes183 views2 answers
Typescript check if object has key
TypeScript
0 vote187 views1 answer
How to check if a value exists in another table mysql
TypeScript
0 vote185 views1 answer
Window global typescript
TypeScript
0 vote255 views2 answers
Typeorm select join column querybuilder
TypeScript