March 21, 2007 at 11:28 am
I have worked with MySql and was able to make tables in that Database and whatever else a person wants to do with the server. Now the question is where do I type the syntax with Visual Basic and SQL. Does a person type the Syntax in Visual Basic to have SQL make tables? Because with Visual Basic Express 2005and SQL Express 2005 editions you can actually make the tables with out typing anything!!! I want to know how to type in the syntax because I have heard that it's more reliable then to use the automated express edition. I am using the express editions Visual Basic and SQL. Thank you for the help!!!
March 21, 2007 at 9:21 pm
If your talking about SQL 2005 then it's in SQL Management Studio.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 22, 2007 at 9:31 am
So using Visual Basic.net edition would make it easier to put information in to SQL? I want to take peoples first, last, Address, City, State, and Zip with a picture of them and have it save with a click of a button. Then be able to search for the person afterwards.
I have made tables before with MySQL. Now using SQL I type the syntax in the Query Analyzer to make the table. I do have a copy of Visual Basic.net. I am going to install this and Full trial version of SQL 2005. I am downloading SQL 2005 then install Visual Basic.net. Now i need some guidance on where to insert the code. But I will look at his when it all gets installed. Any pointer that I should take? Thank You for the help!!!
March 23, 2007 at 10:37 am
The best graphical environment for managing SQL Server is Management Studio, but it's not the only way. The fancier versions of Visual Studio also include database management tools. There are also other tools from vendors like RedGate, Quest, and Apex that do a great job.
But if your question is how to do it with Visual Basic (from a running program), you can put any SQL DDL statement (CREATE, ALTER, etc) in a string and execute it using a command object. In VB6 it would be an ADO command object, in .NET it would be a SqlCommand object.
You can also build CREATE TABLE scripts in NotePad and run them with osql.exe (SQL 2000) or sqlcmd.exe (SQL 2005).
March 23, 2007 at 4:38 pm
Ok... Thank You for the help... I'll work on this and see what i can do. If you can think of anything else please post it that would be great!!!Again thank you for the help!!!
April 27, 2007 at 12:20 pm
I am in a similar situation, using Visual C# instead of Basic, with SQL Server 2005 Express. Express doesn't seem to include the Management Studio. I am forced to do all of my work within Visual C#, using table adapters, and it isn't as versatile. I am used to having Oracle Enterprise Manager amd SQL Plus and doing all of my table design and manipulation there, and SQL 2K5 express leaves me with some things I cannot accomplish, until my company gets the full version of SQL Server!
April 30, 2007 at 8:46 am
Actually unless you need the Agent everything in the regular is in the Express Advanced. Try the link below to download the version with Management Studio and more with service pack 2. Post again if you still have questions. Hope this helps.
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply