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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.