日期:2014-05-17 浏览次数:20969 次
CREATE FUNCTION DBO.GET_NUMBER2(@S VARCHAR(100))
RETURNS VARCHAR(100)
AS
BEGIN
WHILE PATINDEX('%[^0-9.]%',@S) > 0
BEGIN
set @S=stuff(@S,patindex('%[^0-9.]%',@S),1,'')
END
RETURN @S
new SqlCommand(sSQL, conn as SqlConnection, null).ExecuteNonQuery();