Is it possible to update the views? If yes, how, if not, why?
How will you monitor replication latency in transactional replication? : sql server replication
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
how to rename the table
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Can two different columns be merged into single column? Show practically?
What is DCL?
any one can explain Self mapping Delegation Remote Credentials
How to delete duplicate rows?
How to create an inline table-valued function?
Explain few examples of RDBMS?
What r sql reporting services and analysis services? how can we use it.
Explain about system stored procedure?