sql equivalent function for c# function

Competetor

4y1.3k

Can someone help me to find exact sql equivalent function for C# Convert.ToInt32. I would like to thank for any proper answer in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kapil Singh Kumawat4y ago
Hi,,

You can achieve the same using CAST and CONVERT function.
Uttam Kumar4y ago
SELECT CAST(25.65 AS int);

For more details you can refer to this link

https://www.w3schools.com/sql/func_sqlserver_cast.asp
Rajanikant Hawaldar4y ago
for int16 it is smallint, for int32 it is int, for int64 it is bigint
Muhammad Imran Ansari4y ago
You can achieve this through CAST or CONVERT method in SQL.
The SQL CAST function takes two arguments. First, the data we want to process, in this case, the data is ‘5’ and ‘2’ and are of char field, and then how you want to process it, or how we want to CAST it. In this case, you want to CAST it as an integer field.
DECLARE @val NVARCHAR(10) = '5'
SELECT CAST(@val AS INT)
The SQL convert function first starts with a data type, and a comma, and then followed by an expression.
DECLARE @val NVARCHAR(10) = '5'
SELECT CONVERT(INT, @val)
There won’t be a major difference in terms of query execution between SQL Cast and SQL Convert functions.