获得员工的全名 [英] Getting Full Name of Employee
问题描述
大家好,
我有问题
在我的DSE(执行)表格中有列像
FirstName
LastName
MiddleName
在我的存储过程中,我必须将字符串连接为全名(可能是临时列)我将如何实现它。
我写了SP ..但是不知道它的工作与否
SP-
更改程序dbo.GetDSEFullName < br $>
(
@FirstName varchar(50),
@MiddleName varchar(50),
@ LastName varchar( 50)
)
AS
BEGIN
声明FullName varchar(500 )
SET NOCOUNT ON
DECLARE @Err int
声明@qry nvarchar(4000)
声明@temp nvarchar(2000)
设置@temp = null
Set @qry ='
选择
来自DSE_Info的DSE_ID
其中DSE_Info.FirstName='''++FirstName+'''和DSE_ Info.LastName ='''+ @ LastName +''''
if(@MiddleName not null)
开始
设置@temp ='AND MiddleName ='''+ @MiddleName +''''
设置@qry = @qry + @temp
选择
结束
打印@qry
执行SP_EXECUTESQL @ qry
SET @Err = @@错误
RETURN @Err
END
嘿那里,
我假设,中间名可能为空,所以这里是标量 - 有价值的函数
:
CREATE FUNCTION GetFullName
(
@ FirstName varchar ( 50 ),
@ MiddleName varchar ( 50 ),
@ LastName varchar ( 50 )
)
RETURNS varchar ( 200 )
AS
BEGIN
DECLARE @ FullName varchar ( 200 )= @ FirstName ;
IF ( @ MiddleName NOT NULL AND @ MiddleName <> ' ')
BEGIN
设置 @ FullName + = ' ' + @ MiddleName ;
END
SET @FullName + = ' ' + @LastName 跨度>;
RETURN @ FullName
结束
以下是您可以调用的方式。
SELECT dbo.getFullName(' John',' J',' 史密斯')
希望有所帮助,请让我知道。
Azee ......
http://sqlhints.com/2012/12/02/concat-function-in-sql-server-2012/ [ ^ ]
Hi guys,
I have an problem
In My DSE(Executive)table There is Columns Like
FirstName
LastName
MiddleName
In my stored Procedure i have to concate the string as Full Name(May be temporary column)Si how i can achieve it.
I wrote SP..but dont knw its working or not
SP-
ALTER PROCEDURE dbo.GetDSEFullName
(
@FirstName varchar(50),
@MiddleName varchar(50),
@LastName varchar(50)
)
AS
BEGIN
Declare FullName varchar(500)
SET NOCOUNT ON
DECLARE @Err int
Declare @qry nvarchar(4000)
Declare @temp nvarchar(2000)
Set @temp = null
Set @qry ='
select
DSE_ID from DSE_Info
where DSE_Info.FirstName='''+@FirstName+''' and DSE_Info.LastName='''+ @LastName + ''''
if(@MiddleName is not null)
Begin
Set @temp = ' AND MiddleName = '''+ @MiddleName + ''''
Set @qry = @qry + @temp
SELECT
End
print @qry
Execute SP_EXECUTESQL @qry
SET @Err = @@Error
RETURN @Err
ENDHey there,
I assume, the middle name could be null, so here is a scalar-valued function
:
CREATE FUNCTION GetFullName
(
@FirstName varchar(50),
@MiddleName varchar(50),
@LastName varchar(50)
)
RETURNS varchar(200)
AS
BEGIN
DECLARE @FullName varchar(200) = @FirstName;
IF (@MiddleName is NOT NULL AND @MiddleName <> '')
BEGIN
Set @FullName += ' ' + @MiddleName;
END
SET @FullName += ' ' + @LastName;
RETURN @FullName
END
and here is how you can call it.
SELECT dbo.getFullName('John', 'J', 'Smith')
Hope it helps, do let me know.
Azee...
http://sqlhints.com/2012/12/02/concat-function-in-sql-server-2012/[^]
Awsomeee Work ..Azee ..Thnxx for your help
这篇关于获得员工的全名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!