SQL Editor for Database Developers

• Download source - 352.59 KB
• Download application - 250.17 KB

Features

SqlBuilder is a very useful, powerful and intelligent C# tool for all developers and teams, which works with databases.

• SqlBuilder makes working on SQL servers much easier.
• One of the multiple intentions of SqlBuilder is to completely replace the user unfriendly Microsoft SQL server tools Query Analyzer and Enterprise Manager.
• SqlBuilder has a complicated Syntax Parser, which does not only display SQL commands in color but also automatically converts badly written SQL code into readable code. Long SQL commands like SELECT are wrapped automatically in an intelligent way onto multiple lines and are indented. The parsing happens while entering text. Normally you have to pay a lot of money for this functionality.
• SqlBuilder reads automatically stored procedures, views, functions and triggers from the server and allows to edit and store them.
• SqlBuilder offers a complex Table Editor which allows to change values in table cells as easy as modifying an Excel sheet.
• The Table Editor allows to add / remove columns and to add / delete rows.
• The comfortable Table Designer shows Foreign Keys and Identity values, allows to add / remove Primary and Unique keys, Indexes, modify a column's data type, NULL, Default value.
• SQL commands can be executed and the query result is displayed as a scalar value or as one or multiple tables.
• With CTRL+E you can execute the selected part of the SQL code or, if nothing is selected, the entire code.
• Each file or system object / file has its own Undo buffer which maintains its content even if you edited another file meanwhile.
• All procedures, views, functions, triggers and table definitions can be saved in seconds as *.sql files into one folder. (DataBase Backup)
• You can search for a text string in all procedures, views, functions, triggers and table columns directly on the server. (DataBase Search)
• SqlBuilder was designed for developer teams to store in Subversion or CVS, the procedures, functions etc., that have been changed on the server since the last release and then automatically create ONE huge Compound SQL script for the next release, which is given to the client to execute to update his server. With one click, you create a file which stores all your work since the last release.
• SqlBuilder measures the time of execution of an SQL command with an exactness of 1 ms. So you can compare the speed of different SQL commands / procedures to optimize your code.
• Additionally with CTRL+B, you can first clear the server cache (DBCC FREEPROCCACHE ...) and then execute the SQL command. So you can measure the time an SQL command needs when it is first executed before the server has cached query results. The difference may be a factor of 1:10 or more!
• You can execute two SELECT or EXECUTE queries at the same time which return a dataset with 2 tables and then compare the 2 query results for exact equality. SqlBuilder will tell you if the two results differ even if the lines in the tables appear in a different order. If you wish, SqlBuilder can remove all equal lines from the tables and leave only the different ones. So you can check after a modification you have made on a procedure if it still returns the same data as before.
• You can export query results and tables into an HTML file or an Excel sheet or as an XML file.
• You can export table data to a XML file and import table data from a XML file.
• If you have not yet assigned a program for *.sql files, in the future SQL files will open in SqlEditor. If you have already assigned a default program for SQL files, this will not be changed but in the context menu of Explorer (right click on a file) you will find a new entry "Open with SqlBuilder".
• The very first time you start SqlBuilder, it will add a shortcut to itself in the startmenu and in the quicklaunch bar. If you don't want that, simply delete the shortcut: this will not happen again.
• The SQL editor and Table editor can be controled completely via keyboard. (See button "Keyboard Help")
• The entire SQL execution runs in a separate (abortable) thread so the GUI does not "hang" while you execute lengthy commands.
• This is a living project. The Internet Update Check will show you a messagebox if a new SqlBuilder version is available on my homepage.

Limitations

• .NET Framework 1.1 must be installed.
• I have not tried to compile SqlBuilder on Visual Studio 2005. As Microsoft has never cared about compatibility with older versions of their own software, it may be possible that you have to change some code? It is your own fault if you don't compile on Visual Studio 2003 where it runs perfectly!
• The program was written for Microsoft SQL server. For Oracle or other SQL servers you will have to adapt three *.cs files of the source code which are the abstraction layer which contains the server specific code.

Source Code

Although the source code is VERY complex, you will find a VERY clean and well structured code with plenty of comments written by a very experienced programmer.
(Coding effort: more than half a year!)

Usage

