What is a file group?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Can I delete event logs?
Can a synonym name of a table be used instead of a table name in a select statement?
Difference between drill down and drill through report.
How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?
How to copy data from one table to another table?
How to list all objects in a given schema?
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
what is difference between Enterprise Manager and Query Analyer
How check triggers in sql server?
About types of indexes in SQL server ?
Is sql server a database?