Answer Posted / mathan r

It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn
object_value
level
user

Explain “row_number()” in sql server with an example?

1015

---

what is an extended stored procedure? : Sql server database administration

1067

---

What are various ways to enhance the ssrs report?

988

---

Do you know the isolation level that sql server support?

967

---

how many clustered indexes can be created on a table? : Sql server database administration

1159

---

How to run queries with sql server management studio express?

1098

---

What happens if date-only values are provided as date and time literals?

1028

---

Will count(column) include columns with null values in its count?

1106

---

Explain use of expression builder.

1031

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

1070

---

Explain having clause and where clause?

1063

---

What is the primary use of the model database?

1094

---

How to download and install sql server 2005 books online?

1203

---

How do I find the port number for sql server?

975

---

How to defragment table indexes?

1000

---