Suppose that you work on a project with multiple release versions of which each has its own folder on your local disk. Choose the folder of the current release in your server project. SqlBuilder will create two subfolders in the working directory: DatabaseBackup and Scripts.

SqlBuilder stores an XML file in the working directory with the server settings (server name, user name, password, etc.) If you work with multiple SQL servers, create a working directory for each server.

It is strongly recommended to ALWAYS additionally add a temporary folder in which you can experiment with SQL commands which are NOT stored in Subversion or CVS.

The next step is adding the SQL files or system objects on which you will work:

The Toolbar in the main window offers the following functionality: (from left to right)

1. Add a new or existing Procedure, Function, View, Trigger, Table, File to the Filelist
2. Delete an item from the Filelist
3. Search in one or multiple databases for a text in a Procedure, View, Table column etc... (see below)
4. Sort the FileList
5. Open the selected table entirely in the Table Editor (see below)
6. Open the TOP 10 rows of the selected table in the Table Editor
7. Build the Compound Script (see below)
8. Create a Database Backup (see below)

Click the leftmost toolbar button and this window will open:

No matter if you:

• Enter the name for a new SQL file or
• Select an already existing procedure from the drop down list or
• Enter the name for a new function,

SqlBuilder will add it to the Filelist of the main window:

There is a big difference between

• adding a File or Table (in blue) and
• adding a Procedure, Function, View or Trigger (in green):

It is very important that you understand the following:

Adding a Procedure, Function, View, Trigger

Adding a system object like a *.PROC, *.FUNC, *.VIEW, *.TRIG file means that all changes to SQL code are stored on the SQL server!
SqlBuilder creates a dummy file (like fn_GetUserById.func) in your working directory which does NOT contain any SQL code!

Adding a File, Table

On the other hand if you add a *.SQL or *.TABL file (like Test.sql above), all changes on SQL code will be stored locally in this file.

You will nearly never use the type "File" (*.sql) except for testing (executing) SQL code under development. Do NOT abuse type "File" (*.sql) to store the definitions of procedures, functions or modifications on tables, etc.!!

With CTRL + TAB you can rapidly switch between all the items in the Filelist that have been selected recently.

For each item in the Filelist, SqlBuilder will create the appropriate file in a subfolder of your Scripts folder. The Scripts folder will have a subfolder for each database.

How to Work with CVS / Subversion

You and all your colleagues will check in the entire content of your Scripts folder into Subversion or CVS. When the new release is ready, you click the button "Build Script" and SqlBuilder will build one huge Compound SQL Script.

This script contains:

1. the contents of all *.sql and *.tabl files (unchanged) and
2. the ACTUAL VERSION of all procedures, functions, views, triggers loaded directly from your SQL server.

Then you pass the compound script to your clients so they can update their SQL server to the latest version.

The SQL Editor

IMPORTANT:
To work with the SQL Editor you must know the keyborad shortcuts. Click the keyboard help button!!

The SQL editor stores all your changes in an Undo buffer which remains intact even after working on another file meanwhile. With CTRL-Z you can always return to the last workstate.

Executing Code

In a File or Table you can select any part of the SQL code and execute it with CTRL + E. If nothing is selected, the entire code will be executed.

Procedures, functions, views, triggers will always be executed entirely when hitting CTRL + E which will store them on the server.
It is recommended to have at least one Temp file in your Temp working directory where you execute SQL code for testing purposes.

With CTRL + TAB you can rapidly switch between all the items in the Filelist that have been selected recently.

If the result of a SQL query is a scalar value or if the query has no result at all, this will be displayed below in the main window:

If the result is one or multiple tables, these will be displayed in the ResultView window:

You always see the execution time with a real exactness of 1 millisecond. (Performance Counter)
If you want to see the execution time after clearing the server cache, use CTRL + B instead of CTRL + E.
CTRL + B disables all server optimizations, like buffering the query results, so you will see the worst case execution time.

The Toolbar of the Result View window offers the following functionality: (from left to right)

1. Search a text inside the query result datagrid
2. Compare two query results by their content (see below)
3. Export all tables of the returned dataset into an Excel sheet
4. Export all tables of the returned dataset and the SQL query into a HTML document
5. Export the currently selected table into a XML file
6. Show the keyboard shortcut help for this window.

Comparing Query Results by Content

In the ResultView window you can compare the contents of two tables.

