visual tool for writing SQL qeuries inside SQL server

[tina104291325]

is there any tool that can help me make SQL statements inside SQL statement

[swatty]

Did you try the Query Analyzer tool ??

[tina104291325]

where can i find that tool i have install only MSDE and i want a tool to help write queries , to do something like compiling the code tell me what is wrong with the statement and stuff like that

[Gary.Lowe]

Tina

I wrote a vb app that parses an SQL statment by brginning a transaction then executing it.

If it works it you don't get an error if it doesn't it raises and error.

I then simply rollback

[tina104291325]

my main problem is that i have design a large access dB with a lot of procedures inside. Now i m tryimng to upsize to SQL server but im stuck the code is so different i cannot even know how to use an switch statement. any ideas ?

[Tailgun]

I found this little prg that gives you access to MSDE. Give it a try if it works you can buy it. I think its around $50 upppppppps can't attach it 112kb and 100 is the limit

I don't remember where I got it so can't give you an URL. If you want to give me an e-mail I will send it.

[tina104291325]

[email protected]

thnks

[Tailgun]

I just e-mailed it to you

[Tailgun]

Here is another little prg that you can run Queries against SQL for testing. You will need to change the Adodc to your connection information.