What is autocommit mode in sql server?
List the types of recovery model available in sql server?
What is a trigger?
What is the diffrence between update_one and auto_fix?
how to take backup bcp out for a column in table in sql server?
what is Constraint? How many types of constraints in SQL ?
38 Answers HCL, IBM, NIIT, Wipro,
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How is foreign key related to primary key?
What is update_statistics command?
What is the fastest way to permanently delete a 1 million row table named customers?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
difference between truncate, delete aur drop?
How to create a dml trigger using create trigger statements?