Answer Posted / jyothi

user defines sp...
say i want to select some values based on parameter


create PROCEDURE GetEmployeeDetails
-- Add the parameters for the stored procedure here
@sno int,



-- Insert statements for procedure here


select *from emp where sno=@sno


END
GO

How to connect to SQL Azure Database by using sqlcmd?

136

---

Explain transaction server distributed transaction?

981

---

What is catalog views?

1068

---

Explain Normalization and DE normalization

1114

---

What is cursors? And what are the different types of cursor?

1144

---

Do you know exporting and importing utility?

1042

---

What are the types of subscriptions in SQL Server replication?

1040

---

Explain the ways to controlling cursor behavior?

919

---

What are the steps you will take to improve the performance of a poor performing query?

979

---

Can you explain what are commit and rollback in sql?

941

---

How to change server name in sql server?

1185

---

Explain what role entity and relationship play in an ER diagram.

1073

---

What is the library index called?

1059

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1064

---

What is sql server used for?

1052

---