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 does <> symbol mean?

0 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

What are the five characteristics of good data?

0 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

How to install sql server 2005 express edition?

0 Answers  

---

What are the differences between triggers and stored procedures?

0 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---