DATABASE / SQL Server 2005 GSM No Kontrolü

CREATE FUNCTION [dbo].[fn_GSM]
(
@deger nvarchar(1000)
)
RETURNS @RtnValue table
(
GSM nvarchar(10),
Durum bit
)
AS
BEGIN
SET @deger = LTRIM(RTRIM(@deger))

DECLARE @karakterler NVARCHAR(10)
SET @karakterler = ‘0123456789'

DECLARE @deger_ NVARCHAR(1000)
SET @deger_ = ”

DECLARE @say INT
SET @say = 1

DECLARE @harf NVARCHAR(1)

Insert Into @RtnValue (GSM, Durum) values (Substring(@deger_, 1, 10), 1)
else
Insert Into @RtnValue (GSM, Durum) values (”, 0)

Return
END

turkirc ©