27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tb_Test
(
t_id INT IDENTITY(1,1) PRIMARY KEY,
userName NVARCHAR(20)
)
GO
INSERT INTO tb_Test
SELECT '张三' UNION ALL
SELECT '李四' UNION ALL
SELECT '王二'
GO
CREATE FUNCTION f_result(@userName NVARCHAR(20))
RETURNS NVARCHAR(100)
AS
BEGIN
RETURN @userName+'A'
END
GO
SELECT t_id,userName,dbo.f_result(userName) AS FunResult FROM tb_Test
t_id userName FunResult
----------- -------------------- ----------------------------------------------------------------------------------------------------
1 张三 张三A
2 李四 李四A
3 王二 王二A
(3 行受影响)
SELECT t_id,userName,userName+N'a' AS FunResult FROM tb_Test
SELECT t_id,userName,userName+N'A' AS FunResult FROM tb_Test