Answer Posted / sannnnnnnnnnn

select max(sal) from emp where sal<(select max(sal) from emp)

explain the storage models of olap? : Sql server database administration

968

---

What is a collation?

1100

---

Can sql servers link to other servers?

1095

---

What is a result set object returned by mssql_query()?

1168

---

Explain datetime2 data type in sal server 2008?

919

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1054

---

How many types of objects are there?

1018

---

What happens when converting big values to numeric data types?

1145

---

Determine when an index is appropriate?

1083

---

Can we create clustered index on composite key?

1094

---

Is sql server 2016 free?

950

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

948

---

If no size is defined while creating the database, what size will the database have?

998

---

What are the advantages of using stored procedures?

957

---

What are different types of schemas?

951

---