We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Can we write trigger for view?
Explain the properties of sub-query in sql server?
What are the difference between data length and length in SQL Server-2008?
How do you delete duplicate records in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Tell me about builtinadministrator?
Tell me what is sql profiler?
What are the mathematical functions supported by sql server 2005?
What is bit datatype and what's the information that can be stored inside a bit column?
What do you mean by a Composite primary key?
How to delete multiple rows with one delete statement in ms sql server?