insert a value in a table with where condition

Question

hai,
how to insert a value in a table with where condition in sql server 200.
insert into replies values title='network' where user1="bala"
i use this condition but the error occurs how to solve this

Krishna Garad · Answer

Hi Krithika Insert statement will insert new row in table. According to your query you have to update the record on the basis of of your your where condition. Insert means u are inserting new row and if there is not any column present the how you can write where condition just try like this Update replies set title = 'network' where user1 = "bala"

Subhendu De · Answer

Vijay & Uday, I am sure you can use where clause with insert statement... Run the following example in SQL Server 2008 R2 create table maintable(col1 integer,col2 varchar(20)) insert into maintable(col1,col2) values(1,'AAA') insert into maintable(col1,col2) values(2,'BBB') insert into maintable(col1,col2) values(3,'CCC') insert into maintable(col1,col2) values(4,'DDD') insert into maintable(col1,col2) values(5,'EEE') insert into maintable(col1,col2) values(6,'FFF') insert into maintable(col1,col2) values(7,'GGG') insert into maintable(col1,col2) values(8,'HHH') create table copytable(col1 integer,col2 varchar(20)) select * from maintable select * from copytable insert into copytable select * from maintable where col1 between 1 and 5 select * from copytable

Vijay Yadav · Answer

Hi Subhendu , You cannot insert new row with where conditions Thanks, Vijay

uday kanna · Answer

you cant insert values using where clause

krithika muthukrishnan · Answer

hai, Sorry i forget that for using update condition thanks,

Subhendu De · Answer

I could not get why you use insert with where clause. Insert statement generally inserts row in a table. How WHERE clause fits into that. You can use INSERT with WHERE clause like insert into replies(col1,col2) values ( 'network' ,'VALUE') SELECT col1,col2 From UserTable where user1 = "bala"