SQL string to Int type, SQL string int

SQL string to Int type, SQL string int

In general, SQL statements can be implicitly converted without strong conversion. It is really necessary to replace it with int type.

Convert (int, @ str)

Today we are talking about another situation,
First look at the SQL error prompt:

Failed to convert varchar values '1, 2, 3 'to data type int.

We often write select * from table where tableId in (1, 2, 3) when writing SQL statements.

If 1, 2, 3 is a variable or '1, 2, 3 ', the above error is reported,
Solution: dynamically Execute SQL statements:

Declare @ classid nvarchar (Max) declare @ SQL nvarchar (Max) declare @ count int set @ classid = (select classid from Class) set @ SQL = n' select @ count = COUNT (SC. studentid) from StudentClass SC where classid in ('+ @ classid +') 'exec sp_executesql @ SQL, n' @ count int output', @ count output select @ count

In this way, the problem is solved and the in Condition Statement is dynamically assigned.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.