hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000
3 5275How to write query to Delete the records in child table and corresponding records in parent table
11 31566Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
2 5849Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
4 7229
What are the benefits and tasks of object explorer? : sql server management studio
What are the filtered indexes?
do views contain data ?
What is sql server replication? : sql server replication
What information is maintained within the msdb database?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are the difficulties faced in cube development? : sql server analysis services, ssas
Do you know what is a with(nolock)?
Can we check locks in database? If so, how can we do this lock check?
What does asynchronous call backs means?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Define cross join in sql server joins?
Can sql servers linked to other servers?
Explain can you implement data mining in ssrs?
How to enable/disable indexes?