Answer Posted / ghous

user defines sp...
say i want to select some values based on parameter

create sp dbo.spname
'declare var

@parametername int
as
select * from table_name
where file_name=@parametername

What are the differences between web role and worker role?

124

---

What are different types of statement?

1085

---

Does a sql server 2005 select statement require a from?

1073

---

How to write an inner join with the where clause in ms sql server?

1166

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1170

---

Explain the properties of the relational tables?

1032

---

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

1230

---

According to you what goes into making the best database administrator? : sql server database administration

1024

---

Define outer join in sql server joins?

992

---

What is unpivot?

1077

---

How adventureworkslt tables are related?

984

---

What is it unwise to create wide clustered index keys?

1047

---

What is parameterized reports in ssrs ?

163

---

What is database architecture? : SQL Server Architecture

1101

---

What is a partition function in sql server?

1218

---