Interview Questions Answers in SQL Server

rajeev rohilla

{ City } samalkha
< Country > india
* Profession * vb developer
User No # 4946

Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 153
Users Marked my Answers as Wrong # 58

Questions / { rajeev rohilla }

Questions Answers Category Views Company eMail

Answers / { rajeev rohilla }

Question { 18866 }

What is a cursor in SQL Server 2000 and their types?

Answer

In SQL Server 2000 Cursors are used in stored procedures /
Functions where we have to go each record of a recordset
one by one.

Is This Answer Correct ?

16 Yes

6 No

Question { 53844 }

How do we get month name in SQL Server 2000, Oracle, MS Access?

Answer

in ms-access we can use
select format(date(),'mmmm')

Is This Answer Correct ?

37 Yes

28 No

Question { 52344 }

How do we get current date in SQL Server 2000, Oracle, MS
Access?

Answer

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

Is This Answer Correct ?

43 Yes

13 No

Question { HP, 49199 }

What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table

Answer

No Diffrence at all

Is This Answer Correct ?

57 Yes

11 No