How to count rows with the count(*) function in ms sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
If we delete pack Spec what will be the status of pack Body ?
What is triggers and stored procedures?
Can we rollback records deleted by a truncate statement?
3 Answers CarrizalSoft Technologies, United Healthcare,
What is a transaction and why is it important?
How to check if a table is being used in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What do you mean by acid?
What is bcp? When does it used?
How are the exceptions handled in sql server programming?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?