Answer Posted / thirumal

count(*) returns the total number of not null values in
given column

What is a select query statement in ms sql server?

1006

---

what is an index? : Sql server database administration

929

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

961

---

What command is used to create a database in the sql server and how?

1111

---

How to create an inline table-valued function?

906

---

Can you pass expressions to stored procedure parameters?

968

---

what is the difference between count(*) and count(1) ?

1025

---

How to create new tables with "select ... Into" statements in ms sql server?

927

---

What are the aggregate and scalar functions?

990

---

What are different type of Collation Sensitivity?

944

---

Can You Use Data Mining Models In Ssrs?

137

---

What is the difference between rank and dense_rank?

990

---

What are distinctive joins find as a part of sql?

906

---

what is spatial nonclustered index

942

---

How to convert numeric values to integers in ms sql server?

1004

---