Monday, February 20, 2012

need help with web developer

hey everyone...guys i'll be honest i am a noob to web developer but i want to learn this real bad..i have been given a task from my teacher to make a table in SQL...i am really confused how to create a table? i have used the sql+ an old version before but i dont find any sort of an editor excep for the visual web developer itself..i can see a table designer but it is not accessible...i am really sorry for my noobness but i really want to learn...awaiting replies

You need to install SQL Server Express with Management Studio if you have not installed it and use the videos in the links below to guide you to create tables and other objects in SQL Server. Hope this helps.

http://www.asp.net/learn/videos/

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2036523&SiteID=1

|||

In order to create objects in SQL using VWD you will need to create a database first. You can create a database in VWD using the normal 'Create...' dialog box, just choose SQL Databasee when presented with the option. Once you've done that you should be able to pull up the database in VWD and do things such as create new tables.

You can also use Management Studio as has also be suggested, but you should check with your teacher to see if there is a prefered path you should follow. Creating a database and table using Management Studio has different ramifications than using VWD. If this is part of a larger class project about creating a program in VWD that uses a database, then you should use the VWD tools to create the database so that your ultimate VWD project can find the database easily.

Mike

No comments:

Post a Comment