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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jjrockman

    Create new datadase from Visual Basic

    If your application already runs SQL statements like INSERT, UPDATE, SELECT - then replace INSERT INTO myTable...etc with CREATE DATABASE myDB. The CREATE DATABASE and CREATE TABLE statements are just SQL statements that work on database objects instead of data.
  2. jjrockman

    Interesting Query, ... I Supose

    I somewhat disagree with the solution that CCTC1 provided...indeed his/her query does work for providing returned rows for the months that you have data for, but a query itself cannot make up for the data that is missing. For example, if you are missing one month from the year 2000, no query...
  3. jjrockman

    Create new datadase from Visual Basic

    Hi. If you are familiar with SQL Server's Transact-SQL Language, there are special commands that are outside of the ANSI SQL specifications. To create a database, run a SQL Statement against your SQL Server - "CREATE DATABASE myDB" without the quotes, and replacing myDB with whatever...

Part and Inventory Search

Back
Top