Explain concepts of analysis services?

0 Answers  

---

What is scrollable cursor?

0 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

How do I edit a stored procedure in sql server?

0 Answers  

---

What is a trace frag? Where do we use it?

0 Answers  

---

Can group by be used without aggregate functions?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

What is an identity column in insert statements?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---