SQL Cursor
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Is it possible to select from 3 tables, and insert into a new table without using a where clause and using the SQL cursor. If so, how would I do that? Any code example?
The examples that come with the help for SQL Server show how to use a cursor. You can use a cursor on any select, across any number of tables. As you step through it, you an insert into a new table from each row.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )