Answer Posted / vijay sultampur

For 1,3,5,7...

select * from emp where (rowid,1) in (select rowid,mod
(rownum,2) from emp);

For 2,4,6,8,...

select * from emp where (rowid,0) in (select rowid,mod
(rownum,2) from emp);

What is the full form of ddl?

925

---

What is a mutating table error and how can you get around it?

1047

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2092

---

What are wait types?

1110

---

How to enter unicode character string literals in ms sql server?

1070

---

Describe how to use the linked server?

1139

---

How to achieve Paging of records in SQL SERVER?

1098

---

Is there any difference between the primary key and unique key?

999

---

how to take backup bcp out for a column in table in sql server?

2105

---

Explain about unique identifier data type in sql server?

914

---

Where can you find the error log information? : sql server database administration

1025

---

What is temporal data type?

919

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1681

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1023

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

---