How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?
Latest Answer: May be you can use Constraints. ...
Latest Answer: SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties –> Por number, both on client and the server. ...
Latest Answer: Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know. ...
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. ...
View page << Previous 1 2 3 4 [5] 6 7 Next >>
Go Top
