SET STATISTICS TIME ON Select * from TableName -- Or Any Query SET STATISTICS TIME OFF
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.
This article is provide a basic idea how we can send Emails from a C# Windows Application.
Here I have described how we can send mail with Attachment and HTML body.
There is no built in method for converting list to data table in C#.
So we can implement following method for converting List to DataTable in C#. Continue reading
Select * from TransactionInfo where CDate(Int([CreatedDate])) between #2010-05-04# and #2010-05-05#
it will return date like
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