Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SubuK
- Order by date
-
HELP !!!! Need to update table with ref. to another table.
You have not used from clause to indicate your ref table.<br><br>Here is an example. I assumed that Ebase is the ref table containing EbFlxId.<br><br><br><br>UPDATE Ejob<br>SET<br>EjSupervisor = EbLastName + "," + " " + EbFirstName<br>FROM Ejob, Ebase<br>WHERE...- SubuK
- Post #2
- Forum: Microsoft SQL Server: Programming
-
I still have this problem! How can I duplicate Rows. SomeBody?
You have to turn on the IDENTITY_INSERT on that Table and the command is<br><br> SET IDENTITY_INSERT <table> ON<br><br>and then insert the rows. Normally IDENTITY automatically inserts a running sequence number. When IDENTITY_INSERT is off then it will not allow you to insert any...- SubuK
- Post #4
- Forum: Microsoft SQL Server: Programming
