可以写一个系统函数,前提是必须以fn_开头: 如: use master go create function fn_Trim(@v Nvarchar(4000)) returns Nvarchar(4000) as begin return ltrim(rtrim(@v)) end go exec sp_configure 'allow updates',1 reconfigure with override go exec sp_mschangeobjectowner 'fn_Trim','system_function_schema' go exec sp_configure 'allow updates',0 reconfigure with overridego --调用 use northwind go select fn_trim(N'a ')--不带用户名
如:
use master
go
create function fn_Trim(@v Nvarchar(4000))
returns Nvarchar(4000)
as
begin
return ltrim(rtrim(@v))
end
go
exec sp_configure 'allow updates',1
reconfigure with override
go
exec sp_mschangeobjectowner 'fn_Trim','system_function_schema'
go
exec sp_configure 'allow updates',0
reconfigure with overridego
--调用
use northwind
go
select fn_trim(N'a ')--不带用户名