how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

How to verify a login name with sqlcmd tool?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Can you explain various data region available in ssrs with their use?

0 Answers  

---

---

What is proper subset of candidate key?

0 Answers  

---

Can a unique index be created on a column, which contains null?

0 Answers  

---

How do you manipulate data?

0 Answers  

---

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

How to create stored procedures with parameters in ms sql server?

0 Answers  

---