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 integercol2 varchar(20)) insert into maintable(col1col2) values(1'AAA') insert into maintable(col1col2) values(2'BBB') insert into maintable(col1col2) values(3'CCC') insert into maintable(col1col2) values(4'DDD') insert into maintable(col1col2) values(5'EEE') insert into maintable(col1col2) values(6'FFF') insert into maintable(col1col2) values(7'GGG') insert into maintable(col1col2) values(8'HHH') create table copytable(col1 integercol2 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(col1col2) values ( 'network' 'VALUE') SELECT col1col2 From UserTable where user1 = bala