What is difference between primary key and foreign key?

0 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

How do you debug a procedure in sql server?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What is the maximum size of a row in sql server?

0 Answers  

---

How do I find the sql server database version?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---