What are system databases in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What functions can a view be used to performed?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
How to create function with parameter in sql server?
Can we use where clause with group by?
Do you know clustered and non-clustered index?
how will u create "n" possible tables in sql...
What are the types of lock supported by ?
How to read 2nd highest sal from EMP table?
Explain indexed view?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
What do you mean by an execution plan?
Which one is faster delete/truncate? Why?