Latest Answer: @@connection gives no of connections ...
Latest Answer: It is to know the no of rows feched from cursorIt is used in situations likeWe have to do the modifications up to five rowsTheir is some situations to print up to no of rows fetched from cursorIn pl/sql table it is used like an array index to store values ...
Latest Answer: If a Trigger is having Insert/Update/Delete statement of a table which is also having a trigger defined on it for Insert/Update/Delete, then Trigger1 would cause Trigger2 to get fired when a data Manipulation has occured. This is called nested trigger. ...
Error While creating BACKUP:I am Creating FullBackup for one database Named Postings.I executed below Query and i am getting The Below error message.USE mastergoEXEC SP_ADDUMPDEVICE 'disk','PostingsBac','E:BACKUPPostingsBac.BAK'BACKUP
Latest Answer: This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not. ...
How to implement the IF .... ELSE IF.... in the switch case statement...........In switch case statement.......... WHEN ELSE But............. I need to use the condition in ELSE Statement...........
Latest Answer: no.because,stored procedures are explicity invoked and trigger is nothing but a stored procedure but fires an event or data modifications occur.trigger is a implicity invoked. ...
ex. Smith,John,India
Latest Answer: Save the query results to .csv file. ...
Latest Answer: Using Pivot Option in MS SQL Server 2005. ...
Latest Answer: clustered index ...
Latest Answer: Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy for a Windows domain, it will automatically propagated ...
View page << Previous 1 2 3 [4] 5 6 Next >>
Go Top
