Answer Posted / rajani kant

stored procedure

Definition

please give me Answer

Define left outer join in sql server joins?

715

---

What is failover clustering overview?

768

---

What is the default order of an order by clause?

778

---

How do you create type- insensitive operator?

741

---

What is difference between oltp and olap?

788

---

How to list all tables in the database using odbc_tables()?

756

---

What is bcnf normalization form?

847

---

Define cursor locking

744

---

What is the default schema of your login session in ms sql server?

746

---

How to get a list all databases on the sql server?

780

---

What is de-normalization in sql database administration? Give examples?

718

---

How can you list all the table constraints in a database?

699

---

What is the maximum rows in sql server table?

675

---

What is mssql?

725

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

685

---