If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

How do you delete duplicate records in sql server?

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

What is not null constraint?

0 Answers  

---

how to take backup bcp out for a column in table in sql server?

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

What is the definition for sql server 2000?

0 Answers  

---