How can you insert null values in a column while inserting the data?
Can you link only other SQL Servers or any database servers such as Oracle?
How can you list all the table constraints in a database?
How do I shrink an ldf file?
What is advantage data architect?
What is trigger ?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
what's the difference between delete table and truncate table commands? : Sql server database administration
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is updatable resultset?
How each E-R model constructs can be mapped to the relational model?
What is the system function to get the current user's user id?
How do we get current date in SQL Server 2000, Oracle, MS Access?