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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by koniba
-
updating several tables
Thank you very much for responding so quickly to my question. I will try this right away. Thank you again, Koniba.- koniba
- Post #5
- Forum: Microsoft SQL Server: Programming
-
updating several tables
Thanks very much. However, I tried yours and I got two errors messages 1) Variable must be declared first. I declared a variable And got: 2) "Invalid Character" for "@@" sign preceedint the "INDENTITY". When I run my own statement on the sql query analyzer the...- koniba
- Post #3
- Forum: Microsoft SQL Server: Programming
-
how to get the last product id and increase it by one "very urgent"
I am very new in sql and asp. I am updating several table with information. I needs to capture the last product id in the Product table and increase it by before inserting it in other tables. How do I do that using vbscript and sql? Dim proid proid = "SELECT (Last_ProductId) + 1 FROM...- koniba
- Thread
- Replies: 2
- Forum: Sybase: Adaptive (SQL) Server
-
updating several tables
I have several tables where I want to add information to for a user interface which does not have the productid. So I want to capture the last productid and (1) to it for the next productid and insert that id info into three tables ( commnets, phase, phasedescription). Here is what i think will...- koniba
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
