Answer Posted / sandeep rana

Both are used for different purposes like...

select * from table where data in(1,2,3,4,5,6)


select * from table where data in(1,2,3,4,5,6) or data1
like('%s','%t')

What is the report builder?

139

---

What is sql or structured query language?

1148

---

What does the on delete cascade option do?

1016

---

query processing

2160

---

How to assign new column names in a view?

916

---

Tell me what is de-normalization and what are some of the examples of it?

1027

---

What is triggers and its types?

1007

---

how to invoke a trigger on demand? : Sql server database administration

1083

---

What is user defined datatypes and when you should go for them?

1014

---

List few advantages of stored procedure.

981

---

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

2227

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1003

---

How to delete a login name in ms sql server?

1070

---

can we have a nested transaction? : Sql server database administration

1086

---

Difference between report and query parameter. Why do we need different type of parameter?

953

---