Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to create own database without using server

Author  Topic 

JadeV
Yak Posting Veteran

62 Posts

Posted - 2012-09-11 : 22:16:36
I am going to do the assignment at school using SQL to retrieve database, but I don't have the server to retrieve database. I don't know how to make the own database to run the SQL query.

I heard some people said create the web page, but I don't know how to do it.

Anyone can help me how to do it?

Thank you

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-09-11 : 23:16:41
you can use the Express edition. It is free

http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-12 : 01:55:18
Once the sql server is set . You'll need to create an ODBC ( although there are other ways of connecting such as DSN-less) , and connect from you your page. What scripting language are you using?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

JadeV
Yak Posting Veteran

62 Posts

Posted - 2012-09-12 : 10:29:21
If create an ODBC, I must have name of data source and server, but I don't have a server
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-09-12 : 10:40:21
If you install SQL Express, you can use (local) as the server name (include the parentheses).

Edit: You don't have to use ODBC either, or set up a DSN. You can find examples of connection strings here: http://www.connectionstrings.com/sql-server-2008
Go to Top of Page
   

- Advertisement -