Latest Answer: while creating table you can implement tat by addingforeign key references p.tab_name(p.Col_name)heree p refers primary table andd this statement to be written beside col you want make as refrential integrity for the table..................... ...
Latest Answer: SQL stands for Structured Query Language. ...
Latest Answer: Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time ...
Latest Answer: Recompile is useful when the tables referenced by the stored proc undergoes a lot of modification/deletion/addition of data. Due to the heavy modification activity the execute plan becomes outdated and hence the stored proc performance goes down. If we ...
Latest Answer: cursor are database objects used by theaplication to manipulate the data in a set row by row basis ...
Latest Answer: Using "show users" command yuo can see all the users currently logged on into SQL server ...
Latest Answer: DBCC is stand for database consistency checker. ...
Latest Answer: explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not. ...
View page << Previous 13 14 15 16 [17] 18 19 20 Next >>

Go Top