can u provide me sql queries (complex)?
923309
Queries can be a very complex things, involving one or more tables of the data-base.\n\nBut any example is specific to the DataBase structure you have. You can read a lot about SQL queries in the "mysql" (http://www.mysql.com/) documentation.
1033121
That being a microsoft program u can use a ligter version which i beleive is free too... it's called SQL 2005 Express Edition... if you want something fully robust and not deal with the high cost, I would personally recommend MySQL. I have used it in all my softwares and we currently use it in our main datacenter to handle all our data from our 35 remote offices world wide... it is extremely fast... we handle over a million transactions a day... give it a try.
768463
You get database libraries for the 'C' language. For eg. SQL server has such a library, you can find some examples also. You can use standard API like ODBC, JDBC also.
294743
These sites are great learning resources.\n\n\nhttp://www.softwaretrainingtutorials.com/ms-transact-sql.php
179507
www.sqlcourse.com\nwww.1keydata.com/sql/sql.html\nwww.w3schools.com/sql\nwww.geocities.com/SiliconValley/Vista/2207/sql1.html\nsqlzoo.net
1001381
how about creating a dynamicly driven website with SQL engine.  Where you can add stuff and easily search it in the search bar.  That would be a good one for you.
292370
you may visit this side\n\nhttp://www.e-learningcenter.com/oracle.htm\n\nanother direct tutorial site is ;\nhttp://www.db.cs.ucdavis.edu/teaching/sqltutorial/
461228
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=58
258694
http://www.unixspace.com/context/databases.html
520398
You should run it through "explain plan" and depend on the output decide how to optimize your query
346060
just try going to this link\n\nhttp://www.w3schools.com/sql/sql_intro.asp\n\nmight help
608144
Rob Conery discusses some OLAP drillthrough procedures in his SQL server blog...\nhttp://www.wekeroad.com/blogs/CategoryView,category,OLAP.aspx
896456
mySQL should be part of your solution.\n///
484774
Query the RDBMS's internal schema for that information. Also can check data types using regex on values, as well as defining meta-data for test you want to run, and a utility script to use it against defined tables.  (If the database is set up correctly, you shouldn't experience anomalies in the first place.)
508273
Well PHP and MySQL is the Best you can get for this......\n\nhttp://www.php.net/manual/en/ and Dive into the world of PHP
77222
You just have to know the basics of the database structre and how the data is stored. Belive me its not difficult.
1054967
certain databases like mysql achieves this by using the dot operator "."\nsay db1 has table1(field1) and\ndb2 has table2(field2)then \n\nselect a.*,b.* from db1.table1 a,db2.table2 b where\na.field1 = b.field2