Learning Home

Thursday, 29 March 2018

ALL POLICE STATION OF CHITTAGONG DIVISION.

Anwara
Banshkhali
Boalkhali
Chandanaish
Fatikchhari
Hathazari
Lohagara
Mirsharai
Patiya
Rangunia
Raozan
Sandwip
Satkania
Sitakunda
Akborsha
Baijid bostami
Bakolia
Bandar
Chandgaon
Chokbazar
Doublemooring
EPZ
Hali Shohor
Kornafuli
Kotwali
Kulshi
Pahartali
Panchlaish
Potenga
Shodhorgat


Bandarban Sadar
Thanchi
Lama
Naikhongchhari
Ali kadam
Rowangchhari
Ruma

Chakaria
Cox's Bazar Sadar
Kutubdia
Maheshkhali
Ramu
Teknaf
Ukhia
Pekua

Noakhali Sadar
Begumganj
Chatkhil
Companyganj
Shenbag
Hatia
Kobirhat
Sonaimuri
Suborno Char

Barura
Brahmanpara
Burichong
Chandina
Chauddagram
Daudkandi
Debidwar
Homna
Comilla Sadar
Laksam
Monohorgonj
Meghna
Muradnagar
Nangalkot
Comilla Sadar South
Titas

Feni Sadar
Chagalnaiya
Daganbhyan
Parshuram
Fhulgazi
Sonagazi

Brahmanbaria Sadar
Ashuganj
Nasirnagar
Nabinagar
Sarail
Shahbazpur Town
Kasba
Akhaura
Bancharampur
Bijoynagar

Rangamati Sadar
Belaichhari
Bagaichhari
Barkal
Juraichhari
Rajasthali
Kaptai
Langadu
Nannerchar
Kaukhali

Thursday, 8 February 2018

New line in crystal report.

// replace dollar sign with new line in a string for crystal report formula field

if {vw_CashBank.VType} = 1 or {vw_CashBank.VType} = 3 then Replace ({vw_CashBank.DebitHead},"$" , ChrW(13))
else Replace ({vw_CashBank.CreditHead},"$" , ChrW(13))

//build a string with new line for crystal report formula field.

        While rdr.Read
            strYardDetails += """" & rdr("Title") & """ + ChrW(13) + "
        End While

Wednesday, 26 April 2017

SQL SERVER


 

Select multiple rows without loop in SQL SERVER

declare @t varchar(max)
set @t = 'Product :'
select @t = @t + ',' + ItemInfo.ItemName from ItemInfo
print @t

SQL SERVER database suspect problem solution.



EXEC sp_resetstatus BeaconAcc;
ALTER DATABASE BeaconAcc SET EMERGENCY
DBCC checkdb(BeaconAcc)
ALTER DATABASE BeaconAcc SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (BeaconAcc, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE BeaconAcc SET MULTI_USER



Note: BeaconAcc is DBName.