visual tool for writing SQL qeuries inside SQL server

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

Did you try the Query Analyzer tool ??

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

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

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 ?

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.

[email protected]

thnks

I just e-mailed it to you

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.