How get current date in SQL server 2000
Answer Posted / hajee
select sysdate from dual
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Tell me what is the significance of null value and why should we avoid permitting null values?
Write a SQL query to delete a table?
How to automatically create a log when an exception is being received into SQL Server?
How do I shrink an ldf file?
What are the underflow and overflow behaviors on float literals?
How many types of built in functions are there in sql server 2012?
What is the web service used for reporting services?
What are group functions in query statements in ms sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are the steps you must follow to hide sql server instances?
What is a Join and explain its types?
What is the difference between substr and charindex in the sql server?
List the different normalization forms?
What do you understand by mirroring?
Which are the third-party tools used in sql server and why would you use them?