/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 vote193 views1 answer
Failed to enumerate objects in the container access is denied windows 10
TypeScript
2 votes240 views1 answer
Typescript enum to array
TypeScript
2 votes201 views2 answers
Search an array of objects with specific object property value
TypeScript
12 votes223 views1 answer
Argument of type 'string | null' is not assignable to parameter of type 'string'. Type 'null' is not assignable to type 'string'
TypeScript
11 votes205 views6 answers
Localstorage
TypeScript
0 vote297 views1 answer
OpenCV(4.5.3) C:\Users\runneradmin\AppData\Local\Temp\pip-req-build-q3d_8t8e\opencv\modules\imgproc\src\shapedescr.cpp:315: error: (-215:Assertion failed) npoints >= 0 && (depth == CV_32F || depth == CV_32S) in function 'cv::contourArea'
TypeScript
0 vote194 views1 answer
Module svg typescript
TypeScript
0 vote218 views1 answer
Send tcp packets to kubernetes node
TypeScript
0 vote215 views1 answer
.htaccess Preventing requests with invalid characters
TypeScript
1 vote213 views1 answer
Should robots have faces?
TypeScript