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 { 16795 }

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 { 50905 }

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 { 49119 }

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, 45278 }

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