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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.