/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 vote358 views1 answer
What are data points
TypeScript
0 vote340 views2 answers
Js convert to typescript online
TypeScript
0 vote342 views1 answer
Google scripts docs highlight
TypeScript
1 vote303 views1 answer
Xaraktirismos tou tsiganou kai tou xose buendia sto keimeno 100 xronia monaksias, oi nees efeureseis
TypeScript
0 vote365 views1 answer
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime.
TypeScript
0 vote317 views1 answer
How to check typescript version for my react-app
TypeScript
19 votes319 views3 answers
Random between two floats python
TypeScript
0 vote316 views1 answer
Factory design pattern typescript
TypeScript
0 vote328 views1 answer
Ts compile command
TypeScript
6 votes346 views3 answers
Angular form set value
TypeScript