what's the use of "cross join" in dbms(sql)?
360031
While not used very commonly, a cross join is the foundation upon which inner joins are built. A cross join returns the cartesian product of the sets of rows from the joined tables.\n\nThe SQL code for a cross join lists the tables to be joined (FROM), but does not include any filtering predicate (WHERE).\n\nExample cross join (ANSI 92 standard syntax):\n\nSELECT *\nFROM employee CROSS JOIN \n     department;\nExample cross join (non-standard syntax):\n\nSELECT *FROM employee,department;\nExample results:\n\nLastName     DepartmentID    DepartmentName     DepartmentID \nSmith             34                     Sales                       31 \nSmith                   34                 Engineering                  33 \nSmith                   34                     Clerical                     34 \nSmith                   34                   Marketing                    35 \nJones                   33                      Sales                        31 \nJones                   33                   Engineering                  33 \nJones                    33                     Clerical                      34 \nJones                    33                   Marketing                     35 \n...16 more rows... \n\nAs you can see the cross join does no matching of like records. These joins are occasionally used to generate all possible combinations of records from tables that do not share a common element.
1088795
Use SQLDMO and SQLDTS both are references for the SQL Server. But they should also work with Oracle. But it's a crazy thing. I just do it on an SQL Server and you get mad by solving all the errors you can get.\n\nHelmut\n\nP.S.: A good source to get a idea about it, download the SQL Samples and look for the Bulk Insert Task
601078
You need to create an extremely large varchar variable and then you need to cursor thru your table and find all the Note Times that are 5/2/2006 or whatever note time you want them to be. Then you need to append the note time and the note to the end of your varchar variable.\n\nGoogle Cursors in SQL to see how cursoring thru a table is done.\n\nNOTE: As a software developer I cannot in my professional capacity condone the use of cursors. Personally I think they are a huge waste of performance.
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
880176
mysqlimport does exactly that. \n\nhttp://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html
719576
One could use subqueries to solve this problem. If you are using SQL, u could try the following :- \n\nSELECT col1 from TABLE_A where col1 NOT IN (SELECT col2 from TABLE_B)\n\nNote - make sure col1 and col2 are compatible data types.
938312
INSERT INTO table_name (field1, field2, ...) VALUES ('value1','value2'...);
840316
I have used SELECT IF EXISTS in my SQL statement before, but I couldn't find a good example.\n\nSee the souce page below that checks for rs.EOF to see if there are any records returned after a regular SELECT statement.\n\nGood Luck!
536894
Make an ODBC and then use the JDBC-ODBC Bridge to connect to Access and issue SQL Statements to insert records in your DB!
682934
If you have a 1 to many relationship all you need to do is select the corresponding key and then loop to insert the rest of the records into the second table. For example. \n\nuser table\nuserid as int\nuname as varchar(50)\notherdata\nother data\n\nphonenumber table\nuserid as int\nphone as varchar(16)\n\nTo insert three phone numebrs for user John Doe you so a \nselect userid from user where name = "John Doe" ;\n\nNow that you have the userid, assuming they are in an array. \nfor i = 1 to number_of_phonerecs\n   insert into phonenumber values (varuserid,varphone(i));\nnext\n\nExcuse my SQL as it's late and this is an oversimplified example.
435503
First of all what specifically do you want to know?\n\nRDBMS or Relational Database management systems work by using relations to link tables to eachother. you can have multiple table that hold various kinds of data and have it all be mapped to one or many keys. You essentially are able to create one to one or one to many relations between your tables using RDBMS
774615
I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161\n\nHope that helps! Sounds like fun!
945171
The problem is that Microsoft Access, as I am sure you are aware, is very limited in its use. It is great for hobby projects, and small applications, but for commercial applications, you hit the wall very quickly.\n\nIn MS-Access 2003, a 7-table join is the upper limit. If you want to join more tables in a query, then you have to rethink your design - or denormalise the database, which defeats the purpose of proper design in the first place.\n\nI have written a medium-sized commercial application in MS-Access, but I stretched the limits of what MS-Access could handle, in almost every way imaginable, and I would never want to build a career in programming MS-Access :-)\n\nMy suggestion is therefore... Since you know MS-Access, sell yourself as a VB developer - it should take little time to bring yourself up to speed on the differences in Basic dialects, and you end up with a more robust platform. You could also go for C# or another .Net language.\n\nGood luck :-)
318999
You can use blob (Binary Large Object).SQL Server supports it.
1018112
trying adding a distinct clause.  Select (distinct) from...  what's your query.
687215
Select NAME THE FIELD AND CONDITION\nFrom NAME THE TABLE\n\nUNION (This is the operator to combine tables in SQL)\n\nSelect NAME THE FIELD AND CONDITION\nFrom NAME THE TABLE;
61405
Convert the parameters in your "where" clause to the same case, upper or lower.\n\nselect * from tbl \nwhere upper(fielda) = upper(searchparameter)\n\nI've not worked with Access (.mdb) dbs much, but there may also be an Access configuration to disregard Case.  (At least that is an option in MS Sql Server.)