用户自定义函数

CREATE FUNCTION stoi
   (@s string='')
RETURNS int
AS
BEGIN
  if isnumric(s) return cast(s as int)
  else return 0
END