Latest Answer: Ans:Database returns an error message when a constraint is violated.Differnet type of constrains;1.Domain Constraints:A Domain constraint deals with one or more columns2.Entity Constraints3.Referential Integrity Constraints.4.Key Constraints 4.1.Primary ...
Latest Answer: Normalization : It is the process of decomposing a relation with anomalies into a well structured relation.Basic Terminology of Normalization:-Well-structured relation : A relation with minimum redundancy and no anomalies Anolamy : is an error during ...
Latest Answer: A transaction is a group of operations combined into a logical unit of work. Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system BEGIN ...
Latest Answer: Rownum is the id which is assigned to recored, by the time of record set selected (executed).Rowid is, the id which is assigned physically to each record in table.RegadsSarele ...
Latest Answer: 1. Optimise DB performance ...
Latest Answer: For example let us take emp table. query to delete duplicate row will be like thisDelete * from emp where Rowid not in (select max(Row id) from emp grop by all columns) ...
Latest Answer: If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the procedure or batch. And so we do a dynamic SQL Statement.CREATE ...
Latest Answer: Please refer that here we are discussing about Sql Server only. There is no function named 'Translate' in Sql Server. 'Translate' function exists in Oracle for translating a single character to some other character.Replace fucntion in ...
Latest Answer: Examples for Analytical functions in Sql Server 2005:AVG, COMPUTE, DENSE RANK, NTile, Over, RANK, Row Number, STDEV, SUM, VAR, VARP, WITH ROLLUP ...
Latest Answer: Right click table in SSMS > Script Table as > CreateYour question of "copy" infers that you want all the constraints. The example that you give doesn't fill the requierments. As you want the structure you would als ...
View page << Previous 5 6 7 8 [9] 10 Next >>
Go Top