To use it, you must send two SQL commands to the server at the same time.

Example:

EXEC proc_GetUserData 877, 1
EXEC proc_GetUserData_New 877, 1

The SQL server will return a dataset with two tables. If proc_GetUserData is a stored procedure and proc_GetUserData_New is a procedure which you have modified, you can test how your modifications affect the returned data.

The Table Editor

The Table Editor is a very powerful tool in SqlBuilder. It allows you to edit tables on the SQL server as if they were Excel tables. You can set the cursor into a cell and modify its value. When you are done with all changes you save the changes. After closing the TableEditor you will see all the SQL code that has been executed in the *.TABL file in the main window. These changes will automatically be included into the compound script if you didn't delete them.

The column's background color changes if the column has a UNIQUE or PRIMARY key. The column's text color depends on the data type (string, integer etc..)

The Toolbar of the Table Editor offers the following functionality: (from left to right)

1. Search a text in the table
2. Generate all SQL commands required to save all changes to the server that have been made on the table cells
3. Reload the entire table from the server.
4. Reload the TOP 10 rows of the table from the server.
5. Add a new row
6. Delete the row which has the cursor
7. Add a new column
8. Delete the column which has the cursor
9. Open the Table Designer (see below)
10. Build all SQL commands which are required to create this table and its columns and all its content from the scratch.
11. Export the table's content as HTML document
12. Export the table's content as Excel sheet
13. Export the table's content and the column definitions and their constraints into a XML file
14. Import the content from a XML file into the table (append to current content or replace current content)
15. Show the keyboard shortcut help for this window.

The Table Designer

The Table Designer is a very powerful tool that allows you to view / modify:

1. the data type of a column (e.g. changing varchar(10) into varchar(50))
2. the Identity (Seed / Increment)
3. the Default value
4. the Indexes of a column
5. the Foreign Keys from this table to other tables
6. the Foreign Keys from other tables to this table
7. allow / disallow NULL for the column
8. add / remove a Primary key
9. add / remove a Unique key

The job of the Table Designer is very complicated because Microsoft's SQL is so incredibly primitive. You will see that when you study the SQL commands which have been executed after modifying an existing primary key in a column which is referenced by foreign keys.

Autogenerated code example:

As you see, SqlBuilder tries to generate universal SQL scripts:

• If the User with the ID 56196 already exists, its data is updated.
• If the user does not yet exist, a new row is added to the table.
• Microsoft's SQL is so incredibly primitive that there is no easier way. (doing this with one single command)
• You can give a script which updates table data to an administrator of one of your clients and it will always run without errors even if it is run twice.

But if you modify Constraints this will not be possible because the names of the Constraints differ from server to server.

Again: Microsoft's SQL is so incredible primitive that there is no universal way to delete a Constraint without knowing its name.
Commands like the following are not accepted by Microsoft SQL server:
ALTER TABLE [TableName] DROP UNIQUE (ColumnName)
ALTER TABLE [TableName] DROP PRIMARY KEY

Using the Developer Comment

The developer comments for procedures, functions, views and triggers are ONLY for internal use for you and your colleagues!
They will neither be written into the compound script nor stored on the server.

Before hitting the "Build Script" button, you should re-order the Filelist in the main window by drag and drop. The compound script will be built in the same order as you see the entries in the Filelist.

If the compound script creates a new procedure which depends on a new function you must FIRST create the function, THEN the procedure to avoid errors on the SQL Server of your clients. Use the developer comment field not to forget this:

The developer comments are stored in the local files *.Proc, *.View, *.Func, *.Trig.

With the next time you check-in int Subversion / CVS the comments will be available for your colleagues.

Database Search

SqlBuilder can search directly in all databases for a text to be contained in a procedure, function, table column etc... The results are displayed as a list of the found system objects with their content beside. You open the Database search from the toolbar in the main window.

Database Backup

It is recommended to use the button "Database Backup" (in the toolbar of the main window) at least once a week and check in the entire folder DatabaseBackup into CVS/subversion to backup your work on procedures etc...

Even if your SQL server has a backup system and you fully trust it, the advantage is that you can compare the procedures, functions, views etc. with older versions by using the built-in compare functions of CVS / Subversion (or another compare tool like Araxis Merge) and you can verify which procedures have changed and what the differences are to older releases.

