How get current date in SQL server 2000
Answers were Sorted based on User's Feedback
Answer / rajkumar v
select convert( varchar(20), getdate(), 103)
Is This Answer Correct ? | 1 Yes | 0 No |
What is a Trace frag?Where can we use this?
Comment,Datatypes are unlimited
What is a trigger in sql server?
What is open database communication (odbc)?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
What is blocking and how would you troubleshoot it? : sql server database administration
What are the different methods available under sqlcommand class to access the data?
What do you mean by an execution plan? Why is it used? How would you view it?
Which command displays the SQL command in the SQL buffer, and then executes it?
Can group by be used without aggregate functions?
i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee