Answer : NIELIT IT Tools and Business Systems (July 2018)

Solved :  NIELIT IT Tools and Business Systems (July 2018)

1 : Multiple Choice

1.1 :  D
1.2 : B
1.3 : D
1.4 : C
1.5 : B
1.6 : C

Compare date in dd/mm/yyyy format C#

Some programmer needs to compare date in the format of dd/mm/yyyy. C# sharp has reach features of handling date but too complicated. So I made this post which helps you to compare date in dd/mm/yyyy format in simple way.

using System.Globalization;

string strFromDate =  "16/03/2020";

           

string strToDate = "20/03/2020";

NIELIT IT Tools and Business Systems (July 2018)

Solved NIELIT  IT Tools and Business Systems (July 2018)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein.

1.1 : statement for MS-Word?

A) It can be used to prepare annual report.

B) It can be used to generate same document to send multiple persons.

C) It has autocorrect facility and dictionary facility.

D) It can create a graph from given data.
Answer 

Spilit comma seprated string using SQL Server 2012

Create a function that will separate the comma-separated string and extract each word in using SQL Server 2012.

declare @str varchar(50),@l int,@i int,@p int,@slen int

select @str='o,222,333,kl,4444,555,88pol'

select @l=LEN(@str)

set @i=1

set @p=0

set @slen=1