Answer Posted / sanjeev kumar

First Method:

select table_name from information_schema.tables


Second Method:

Select Name from sysobjects where xtype='u'

Note: here 'u' means user created

Does a sql server 2005 select statement require a from?

1071

---

Explain the different types of joins?

1043

---

What are the 7 disadvantages to a manual system?

1030

---

Explain external key management in sql server 2008

934

---

What is "scheduled jobs" or "scheduled tasks"?

1026

---

What does dml stand for?

994

---

What happens if an integer is too big for int date type?

1024

---

In what version of sql server were synonyms released?

999

---

What is multi-statement table-value user-defined function?

1051

---

What is entity data services?

1110

---

How to enter date and time literals in ms sql server?

1065

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

195

---

Explain different types of self contained sub query?

1104

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2273

---

What is the language structure to add a record to a table?

1073

---