[SQL] Want to declare a string array variable? Declare a table variable instead.


Jan 12, 2023

Sometimes we want to declare a array to represent the condition of WHERE IN.
But you can not declare a array in SQL, instead, you can try to declare a table variable with the value you want to put in.

DECLARE @usernameArray TABLE (username varchar(50))
INSERT INTO @usernameArray VALUES ('M12345'), ('M12346'), ('M12347'), ('M12348'), ('M12349')

SELECT * FROM member_info m WHERE  m.username IN 
(SELECT username FROM @usernameArray)

In the code block, I declared a table variable, and inserted 5 rows into the variable.
Then when I needed to select with the condition.
I selected the array from the table variable we declared before (@usernameArray).

#SQL






你可能感興趣的文章

Express框架 Q A

Express框架 Q A

[進階 js 12] Event Loop

[進階 js 12] Event Loop

[JS Behind The Scene] 從 for loop 理解 scope 和 event loop 的運作機制

[JS Behind The Scene] 從 for loop 理解 scope 和 event loop 的運作機制






留言討論






2
2
2