Just Consider we have following records in a object named CR_NonDPC_ConfigDTO
PCName : PC
MotherBoard : ASROK 945 GCM
Processor : Pantium
HDD : HDD 160 GB
RAM : DDR-2 1 GB
Cassing : NULL
ExtraConfig : CD ROM ASUS
Sometimes we need to run *.sql script from our application for installing data base. SqlCommand is not right for running installation script because installation script consists of DDL and GO command. Here we use smo library for executing *.sql script.
Here I shall describe about split in MS SQL.
There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL.
Consider following SQL statement for MS SQL
Select UserName from UserInfo
It will return