neural networks : Use string type comma separated in IN clause in sql

Wednesday, January 23, 2013

Use string type comma separated in IN clause in sql

declare @ProductIds nvarchar(50)='18,19'

SELECT * FROM products Where (',' + @ProductIds +',' LIKE '%,' + CONVERT(VARCHAR, ProductId) + ',%')

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)