Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to give input dynamically to a insert statement in
sqlserver

Answer Posted / 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)

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of database schema? : sql server analysis services, ssas

1187


What is data source object?

1064


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1098


How to list all tables in the database using odbc_tables()?

1114


Define tool Manage Statistics in SQL Server 2000 query ?

1166


How do I start and stop sql server?

1060


Explain system views?

1130


How do you drop an index?

973


How to stop log file growing too big?

1059


How do I manually uninstall an instance of sql server 2016?

1076


How to connect a database with sql express.?

1115


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1242


what are the different types of replication you can set up in sql server? : Sql server database administration

1062


What is compound operators?

1115


What is the difference between a function and a trigger?

1122