Answer / yagnik rohit

declare @temptable table(col1 int,col2 int)
insert into @temptable select 1,2
select * from @temptable

Answer / Mahendra

When a stored procedure takes a table data type as an input or output parameter, the definition in SQL Server will look like this: nCREATE PROCEDURE proc_name @table_param TABLE_NAME AS ...nHere, TABLE_NAME is the name of the table data type. To create user-defined table types, you can use CREATE TYPE statement.

What is updatable resultset?

1 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1 Answers  

---

What is built-in/administrator?

1 Answers  

---

ow to bring suspect mode datbase online from scratch

1 Answers  

---

Explain about remote stored procedure?

1 Answers  

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

What are .mdf files?

1 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

Difference between Inner vs outer joins?

1 Answers  

---