|
|
| Definitions More Info. | | Definition ID | 45 | | Title | SQL | | Category | SCRIPT | | Definition | CHARINDEX_AD_SOYAD_AYIRMA | | Definition Description | insert into Fatura.dbo.Customer_Temp (MusteriAdi)
select distinct(FirmaAdi) from HurdaHesap
insert into Fatura.dbo.Customer(MusteriAdi,MusteriSoyadi)
SELECT
SUBSTRING ( MusteriAdi, 0 ,CHARINDEX ( ' ',MusteriAdi )+ 1 ) AS Ad,
SUBSTRING ( MusteriAdi, CHARINDEX ( ' ',MusteriAdi )+ 1,len( MusteriAdi )) AS Soyad
FROM
Customer_Temp
--ad
--asagidaki sorgular aynı kolonda bulunan ad soyad ayırmak icin kullanilmistir.
SELECT
SUBSTRING ( FirmaAdi,CHARINDEX ( ' ',FirmaAdi )+ 1,len( FirmaAdi )) AS soyad
FROM
HurdaHesap
--soyad
SELECT
SUBSTRING ( FirmaAdi,0 ,CHARINDEX ( ' ',FirmaAdi )+ 1 )
FROM
HurdaHesap
--ad
truncate table dbo.Customer
select * from Customer | | RecordBy | cunay | | Record Date | 15-02-2012 15:22:19 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|