Latest Answer: select * from sysobjects where xtype='U' ...
Latest Answer: Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)Dirty reads: Reading the data that is actually read by Transaction2 which was modified by Transaction 1 and Transaction1 ...
Latest Answer: use IsNULL(,value) .If query return null ,it will replace by value. ...
Latest Answer: select column1 as Name; ...
Latest Answer: Deadlock occurs when two or more processes have lock objects and each process is trying to acquire a lock on an object that the other processes have previously locked. Let p1 process has an exclusive lock on object o1, p2 process has an exclusive ...
Latest Answer: varchar and varchar2: both are datatype for storing character or string type, but there are little bit difference in both, let us with following exemple
if we declare a variable name as varchar(100) then at the time of declaring it will make 100 seprate ...
Latest Answer: When a procedure is created a execution plan is created, proc is executed according to that execution plan. When we modify the proc it also follow this execution plan.When index is rebuild, new index structure is created, but the proc follows the old ...
Latest Answer: Extended Stored procedure is a function in a DLL that can be called from T-SQL in a similar manner as we call normal stored procedure.Can accept parameter and return value as well. ...
Latest Answer: this is also worhs mentioning database backup & recovery ...
Latest Answer: Basic DifferenceSql Server:Runs only on windows platform,Hardware independentoracle:Runs in any platform and hardware dependent.. ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
