Answer / ramadass

Write a store procedure for insert and pass the input value
as parameters to proc.

Answer / ashutosh rai

Declare @id int,@name varchar(100),@class varchar(100)
set @id=1
set @name='Ashutosh'
set @class='MCA'

insert into student_table(id,name,class)
values(@id,@name,@class)

Answer / senthil kumar.m

Declare @sql_tmp varchar(100)

set @sql_tmp="insert into table1(col1,col2..)
select 'val1','val2','') "

sp_executesql @sql_tmp

What do you understand by triggers?

0 Answers  

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

How do I schedule a sql server profiler trace?

0 Answers  

---

What is a subquery in a select query statement in ms sql server?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

What are the steps to insert a table?

0 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

syntex of insert

7 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---