计算sql中的varchar值 [英] Computing varchar value in sql

问题描述

我的表名中有一个varchar字段作为考勤



它的值为25/25;



我需要在执行此值时将其答案为1 ...

如何可能???

I have a varchar field in my table name as attendance

Its value as 25/25;

I need to get its answer as 1 while executing this value...
How it is possible???

推荐答案

最好将数据库中的值分解为单独的列，这样您就可以在Sql Server中轻松计算，或者可以用c＃代码进行计算。

You are better off breaking up the values in your database into separate columns so you can compute easily in Sql Server, or you can compute in c# code.

正如Mehdi Gholam写的那样，糟糕的设计表，但你仍然可以找到解决方案（硬编码）。



参见示例：

As Mehdi Gholam wrote, bad design of table, but still you can find solution (hard coded).

See example:

DECLARE @val VARCHAR(30)
DECLARE @search VARCHAR(5)

SET @val = '25/25'
SET @search = '/'

SELECT MyFirstVal, MySecondVal, CONVERT(FLOAT, MyFirstVal/MySecondVal) AS Result
FROM (
    SELECT  CONVERT(INT, LEFT(@val, CHARINDEX(@search, @val)-1)) AS MyFirstVal,
            CONVERT(INT, RIGHT(@val, LEN(@val)- CHARINDEX(@search, @val))) AS MySecondVal
)AS T

这篇关于计算sql中的varchar值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！