Answer Posted / m arunachalam

Constraints are used to limit the type of data that can go
into a table.

Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).

We will focus on the following constraints:

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Write the SQL query to drop, truncate and delete table.

973

---

What are the advantages of sql stored procedure?

1074

---

What according to you is the difference between mysql and sql server performance?

1088

---

What is a subquery in a select query statement in ms sql server?

1131

---

What is tempdb in sql server?

973

---

How to transfer an existing table from one schema to another schema in ms sql server?

981

---

Explain datetimeoffset data type in sal server 2008?

908

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2399

---

Do you know the cursor types?

1156

---

What does it mean to normalize a database and why would you do it?

979

---

Explain an automatic checkpoint

972

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

953

---

How to apply filtering criteria at group level with the having clause in ms sql server?

1002

---

Does sql server use java?

1074

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2236

---