The files in the backup folder have the date of their creation on the SQL server. Sadly the date of the last modification is not stored on Microsoft SQL Server.

Details

The SQL Parser

The SQL parser is the heart of the application and the most complicated part. Writing a parser for HTML code or for C++ code is extremely simple in comparison to an SQL parser which is a challenge.

While other programming languages have fixed syntax rules (e.g. in HTML every tag starts with <TAG> and ends with </TAG> or in C++, every command has the form function(argument, argument); and every line ends with a semicolon), SQL is a "language" without rules.

• There is no way to know where a command ends. The most complicated command SELECT may have a WHERE clause or not. It may have a JOIN clause or not, etc. It simply ends where no more clauses follow.
• Linebreaks may appear at any place or may be COMPLETELY missing.
• Parenthesis can optionally appear at any place or not.
• Some commands (e.g. LEFT) may be a keyword (in JOIN LEFT) or a function (in left(string, count)).

Finally, SQL is not a programming "language" at all. And this may be abused by inexperienced programmers to produce code which seems to come directly out of hell. The parser of SqlBuilder is capable of cleaning up any ugly SQL code.

It works in 5 steps:

1. The first parser parses the plain SQL text and searches for commands, keywords, functions, data types, operators, strings, numbers, comments etc. and for each of them creates one instance of ParseItem which is stored in a double linked chain.
2. The second parser parses all parenthesis and breaks them up onto multiple lines if they have complex content.
3. The third parser recursively parses some complex commands like SELECT, CASE, CREATE, BEGIN, END,....
4. The fourth parser parses and corrects all linebreaks
5. The last parser fills the RtfHtmlBuilder (see below) with the parsed data to create an RTF document, HTML code or plain text from the parsed data.

Only the first step works with plain text. The following steps work with objects and this makes the parsing very fast so it can happen while entering text. If you enter a new letter while the previous parsing did not yet finish, the previous parsing is cancelled and parsing is started anew. All this runs in the background invisible for the user!

The Class "Defaults"

SqlBuilder has a class with the name Defaults. Here you can define YOUR preferred default settings for the entire program like the colours for the parser, the timeout or the default SQL server if not yet specified by the user.....

Special Controls

SqlBuilder has some special control classes which you can copy and use in other C# applications.

RichTextBoxEx

This class is derived from RichTextBox and extends it with more functionality:

• A "Search and Replace" dialog
• A "Goto Line" dialog
• A display of the current line and character position in a status bar
• Advanced scrolling functionality
• Flicker-free replacing of the entire RTF content in the control maintaining the cursor position
• Undo Buffer
• Ultra fast RTF creation with RtfHtmlBuilder

RtfHtmlBuilder

If you ever used Microsoft's RichTextBox control and tried to display coloured text, you already know that:

richTextBox.SelectionColor = Color.Red;
richTextBox.SelectionIndent = 5;
richTextBox.AppendText("Text");
....

is EXTREMELY slow. It is so incredibly slow that for the display of a text of 50 KB, the user has to wait 20 seconds!

RtfHtmlBuilder is an ultra-fast RTF, HTML and PlainText creator class.

rtfBuilder.SelectionColor = Color.Red;
rtfBuilder.SelectionIndent = 5;
rtfBuilder.AppendText("Text");
.....
string s_Rtf = rtfBuilder.BuildRtf(new Font("Microsoft Sans Serif", 17));
richTextBoxEx.ReplaceRtf(s_Rtf); // flicker free text replacement

ListViewEx

This class is derived from ListView and allows drag and drop of the items in the view to change their order.

DataGridEx

This class paints the datagrid cells in different colors and has some more features. It has five workarounds built in for really ugly Microsoft bugs in this control. The DataGrid is by far the most buggy control in .NET framework!

PasswordTextBox

This class allows input of passwords which cannot be spied out with an API spy or a .NET spy. The password is stored internally as encrypted string.

The textbox shows the password as plain text while you are typing it, otherwise it displays 12 stars no matter how long the password is.

P.S. On my homepage, you can download an SQL book for beginners in CHM format (German) and much more utilities.

You must Sign In to use this message board.

FAQ    Noise Tolerance Very HighHighMediumLowVery Low   Layout Expand Posts & RepliesThread ViewNo JavascriptNo JS + Preview   Per page 102550

