Imagine i have installed Microsoft SQL in my sytem(but really did'nt). To start a database is that all enough or is it with SQL i can only query an already existing database. can i use the SQL to both create and query?
2006-07-20 16:48:50 · 6 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
yes u can use SQL for both..
see the links attached with this answer for details..
i hope this answer would be fulfilling
2006-07-20 17:08:33 · answer #1 · answered by Tarun, TJ 2 · 1⤊ 1⤋
If you're referring to Microsoft's SQL 2005 Express...you can create new databases, create queries, everything you can with regular SQL server except you're not able to do some of the more advanced things such as provide redundancy and thing important for continuous availability.
2006-07-20 16:53:03 · answer #2 · answered by JM 2 · 0⤊ 0⤋
Hi,
With SQL you can creat and quarry database
see for creating database see the Explanation and Example given in the following link http://www.ss64.com/ora/database_c.html
and for quarrying there arw so many commands see the following links
1. Oracle SQL (version 9.2) http://www.ss64.com/ora/index.html
2. SQL server 2005 http://www.ss64.com/sql/index.html
2006-07-20 17:26:01 · answer #3 · answered by Guru 3 · 0⤊ 0⤋
With MSSQL complete installation. You can create your DB. Query an existing one too.
Hope this helps.
2006-07-20 16:56:31 · answer #4 · answered by moin_anjum 5 · 0⤊ 0⤋
yeah.
to create a database just do:
CREATE DB
http://www.w3schools.com/sql
2006-07-20 16:51:42 · answer #5 · answered by iammisc 5 · 0⤊ 0⤋
yeah, or my solution to everything, back up ur computer and do it all again lol
2006-07-20 18:04:26 · answer #6 · answered by emily 1 · 0⤊ 0⤋