Interested to Buy Any Domain ? << Click Here >> for more details...
How get current date in SQL server 2000
- 6 Answers
- 9161 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
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
List the different normalization forms?
What is proper subset of candidate key?
Explain the steps needed to create a scheduled job?
Which rendering formats are affected by the pagesize properties?
What are the restrictions applicable while creating views? : SQL Server Architecture
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the purpose of Normalisation?
What is the tcp/ip port on which sql server runs?
Define full outer join?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to use user defined functions in expressions?
how to take backup bcp out for a column in table in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
