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


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






你可能感興趣的文章

[FE201] babel

[FE201] babel

 使用vue-google-maps套件實作地圖(二)

使用vue-google-maps套件實作地圖(二)

[筆記] React 隨手記 (環境建置、常用功能說明)

[筆記] React 隨手記 (環境建置、常用功能說明)






留言討論