what is procedure in sql?

2 Answers   Millennium, SQL,

---

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is the difference between row_number and dense_rank?

0 Answers  

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---