How get current date in SQL server 2000
Answer Posted / shyamsri83
select getdate()
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What stored procedure can you use to display the current processes?
Mention the command used to rename the database.
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 is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are the advantages of using stored procedures?
What is query optimization process?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Sql server reporting services vs. Crystal reports.
What happens if null values are involved in bitwise operations?
How do you rebuild an identity column?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What are the common performance issues in sql server?
What is a file group?
Mention the 3 ways to get a count of the number of records in a table.