How get current date in SQL server 2000
- 6 Answers
- 8072 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / rajkumar v
select convert( varchar(20), getdate(), 103)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can we have a nested transaction? : Sql server database administration
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?
SQL Server Architecture ?
What is sql server management studio? : sql server management studio
How do database indexes work?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Explain how you can configure a running aggregate in SSRS?
Explain what is lock escalation?
What is the difference between an index and a unique index?
How to find the login name linked to a given user name?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is ms sql server index?
Which are the new data types introduced in sql server 2008?
