/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 vote202 views1 answer
Cra ts pwa
TypeScript
0 vote203 views1 answer
Difference between test strategy vs test plan
TypeScript
2 votes197 views1 answer
Create database and grant user rights mariadb
TypeScript
0 vote203 views1 answer
Benefits of waxing body hair
TypeScript
1 vote213 views2 answers
Verify if object is of a certain type type in typescript
TypeScript
0 vote224 views1 answer
Where do you store your test data
TypeScript
3 votes144 views1 answer
How to remove an entry from a dictionary python
TypeScript
1 vote207 views1 answer
Size of list applescript
TypeScript
0 vote208 views1 answer
Loadsh partial match filter
TypeScript
-1 vote214 views1 answer
What are the three ways for a developer to execute tests in an org
TypeScript