View Database Info without knowing anything about SQL with the Microsoft Sql Tool

YAHsGeneral

Active Member
Joined
Oct 22, 2011
Messages
78
Reaction score
0
Hi, I'm selling a useful program I've built:

Item name: MSSQL Tool
Do you want to view data on a Microsoft Database but you don't know Sql? This tool is ideal for someone working on a MS SQL Database that needs to do a lot of queries to view data. Call Centers can use this tool to look at back end data without knowing SQL. Quality Assurance Testers can use this tool to add another dimension on their testing. I use it myself to do support in my daily job. I've helped our call centre to use this tool and it's really for dummies, or for those that know sql but still has to type out repetative sql to debug programming behaviour etc. - It's really fast and easy to use.

There's a host of functions on this tool that makes life easier. As a bonus, for those that know nothing about MS SQL but want to use this tool, I'll give you free training. You will see how easy it is to use. And as you go along, you will start to learn SQL without trying. So contact me to get free MS SQL training for beginners with your Purchase of the MSSQL Tool.

Age and condition: n/a
Do you include packaging: n/a
Warranty: n/a
Reason for selling: n/a
Price: R1000
Negotiable: Yes
Location: Pretoria
Shipping or collection: Download
 
What proof do we have that this is something that you built?
 
Ok, well since I wrote it you can ask me anything about it and I'll answer you truthfully...Alternatively, if that doesn't appeal to you I'm sure I can prove it in another way...
 
No. It's a standalone app that queries the database on your behalf without actually having to know MS SQL. You can write your own sql and also run it, but what it's best at is generating sql statements for you and throwing the output on the screen for you - with a host of nifty functions to further explore the data.
 
Through the interface. Let me give you a practical example. Say you want to view the customers table, you type in "customer" on top, or scroll down and select the "Customers" table. On selecting it, it'll show you the fields on that table. Say you want a specific customer, you scroll down to the "Name" field and paste the name you are looking for. You can paste multiple values. Say you are looking for a Mr Burt Reynolds. You will paste "Burt" in the name field and "Reynolds" in the lastname field and enter. It will generate the sql for you. Alternatively if you just want a snapshot of the Customers Table, you don't have to paste any values. You press Esc and it'll show you a 100 records ordered by the primary desc. This applies for any table. So you can always quickly view the data on any table with a few clicks or a few quick shortcut keys...
 
...the snapshot will give you the latest records - a batch of 100 on that table if that makes sense...
 
Through the interface. Let me give you a practical example. Say you want to view the customers table, you type in "customer" on top, or scroll down and select the "Customers" table. On selecting it, it'll show you the fields on that table. Say you want a specific customer, you scroll down to the "Name" field and paste the name you are looking for. You can paste multiple values. Say you are looking for a Mr Burt Reynolds. You will paste "Burt" in the name field and "Reynolds" in the lastname field and enter. It will generate the sql for you. Alternatively if you just want a snapshot of the Customers Table, you don't have to paste any values. You press Esc and it'll show you a 100 records ordered by the primary desc. This applies for any table. So you can always quickly view the data on any table with a few clicks or a few quick shortcut keys...

Sounds familiar but I'm forgetting the name.

Question. Perk of this over excel pointing to a view with all the columns. Filter via Excel.
 
If you are viewing the customers table already and want to see the customer Addresses, you can right click on the foreign key and jump to that table without having to write the code to view the customer addresses. If you want to view data on several tables at the same time, you can write the join for that and run it and it'll throw out the results for you. But to do quick lookups and jump from one table to the other, that is fast and handy. I'll add the function to join tables in a nice and intuitive manner later on.
 
Sure I can put a few screenshots together.... I'm just at work, so I'll do it as soon as I have time
 
If you are viewing the customers table already and want to see the customer Addresses, you can right click on the foreign key and jump to that table without having to write the code to view the customer addresses. If you want to view data on several tables at the same time, you can write the join for that and run it and it'll throw out the results for you. But to do quick lookups and jump from one table to the other, that is fast and handy. I'll add the function to join tables in a nice and intuitive manner later on.

That's all well and good - but this presupposes that the users are aware of relational database theory.

And if they are aware of that then chances are they can write basic SQL statements and an SSMS installation will be the better tool for the job...
 
Top
Sign up to the MyBroadband newsletter
X