Free T-SQL editor

[luhai]

Well, I started using SQL server 2000 for my class in college. It seems the editor included in the SQL Server is more like a mat lab type command prompt than an actually editor as it don't save the code entered. And I must delete the executed code in order to write new one. I been writing the code in prompt and copy and paste to notepad, then print it out and turn it in class. Well, it gets tedious and sometimes codes lost in the copy and paste process.

My question:
Is there a free editor that highlights code just like SQL server, but basically functions like notepad. This way I can actually write the code in editor then copy and paste it to SQL server? It would be better if it can parse the code too, but it's not necessary.

I have gotten used to Java and C type editor and compilers just wonder if there is something like that for T-SQL, free.

Thanks,

luhai

 

[alent1234]

in query analyzer just highlight the part you want to run and execute it

and you can save code just fine. people on sqlservercentral have hundreds and thousands of pieces of code and queries saved in their personal collections

 

[Smilin]

Originally posted by: alent1234
in query analyzer just highlight the part you want to run and execute it

and you can save code just fine. people on sqlservercentral have hundreds and thousands of pieces of code and queries saved in their personal collections

:thumbsup:

Just leave all the code in there. No need to clear it each time.