Jump to content

New to MS SQL.


coldfused

Recommended Posts

Hey everyone, I'm new to MS SQL, I've used MySQL before and that looked a lot easier to use. I'm building a dynamic website for a social club at my university, and they will host me, but they don't have MySQL, so I'm trying to learn MS SQL.

I've installed it with php, apache and it seems to work smoothly with no hiccups. I've been reading online tutorials on how to create tables and learn some new things like which come under a different function name than MySQL.
Anyhoo there are a number of questions I would like to ask.

The first being is that I've installed MS SQL 2005 Express Edition and used the table maker wizard thing to add primary keys, constraints and variables. Is there a saved text version of this schema saved on my PC? because I need to execute the same CREATE TABLE query on the host machine.

Also, I have a user table which stores username and passwords, I tried to enter a row using the query editor in the management studio and it goes like this:

INSERT INTO wucc_users
(first_name,email,warwick_uni_id,username,password)
VALUES
('John Smith','j.smith@warwick.ac.uk',
'0510467','g','b5186280b66ab24234ea7f969faf6b4f')

and it gave me the error message:
[color=red] Msg 208, Level 16, State 1, Line 2
Invalid object name 'wucc_users'.[/color]
And I don't know what to do because as far as I'm aware the code above is correct.
I also have other fields like userlevel, date and ban level which are not included in the above query but they all have default values which shouldn't matter.

Can someone help please?
Link to comment
Share on other sites

  • 4 weeks later...
  • 2 months later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.