SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Newb with SQL in school learning - class project help


Newb with SQL in school learning - class project help

Author
Message
Chuck112
Chuck112
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 14
Okay here is my situation, I have a database that I had on my website and I want to use it for my class project. Well I'm sure it was MySQL not SQL but with some time I have gone in and fixed a lot of the code.

Here is my problem being new to the whole SQL I am missing some of the basics and I have searched on the forums and Google but I don't think I'm asking the right question. I'm hoping you can help me understand what it is that I'm doing wrong.

When I uploaded the .sql file it had 23,000 lines of code I am 50% done with fixing the issues but I saved the project and now I have no idea how to open all the lines of code. I know it has to be with New Query but how do I get everything. so I can see all the errors that it is creating and I can go in and fix them.

Please ask me questions its the only way I can learn and understand the basics better.

Thanks
KC
Chuck112
Chuck112
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 14
I must have missed it but if a moderator would move this in to the Newbie section would be great...
Igor Micev
Igor Micev
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10524 Visits: 5157
Hi, there is a "Parse" button in ssms which tells you some incorrect syntax of the t-sql.
For tracking what you've changed you can use a SVN, e.g.: http://www.simple-talk.com/dotnet/.net-framework/tortoisesvn-and-subversion-cookbook-part-9-server,-repository,-and-statistics/
Download link http://tortoisesvn.net/

Igor Micev,
My blog: www.igormicev.com
mickyT
mickyT
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2896 Visits: 3318
Hi

If I've understood your question, you've saved your code using 'Save solution'. If your SQL was copied into a new query window then you would have been prompted for a file to save to. This will generally go to 'User Directory\My Documents\SQL Server Management Studio\Projects'. You should also be able to get to it from the 'Recent' drop down menu in the 'File' menu.

Personally for large SQL scripts I try to break them up into smaller more manageable chunks and merge them back together to run if necessary. Most of the time this isn't necessary though.

Micky
davoscollective
davoscollective
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1705 Visits: 1008
If this is MySQL then this isn't really the right place, this site is for Microsoft SQL Server, but the first question I would ask you are what tools are you using? How did you 'upload a file'?

Most website management systems would give you access to something like PHPMyAdmin or some other web based tool for running queries and managing your MySQL Database. If it's SQL Server, are you using SQL Server Management Studio, or some other software?

When you say you 'uploaded a .sql file' it makes me think that you haven't actually run the code against the database so it is not really saved within your database. Maybe you've uploaded the .sql file to your webserver? (which would do nothing)

MySQL and SQL Server don't store .sql files as part of their schema, you run the SQL script and it then makes changes to the database. For example if you are creating a procedure or function, it will store that object and its definition in the database itself, not as a separate file. Maybe you know that.

It sounds to me like you are struggling with how the tools work, not with the SQL Language.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search