Answer / sangeetha

select getdate()

Answer / shyamsri83

select getdate()

Answer / rajkumar

select getdate()

Answer / rajkumar v

select convert( varchar(20), getdate(), 103)

Answer / saket

now()

Answer / hajee

select sysdate from dual

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

How to create indexed view?

0 Answers  

What are the diifferences between the ms sql server vs mysql?

0 Answers  

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

How to configure and test odbc dsn settings?

0 Answers  

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

What is the difference between a local and a global temporary table?

0 Answers