what is the main difference between constraints(like primary key etc..)& j

what is the main difference between constraints(like
primary key etc..)& joins?

Question Posted / amit

2 Answers
6115 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the main difference between constraints(like primary key etc..)& joins?..

Answer / ravikiran

Constraints are the mechanisms used by the sql server to
control unwanted or invalid data flow into a table.

Joins are the queries used to combine the rows from two or
more tables.

Is This Answer Correct ?

2 Yes

0 No

what is the main difference between constraints(like primary key etc..)& joins?..

Answer / monal

Constraints are restrictions to make sure that data entered
in a table must meet certain crietria. You can put
constraint at either table level or column level. There are
5 types of constraints. Primary Key, Foregin Key, Unique,
Check and NOT NULL.

Joins are used to combine rows from one or more table. One
table using Self Join and More tables using inner join,
outer join, cross join.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More SQL Server Interview Questions

When we should use @@error?

0 Answers

What is the need for group functions in sql?

0 Answers

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers

Define DML and DCL statements?

1 Answers Hexaware, NIIT,

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers Wipro,

What is the maximum size per database for sql server express?

0 Answers

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers Techno Solutions,

What are the difference between clustered and a non-clustered index?

0 Answers

How to remove duplicate rows from table except one?

0 Answers

Explain the xml support sql server extends?

0 Answers

For more SQL Server Interview Questions Click Here