Latest Answer: Consider a table has two columns and no primary keyemp---------------------empno ename---------------------1 AA2 BB3 CC1 DD --> not duplicate3 CC --> duplicate------------------------
DELETE ...
Latest Answer: An exampleWe accept user and password and validate likeselect 1 from users where username = 'username' and password = 'pwd';What if username string is passed like [x' or 1=1; --]select 1 from users where username = 'x' or 1=1; --' and password = 'pwd'; ...
Latest Answer: yes, to do so ,firstly we have to delete records from the child category/table ...
Latest Answer: SELECT NVL(MAX(EMPNO)+1,0) FROM EMP;This select statement generates empno from 0...N. ...
Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column
Latest Answer: Hi,Even we can use "Encryption" Keyword in MSSQL with Proc... this'll hide text of the Proc from User.Eg.,Create Proc Proc1As Select 1 While Taking sp_HelpText for Proc1, it'll return text written inside proc but......Create Proc Proc2With EncryptionAs ...
Latest Answer: A unique column allows only one NULL valueA Primary key column does not allow single NULL value ...
Latest Answer: Hey Ramesh, I understand your interviewer's enthusiasm to know about the Foreign Key. See foreign key definitions says its states the relationship of one attribute(Column) of one table to the correcsponding column on the other table. So one ...
Latest Answer: Hint are used to alter execution plans of SQL statements. by using hints you will be able to choose the execution plans.for eg. in a SELECT statement your will be able to specify whether an index is to be used or not . If you want to use and index, ...
Latest Answer: stored procedure is a set of precompiled, preoptimized sql queries that is executed faster. ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