Msgs 1 to 25 of 35 (Total in Forum: 35) (Refresh) FirstPrevNext

My vote of 1 Alex_V_X 12:59 15 Oct '09   Poor knowledge of databases Sign In·View Thread·PermaLink Nice. itayl 13:13 27 May '09   EZManage SQL Pro got a very good query editor you can use to get results from all your servers http://www.futureitsoft.com Sign In·View Thread·PermaLink Re: Nice. Elmue 6:34 28 May '09   Obviously you can use EZManage SQL Pro and pay 1350 US$ for it. And obviously you will not have the sourcecode of the tools you use. Do you work for them ? Or why do you post that here ? Sign In·View Thread·PermaLink Suggestion Alexandru Matei 3:14 18 Sep '08   Hello, 1. Could you please consider adding a Filtering option to the "SQL Result View" grid and "Table Editor" grid ? Right clicking a grid cell would show a menu with the following options = Cell Value <> Cell Value IS NOT NULL IS NULL 2. Executing a stored procedure by double-clicking its name Thank you Sign In·View Thread·PermaLink Re: Suggestion Elmue 12:14 21 Sep '08   Hello 1.) You can already enter SQL code to filter which rows appear in the table editor. OK, with your idea it would be easier in some cases. 2.) Executing a procedure is ultra easy by using the keyboard shortcuts. Currently I dont have the time to work on SQL Builder. But as you have the source code you can easily add that on your own. Elmü Sign In·View Thread·PermaLink 1.00/5 (1 vote) I have error. Mel Igo 16:01 2 Sep '08   Cross-thread operation not valid: Control 'frmWait' accessed from a thread other than the thread it was created on. frmWait.cs (ln 86) Sign In·View Thread·PermaLink Re: I have error. Elmue 19:14 15 Sep '08   Hello I suppose you did NOT compile on Visual Studio 2003, where this does not happen. I suppose that the guys of Microsoft changed the "Text" property of the label. I could write an "Invoke" workaround to solve this, but probably there are more problems arising afterwards. I don want to waste my time with that. As I wrote on VS 2003 all works fine and if you don't use VS 2003 you have to bear the consequences. Elmue Sign In·View Thread·PermaLink 1.00/5 (2 votes) Any one knows a MDX editor? ivanchain@hotmail.com 6:59 25 Jun '08   I am looking for it, but never found one. yours, Ivan 123 Sign In·View Thread·PermaLink UI txALI 21:59 23 Jun '08   There are some good ideas but generally the user interface need serious improvement. It is very hard to understand how to do simple task (e.g. how to connect to the server after entering server name - I found it but a simple Enter key is one of the necessary solutions). Sign In·View Thread·PermaLink Re: UI Elmue 10:54 25 Jun '08   Hello There is absoluely nothing to improve. The GUI is like it is with full intention. It is obvious that you are one of those who do not read. Thats your own fault. For anybody who has read the description above there is absolutely no problem to understand how to use the program. The advantages of this GUI will not become obvious if you just played around 5 seconds with the program. But if you work a while with the program in a team of developers you will understand why the Gui is as it is. My colleagues and me are very happy to use the tool daily because it saves a lot of work. Elmü Sign In·View Thread·PermaLink 1.00/5 (4 votes) Re: UI VEMS 11:11 23 Mar '09   "But if you work a while with the program in a team of developers you will understand why the Gui is as it is." Exactly why UI development teams need a usability team. Imagine end users needing to sit with development to learn how to use a product. Sign In·View Thread·PermaLink Re: UI Elmue 16:23 23 Mar '09   Hello The majority of programs was made to be controled with the mouse. The advantage is that the usage is intuitive. The disadvantage is that you are very slow with the mouse. This program has many keyboard shortcuts. The disadvantage is that you have to learn them first (which is quickly done) But the big advantage is that you modify an SQL statement quickly and execute it within less than a second. For that you have to invest some minutes to read the article and from that day on you will save a lot of minutes each time you use the program. > Imagine end users needing to sit with development to learn how to use a product. This is very exaggerated. Reading the article is enough. Have you ever worked with 3D Studio MAX ? Then you know what is complex software! Elmü Sign In·View Thread·PermaLink in my humble opinion [modified] Tolga Kurkcuoglu 3:41 19 Jun '08   I appreciate your talent, hard work and motivation. Keep up the good work. However, I should point out that your overall attitude and self-flattering remarks within the article cast a shadow on the work which should speak for itself. modified on Thursday, June 19, 2008 8:55 AM Sign In·View Thread·PermaLink 5.00/5 (5 votes) Re: in my humble opinion Elmue 9:58 19 Jun '08   Hello I have absolutely no problem to say if something is good or bad. For me it does not matter if it mine or from others. There are some very excellent articles and sourcecodes here on Codeproject and also some ugly ones. There are also some tools from Microsoft which are the opposite of user-friendly. What is the problem saying this clearly ? I have no problem with that. Elmü Sign In·View Thread·PermaLink 1.53/5 (8 votes) It does compile under Visual Studio 2005 yordan_georgiev 19:58 18 Jun '08   Great work!!! It does compile without errors ... Yet I need more time to play with it to be able to say if everything works as it should ... Sign In·View Thread·PermaLink 1.00/5 (1 vote) Good job torial 17:02 18 Jun '08   I went about writing a tool like this once, where it also replaced SQL Query Analyzer / Enterprise Manager. I had motivation as I had recently done an update query without a where clause on our employee table. My boss make me fix the data by hand to help me remember not to repeat that mistake. I ended up writing my tool just as a way to learn the metadata, but also to prevent inadvertent data deletion. It took a lot of work. And clearly yours took even more. I also like the overall flow of your article, lots of good screenshots, and very thorough discussion. I also like your website and the recommended software. Thanks for making that available. Sign In·View Thread·PermaLink Devils Advocate Ali Ozgur 4:13 18 Mar '08   Hi, I appreciate your work but your attitude which is to blame Microsoft's products does not sound realistic to me. Since Microsoft shipped .NET I believe that they really learned to deliver higher quality and easier to use products. A company, Microsoft, that succeeded to create a tool like Visual Studio 2003,2005 and 2008 can not be blamed for delivering ugly products. Ali Ozgur Software Developer Founder of www.pragmasql.com PragmaSQL for pragmatic developers Sign In·View Thread·PermaLink 3.67/5 (4 votes) Re: Devils Advocate Elmue 4:23 1 Apr '08   Hello You work at Microsoft? You love all their software? You are really strange. You are one of those guys who never have tried SqlBuilder and think that you have to put your opinion here without knowing what you talk about. If you love the Microsoft tools, use them! But I recommend you not to try SQLBuilder because you would have to change your opinion! Elmü Sign In·View Thread·PermaLink 1.00/5 (7 votes) Re: Devils Advocate Ali Ozgur 3:43 19 Jun '08   Man you are very agressive! I do not work at Microsoft. Yes I love some Microsoft software, to name some Windows XP, Visual Studio, SQL Server Management Studio. And I hate some Microsoft software, to name some Visual Source Safe, MediaPlayer, IE. I do not think I am strange, besides if you do not like MS software why you use C# and .NET, go and use Mono. In fact I tried your software and simply I did not like it because 1- I have my own, PragmaSQL 2- I did not like your attitude Ali Ozgur Software Developer Founder of PragmaSQL Editor for pragmatic developers Pragmatic Developer's Blog Sign In·View Thread·PermaLink 5.00/5 (4 votes) Re: Devils Advocate robert bouwens 22:10 18 Jun '08   oospla, I see the neccessity to get service packs Back in the time frame with win 2k rc1 I never got os crashes. With Vista I get'em for free. Vs2008 is a pain - once a while all windows are reshuffled after finishing a debug session. Cheers Robert Sign In·View Thread·PermaLink Re: Devils Advocate Ali Ozgur 3:51 19 Jun '08   I'm sure that Vista will get better in some time. And i want to confess that I use Windows Server 2003 at work and Windows XP at home. Reshuffle problem is not really a problem just remember that your development mode layout and debug mode layout are different. If you have Solution Explorer window in right hand side during development you can move it to left hand side during debugging and from that time on every time you debug your source code you will have Solution Explorer on the left hand side, after finisihing debugging you will sure have it on right hand side again. Ali Ozgur Software Developer Founder of PragmaSQL Editor for pragmatic developers Pragmatic Developer's Blog Sign In·View Thread·PermaLink Can't support when SQL include other Encoding character guaike 18:10 17 Feb '08   When my sql include some not UTF-8 encoding string, for example double byte character,the richTextBox display not right? Can you fix it? Sign In·View Thread·PermaLink Re: Can't support when SQL include other Encoding character Elmue 10:33 26 Feb '08   Hello I don't know what you are doing as you are too lazy to explain detailled what is your problem. SqlBuilder stores ALL files in Unicode. If SqlBuilder opens an already existing file it uses StreamReader(...,Encoding.Default) which means that it detects automatically the format of the file. Therefore .NET analyzes the first two bytes of the file which are different in UTF and Unicode files and which are missing in ANSII files. You don't need any other SQL editor which stores in UTF format. You can do ALL with SqlBuilder! > Can you fix it? There is nothing to fix. All works perfect. The most probable thing is that you saved the file wrongly. If the text is UTF encoded but the two bytes at the begin of the file are missing it is obvious that the file is interpreted as ANSII and special characters dont display correctly. Elmü Sign In·View Thread·PermaLink 1.00/5 (2 votes) SQL Express Gates VP 20:05 11 Feb '08   Wow, there's clearly a lot of functionality here, and a lot of work. I can see that you've attempted to replace the Query Analyzer / Enterprise Manager and in 2003 this was a very admirable goal. Anything deployed with MSDE was always a hassle without a good query tool and people were constantly making their own subsets of QA & EM to run the functionality they required. But you've posted this article on February 8, 2008. That's over 2 years after the release of SQL Server 2005 and SQL Express 2005. Microsoft now has SQL Server Management Studio Express Edition[^] available for free download and use. You get all of the required management features in a pared-down interface. So where does this leave your particular tool? It looks like you have CVS in mind, I'm not seeing some form of plugged-in integration, just the application of structuring standards. Can I make a VSS plug-in for your tool? Will it support direct integration? Does your app support Query Execution Estimation? What type of debug integration is available? Look my point here isn't that you've done bad work, in fact, quite to the contrary, it looks like you've done lots of good work. I just can't understand how this product fits in a world where SSMSEE exists and is available for free. Maybe you could help me out? Sign In·View Thread·PermaLink 5.00/5 (1 vote) Re: SQL Express Elmue 6:50 12 Feb '08   Hello It is obvious that you have quickly read the article but never worked with SqlBuilder. The SQL Server Management Studio Express Edition and Query Analyzer / Enterprise Manager are exactly the same ugly stuff for me. They are so awkward to use. Lets say you want to edit a stored procedure. You have to log in on the server entering the password each time, then you have to open the tree at the left side, clicking on the server, the database etc. Then you get a list of 1000 procedures (in my company there are 1253 procedures) and have to search the corresponding procedure from the long long list. You can edit the procedure but only one at a time. If you have to lookup for example a parameter name in a function you first have to close the procedure you are working on. This is more than ugly. I hated the Microsoft tools from the first day. If you once have got used to SqlBuilder you will not want to miss it anymore. The program not only stores your password (encrypted) it also stores which procedure you were working on the last time, even where the cursor was and what characters have been selected. In the list at the left you see only the procedures, functions you really are working on instead of 1253. After working on another procedure and coming back to the one you where working on before, you even have the complete undo buffer saved. With Ctrl Z you have your latest changes back. You never have to open any tree and you search the procedure only once from a long list. To execute a query you don't have to start another tool. Its all in one. There is a lot of funcionality which Microsoft does not offer, like export to Excel or comparing tables. The biggest advantage is that SqlBuilder automatically converts ugly written SQL code into readable code. And finally the Build Script function which gave SqlBuilder its name, which stores the work of you and your colleagues into one SQL file does not exist in the Microsoft tools. The biggest advantage is the you have the source code and can add any functionality you may need in the future. > It looks like you have CVS in mind, I'm not seeing some form of plugged-in integratio You absolutely didnt understand what I was writing about. Please read the article again and WORK with SqlBuilder! You will notice the advantages once you got used to it! Create a Temp folder in which you do your tests as I described above! Elmü Sign In·View Thread·PermaLink 2.45/5 (5 votes)

Last Visit: 18:20 9 Feb '10     Last Update: 18:20 9 Feb '10 12 Next »