NewFoxStudent
پنج شنبه 23 خرداد 1387, 12:25 عصر
با کسب اجازه از محضر اساتید دو تابع PADLEFT()وPADRIGHT() در Sql نوشتم
اگه ممکنه نظراتتون رو بیان کنید تا استفاده کنیم
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Function PadLeft(@cStr as nVarchar(250),@cLen as Int,@PadStr as nVarchar(250))
Returns nVarchar(250)
as
Begin
Declare @nTime as Int,@RetVal as nVarchar(250)
Set @nTime = @cLen - Len(@cStr)
Set @retVal = Space(@nTime)+@cStr
Return Replace(@retVal,' ',@PadStr)
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Function PadRight(@cStr as nVarchar(250),@cLen as Int,@PadStr as nVarchar(250))
Returns nVarchar(250)
as
Begin
Declare @nTime as Int,@RetVal as nVarchar(250)
Set @nTime = @cLen - Len(@cStr)
Set @retVal = @cStr + Space(@nTime)
Return Replace(@retVal,' ',@PadStr)
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
اگه ممکنه نظراتتون رو بیان کنید تا استفاده کنیم
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Function PadLeft(@cStr as nVarchar(250),@cLen as Int,@PadStr as nVarchar(250))
Returns nVarchar(250)
as
Begin
Declare @nTime as Int,@RetVal as nVarchar(250)
Set @nTime = @cLen - Len(@cStr)
Set @retVal = Space(@nTime)+@cStr
Return Replace(@retVal,' ',@PadStr)
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Function PadRight(@cStr as nVarchar(250),@cLen as Int,@PadStr as nVarchar(250))
Returns nVarchar(250)
as
Begin
Declare @nTime as Int,@RetVal as nVarchar(250)
Set @nTime = @cLen - Len(@cStr)
Set @retVal = @cStr + Space(@nTime)
Return Replace(@retVal,' ',@PadStr)
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO