please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

How can I create a new template for import ? : sql server management studio

0 Answers  

---

How to create new tables with "select ... Into" statements in ms sql server?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

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,

---

Can a function call a stored procedure in sql server?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

How to generate create view script on an existing view?

0 Answers  

---

What do you understand by user-defined function in the sql server?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---