sql statements
Fashion Statements 1
Create and print your own fashion design for any apparel or as posters. more>>
Fashion Statements 1 is a helpful program to bring high quality fashion design and political/artistic apparel. All fashion statements come in three colors and can be printed for transfer to t-shirts, coats, and other apparel.
Fashion Statements can also be used as posters or wall hangings. Make a fashion statement with Fashion Statements.
The latest in quality political/artistic fashion statements for T ... All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coats
Fashion Statements for Men 1
Fashion Statements for Men is designed to deliver the latest in high quality fashion and political/artistic apparel more>>
Fashion Statements for Men 1 is a program for the distribution of the latest in high quality fashion and political/artistic apparel. All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coats and other apparel. Fashion Statements for Men can also be used as posters or wall hangings. Make a fashion statement with Fashion Statements for Men.
Fashion Statements for Men is designed to deliver the latest in high ... All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coatsLicense:Freeware
Fashion Statements for Women 1
Fashion Statements for Women is designed to deliver the latest in high quality fashion and political/artistic apparel more>>
Fashion Statements for Women 1 is a program for the distribution of the latest in high quality fashion and political/artistic apparel. All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coats and other apparel. Fashion Statements for Women can also be used as posters or wall hangings. Make a fashion statement with Fashion Statements for Women.
Fashion Statements for Women is designed to deliver the latest in ... All Fashion Statements come in three colors and can be printed for transfer to T-shirts, coatsLicense:Freeware
SQL Load Test 1.0
Generates a Visual Studio 2005 Unit Test from a SQL Server Profiler trace more>> Generates a Visual Studio 2005 Unit Test from a SQL Server Profiler trace
The SQL Load Test was designed to generate a Visual Studio 2005 Unit Test from a SQL Server Profiler trace. The tool extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test.
The tool does not interact with the database itself when it generates the test code and so it can be used "offline".
The generated code needs to be customised to include a connection string to the database under test. The generated code also includes hooks to allow the user to customise the parameters that are passed to the SQL statements and stored procedures, so that variability can be introduced into the data to prevent caching from giving artificially high performance figures.
The tool is intended to be used in conjunction with a client program that exercises the database. A trace of the clients SQL Server activity is captured using the SQL Server Profiler. This represents a test scenario, which is then processed by the tool to produce a Unit Test that replays the scenario.
The tool requires a trace to be collected using the SQL Server Profiler tool. The tool assumes that the trace only contains records pertaining to a single client session. So it is important to ensure that the trace is set up to only collect trace records generated by the activity of the client being used to generate the scenario.
It is therefore advisable to run the client on a machine from which no other activity on the SQL Server database is being generated, and to set the SQL Server Profiler filter accordingly.
System requirements:
- SQL Server 2005 SDK and the SQL Server 2005 Management Tools are installed.
Version restrictions:
- Only supports code that operates against a single database with a single connection.
- Prepared statements are not supported.
- The tool cannot (yet) configure and capture the trace for you, it requires you to use the SQL Profiler yourself to get a trace. With SQL 2005 it is possible to automate this.
- Not (yet) integrated into Visual Studio or the DB Pro edition.
- The tool has only been tested in an English environment, it is unlikely to work correctly in other environments, particularly with dates. In a future version this could be resolved by requiring the ExistingConnection event class, which lists language and date format.
- The tool does not support the XML data types.
- InputOutput parameters that are initialised with a NULL cannot be distinguished from Output-only parameters, so they are treated as Output only.
- When the trace passes a NULL to a binary parameter (e.g. image, binary, varbinary) the generated code will generate a runtime error. The generated code needs to be modified to pass SqlBinary.Null. The custom code generation extensibility point can be used to work around this.
- Positional parameters passed to SQL statements (as opposed to stored procedure calls) are not supported.
SQLtree 2.1
Organize and execute your SQL statements in a tree structure. Double-clicking on the tree items runs the underlying SQL command. Additionally the program provides some extensions to the SQL language t more>>
SQL Batch Executor 1.0.46
SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver. more>>
A few years ago, I created a very simple version of this application in order to do my job more effectively. Because I usually generate most of my SQL statements, I had many problems running a series of statements in MS Access. From that application I realized; many other programmers, DBAs, and power users, may have the same problem. And probably in other database formats.
This application is meant to bridge the efficiency gap with all available ADO / ODBC connectable databases and provide a consistent interface for their manipulation.
Version restrictions:
- Only registered users can save scripts
SQL Dumper 2.1.3
SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, more>>
SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file.
This program implements the following special features:
* Foreign Keys -> order tables in text file in order to insert data without colisions/errors
* Primary Key IDENTITY -> guarantees the value of the IDENTITY field
* Reference to itself -> eliminates the constraint and at the end create it again
Try this On NorthWind database that cames with SQL Server by default.
A Command Line version has been added.
Whats new in this version: 2008.01.26
<<lessto dump selected SQL Server database tables into SQL INSERT statements, that are saved as local ... sql files and contain all the data required to create a duplicate table, or to be used for backup
to dump selected SQL Server database tables into SQL Insert statements, that are saved as local ... to dump selected SQL Server database tables into SQL Insert statements, that are saved as localSQL Search 1.1
Search through application PBL files for any embedded SQL statements more>> Search through application PBL files for any embedded SQL statements
The SQL Search application was designed to be a freeware utility written in PowerBuilder that will search through application PBL files for any embedded SQL statements and display them in a window from which the list can be printed or saved.
It gets the list of applications from the registry and the list of PBLs from the PB.INI file. It allows the user to select which SQL verbs to search for and also allows the user to clean up old application entries in the registry.
Enhancements:
- Fixed a couple of bugs which limited the search effectiveness. Search now takes proper account of sub-selects.
SQL Script Generator 0.1.3123
Generate INSERT/UPDATE statement SQL script more>> Generate INSERT/UPDATE statement SQL script
The SQL Script Generator application was designed to be a tool to generate INSERT/UPDATE statement SQL script. With SQL Script Generator you can create script to copy data from one database to another.
Main features:
- Generate only INSERT and UPDATE statements;
- Run in transaction;
- Disable check constraints;
- Save in one file;
- Connect with Windows Authentication and Sql Server Authentication;
- Select tables;
System requirements:
- SQL Database connection
SQL Studio Query eXecutor 1.1.609.9686
SQL Studio Query eXecutor (QX) is a simple query and SQL script execution utility for Microsoft SQL Server more>>
There has been always a need for it when working with MSDE and SQL Server Express Edition or remote databases. It is not a replacement for the powerful Query Analyzer or the tools provided with Microsoft SQL Server, but rather an alternative for users that do not have those tools or do not want to install them.
Features color syntax highlighting, whole script or selected statements execution, executing of SQL scripts or stored procedures, and multiple result tables. Convenient functions to save SQL code to file and open existing script files. Provides execution results, table format output, and XML output.
SQL Studio QX has an advanced database server detection process to list all available servers. Supported are all editions of Microsoft SQL Server 2000 and 2005, including MSDE and SQL Server 2005 Express. It executes queries to remote servers.
Supported Databases:
- Microsoft SQL Server 2005 (all editions)
- Microsoft SQL Server 2005 Express
- Microsoft SQL Server 2000 (all editions)
- Microsoft MSDE 2000
- Remote Microsoft SQL Server instances
Main features:
- Write and execute queries and stored procedures
- Save SQL scripts for future use
- Open saved scripts and execute
- Multiple result tables
- XML output
- Color coding for SQL language syntax
a useful query and SQL script execution utility which is designed for Microsoft SQL Server. SQL ... , whole script or selected statements execution, executing of SQL scripts or storedLicense:none available
, whole script or selected statements execution, and ex. SQL Studio Query eXecutor 1.1 - Tangra ... , whole script or selected statements execution, executing of SQL scripts or storedLicense:Freeware
KNOCKS SQL-Sense Beta
KNOCKS SQL-Sense provides Intellisense style help while writing SQL Statements in Microsoft Query Analyzer, SQL Server, etc more>>
It simply sits behind the scenes and provides unobtrusive help when you press Ctrl-Space or when you type "." after a table/view/alias name.
Main features:
- Table/ Table Column/ View/ Function/ Stored Procedure/ Database name completion.
- Popup Suggestion after keywords like SELECT, USE, WHERE, FROM, EXEC, AND, OR etc.
- Insertion of commonly used (user defined) snippets.
- Ability to cache Connection Strings locally.
- Allows manual resize to user-requirement.
- Extremely light-weight, low memory consumption.
System requirements:
- 256MB RAM
- .NET Framework 2.0
Easy SQL Scripter 3.6
This application scripts the database data and schema. You can select the schema tables and objects to include in the script more>> This application scripts the database data and schema. You can select the schema tables and objects to include in the script
Easy SQL Scripter will script the database data and schema. You can select the schema tables and objects with data to be included into the script.
Note: Use the next serial number for free:DEPLOY-0BE4X-GLPNZ-OCEHW-4I29B
Main features:
- Script database schema and data as Transact SQL statements
- Preview each object script before generation
- Wildcard objects filter
- Data row filter
- Detect object dependencies and ensure correct creation order
- SQL viewer with syntax highlighting and regions
- User-friendly wizard to guide you through the process
- Full support SQL 2005 objects
- SQL Management Studio 2005 plug-in
System requirements:
- .NET Framework 2.0
- MS SQL Server 2005, MS SQL Server 2000, MS SQL Express or MSDE
- 512 MB RAM
- 10 MB Hard disk space
Main features: - Script database schema and data as Transact SQL statements - Preview each object script before generation - Wildcard objects filter - Data row filter - Detect object dependencies
SQL Packager 1.4
SQL Packager is designed as a useful software which allows you to quickly package/unpackaged a SQL statement to/from VB code. more>>
SQL Packager 1.4 is designed as a useful software which allows you to quickly package/unpackaged a SQL statement to/from VB code. The packaged code can be directly pasted into VB and unpackaged code can be directly pasted into a SQL tool such as Enterprise Manager for analysis and design. There is no installer, simply download and create shortcuts to SQL Packager where you need (such as the Quick launch bar).
Enhancements: Fixes the window resizing issue where large window titles would force the second box off the bottom.
Requirements:
- Windows 95/98/Me/NT/2000/XP/2003 Server,
- Visual Basic 5/ Visual Basic.NET W
SQL Server Compare 2.2
SQL Server Compare is an easy-to-use tool to compare 2 SQL Server database schemas more>>
SQL Server Compare does not change the database in any way, and it can not execute any SQL statements - it only compares the schema. Requires SQL server or client installed.
SQL Server Dumper 3.0.2
SQL Server Dumper enables you to dump/export selected SQL Server database tables into SQL statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. more>>
SQL Server Dumper enables you to dump/export selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file.
This program implements several features and have multiple dumping/export options that allows you to have more control.
System Requirements: .NET Framework 2.0
<<less