Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to start SQL in VB Express Edition 2005?

Author  Topic 

Diletant
Starting Member

1 Post

Posted - 2007-10-18 : 15:03:19
Hi! I am absolutely new in SQL! Pls help me answering some questions!
I have Microsoft VB Express Edition 2005.
So I created my Database1 and my own table Table1 ( by Add Item).
1)Now in "Show SQL Pane" I write my query.
When I write it with error - it is deleting (after Execute or Verify). So I must write it again! How can I save my query (error query!) for not writing it again?

2) After several tries I succeed to write query without mistake.
So I have a result ( Table2). Then I write another query and have Table3. How can I see my Table2 and IT'S QUERY???
Is there is a log option that can write all my queries and under every query - the result table in my session?

Thank u !
PS. Does Microsoft VB Express Edition 2005 contain SQL Server Management Studio?

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2007-10-19 : 11:40:19
why cant u write the query in query tab of sql server 2005 express .so that u can save the query.

RKNAIR
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-19 : 21:54:07
Download ssms express from Microsoft and install it on your machine, you can write queries and see all objects in it.
Go to Top of Page
   

- Advertisement -