Answer Posted / vikas

Create,insert,select,update

Are all views updatable ?

1204

---

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

2278

---

Define outer join in sql server joins?

993

---

What is the difference between clustered index and primary key?

974

---

Will the writetext statement activate a trigger?

1156

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

1106

---

What are horizontal and vertical scaling?

172

---

Can we hide the definition of a stored procedure from a use?

1299

---

What are .mdf files?

1016

---

What is 5nf in normalization form?

1046

---

Can we perform backup restore operation on tempdb?

1078

---

Can you explain powershell included in sql server 2008?

993

---

How to optimize stored procedures in sql server?

1242

---

Create and insert into temp table in sql server?

1084

---

How will you optimize a stored procedure optimization?

1116

---