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

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

How to delete existing rows in a table?

0 Answers  

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---

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

0 Answers  

---

What is the difference between for auto and for nested?

0 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---