Answer Posted / guest

Pointer is a variable which stores memory address of any
variable

Can two tables share the same primary key?

910

---

How to create percentile function?

151

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1002

---

What is bulkcopy in sql?

939

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1860

---

Can sub report data source be different from that of the parent report?

143

---

Explain throw statement in sql server 2008?

989

---

How network traffic be reduced by using the stored procedure?

1110

---

How to provide login information for a new odbc dsn?

1050

---

Explain relational data?

921

---

What is sql service broker?

974

---

What do you understand by a view? What does the with check option clause for a view do?

994

---

Please explain go command in sql server?

1046

---

Can you use order by when defining a view?

975

---

What is the recovery model? List the types of recovery model available in sql server?

900

---