New to SQL

[geomon]

I know this might sound stupid but how do you view/edit your database? Like do you just use notepad or is there a special program (Other than MS ACCESS)?

 

[DougP]

This is for Microsoft SQL Server 7...<br>One way is go to the NT Server where SQL is loaded and Click Programs, SQL Server, Enterprise Manager.<br><br>Next you should see a list of Server(s) that have SQL loaded<br>We have 3. You may only have one.<br>Then its just a matter of double clicking you way down to databases then Tables. You should see a list of tables. Some are what SQL created to maintain itself etc. Leave them alone. <br>Find a table to edit or view. (I would sugest you mess with the Northwind database for learing so you won't messa nything up.) Double click to see alist of the columns (you can't edit them here). Also Columns in SQL are what Access calls Fields.<br>Right click on a table and click Design to view or edit the columns. <br>To see data in a table or make a SQL statement (like and Access query) Right click on the Table the Click &quot;View&quot; or &quot;Show&quot; records (third from the top) then Show 1000 if you like. <br>While the Records view is open, look at the top of this and click those little buttons. One will show SQL code,One will show a QBE, like grid as in Access.<br>Then you can Add columns and make Update SQL's or Insert values and all kinds of stuff.<br>This is what I use most to get the correct T-SQL syntax for using else where.<br><br>OK thats enough for lesson 1.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[geomon]

Thanks for the help man!