Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to insert the same value to multiple fields? in the same table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-23 : 23:54:11
Andreas Kristiansen writes "I tried this variant (below) but it didn't work, could someone please tell me if this feature is availble at all?? and if, how to do it, it would really make my day easier =) thanx in advance

Andreas.


INSERT INTO TABLENAME (FIELDNAME)
VALUES (VALUE STRING NUMBER WHATEVER)
WHERE INTOFIELDNAME='andkri' OR INTOFIELDNAME='Guest'"
   

- Advertisement -