sql query

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

sql query in Visual Basic

writing sql query in vb script

Tags: Programming languages, Databases, mahavir2610@..., sql query, SQL, Microsoft Visual Basic

Discussion threads 2007-10-05

Visual basic sql crystal report

how can i connect sql server 2000 through visual basic 6.0 for crystal reporthow do youconnect crystal reports to sql server 2000a file connection, e.g. odbcwrite your reportembed in VBYou can call report with paramssome ERP systems let you then place the vb prog calling the xtal report on the...

Tags: Programming languages, Enterprise resource planning (ERP), Databases, Enterprise software, ppsswwoorrddhheemmaall@..., SQL, Microsoft Visual Basic

Discussion threads 2007-04-01

Working with nested subqueries in SQL Server

Example: Bad! Subqueries: WORSE!Firstly, the example given here is an extremely poor one because Using IN creates a temp table for every item in the IN list. If each of these subqueries only returns 10 records, this query will create 1000 temp tables. Very inefficient. SQL is not designed to...

Tags: subquery, Jeff_D_Programmer, sql scripting, software, programming, queries, sql, sql query, query, join, Microsoft SQL Server, server

Discussion threads 2007-01-30

Sql Query

i have one complecated sql quert please help me in that the situation is like this i have one table likebilltable nameid,date,status in that status is always 1 or 0 and other table likebilldetailtable nameid,bill_idfk of first table,itm_idfk of third table,amountother table is itmtable nameid,namenow i want to create one...

Tags: akshar108@..., SQL, TO_DATE

Discussion threads 2007-01-25

DOWNLOAD: Follow the evolution of an SQL query and automate your database r

http://techrepublic.com.com/5138-9592-5783491.htmlThe stored procedure outlined in the download is fairly detailed. [b]Do you have a better approach or possibly a way to improve the overall performance of the query?[/b]

Tags: database, databases, download, Mark W. Kaelin, software, sql query, sql server

Discussion threads 2005-07-11

Copying Database schema

How can we copy database table along with eniter schema from oracle to a non removale disk such that we can directly use it in another system not in a networkby simply copying table in to oracle database of that system?db dump, with full inserts.add create statements options also.then you...

Tags: Databases, database

Q&A 2005-03-15

Additional Resources

SQL Inspect (zip)

SQL Inspect is a SQL editor for SQL Server, created with the aim of allowing users to quickly analyze a sub-optimal query, the tables and indexes used by that query, and record all results of rewriting the query. It offers the following features over standard SQL editor tools: Get an...

Tags: Query, SQL, Yohz Ventures Sdn Bhd, SQL Inspect, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2008-04-10

Export Query to SQL for SQL server Professional (exe)

Export Query to SQL for Microsoft SQL Server will help you save results of a query execution as a set of INSERT SQL statements. Predefined or custom separators like 'go', two identity support modes and a few options make this tool flexible. The program has easy to learn and to...

Tags: Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2008-01-14

Export Query to SQL for SQL Server (exe)

Export Query to SQL for Microsoft SQL Server helps to save results of a query execution as a set of insert SQL statements. Predefined or custom separators like go, two identity support modes and a few options make this tool flexible. The program has easy to learn and to use...

Tags: Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2008-01-10

Achieve better SQL Server performance with Profiler and Query Analyzer

The overall performance of Microsoft's SQL Server can only be as good as the queries that are sent to it. The automated query optimizer does the best it can to make the queries as efficient as possible but it too has limitations. In this download, you'll learn how to use...

Tags: Performance, Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management

Download resources 2005-04-07

EMS SQL Query 2007 for SQL Server (zip)

EMS SQL Query 2007 for SQL Server is a utility that lets you quickly and simply build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for...

Tags: Graphical Interface, Query, Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware

Software downloads 2007-06-13

SQL Visualizer (zip)

SQL Visualizer is a Windows client-based SQL Server database query and management tool designed to make SQL development simpler and more productive. SQL Visualizer provides a host of improvements over tools such as Query Analyzer, features that will quickly make it your SQL Server query tool of choice. Featured include...

Tags: Microsoft SQL Server, SQL, SQL Visualizer, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-01-10

Miccrosoft SQL Server 2005

On like SQL server 2000 where you can find Query Analysa to run your Query, i can find that in 2005, is there any place i can steal find it or is being replace by another function.Please who ever that knows about this should let me know.Two OptionsInstall the SQL...

Tags: Databases, Enterprise software, Microsoft SQL Server 2005, onagonline2004@..., Microsoft SQL Server

Discussion threads 2007-04-20

Advanced SQL To XML Query (msi)

Advanced SQL To XML Query is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server databases. Resultsets returned by select statements are automatically converted to XML files and persisted to a directory of your choice. XML files generated by Advanced SQL...

Tags: SQL, XML Query, XML, Programming Languages, Databases, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management

Software downloads 2007-12-20

SQL Query Tool (Using ADO) (msi)

SQL Query Tool using ADO is a Universal Data Access UDA tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve provider properties, and execute multiple SQL scripts or stored procedures simultaneously. A separate ODBC version...

Tags: ODBC, SQL, Tool, ODBC Version, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-11-26

SQL Query Tool (ODBC) (msi)

SQL Query Tool using ODBC is a Universal Data Access UDA tool. It lets you query ODBC data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously. A separate ADO version is...

Tags: ODBC, SQL, Tool, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-11-26

Visual SQL-Designer (EXE)

Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and write it. Visual SQL-Designer supports ORACLE 7.2-8.x-9.x; MS-SQL server 6.5-7.0-2000; SyBase System 10-11; Db2 for NT; MSAccess 97-2002; MySQL; Teradata; ODBC datasources. It allows to update opened result sets, delete query builder, union query builder,...

Tags: Oracle Corp., Sybase Inc., Builder, Visual SQL-Designer, Databases, Enterprise Software, Software, Data Management

Software downloads 2005-01-18

FlySpeed SQL Query (zip)

FlySpeed SQL Query is an easy-to-learn-and-operate graphical tool for all database users and developers. It allows you to build queries on different database servers without needing deep knowledge of SQL syntax and performs a wide range of data manipulations. Handy for professionals and essential to newbies, FlySpeed SQL Query includes...

Tags: FlySpeed SQL Query, Storage, Databases, Hardware, Enterprise Software, Software, Data Management

Software downloads 2007-10-31

Microsoft T-SQL Performance Tuning Part 4: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server Using SHOWPLAN Output and Analysis

This paper will teach you the basic techniques used to tune SELECT statements on Micosoft's SQL Server 2000 relational database management system. The paper will also teach you the techniques available using Microsoft's graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer, as well as...

Tags: Microsoft SQL Server Transact-SQL, Performance, Microsoft SQL Server, Server, Microsoft Corp., Analysis, Quest Software Inc., Productivity, Databases, Performance Management, Enterprise Software, Software, Data Management, Human Resources, Workforce Management

White papers 2005-01-01

Specify data types in Access parameter queries

What if the query is too complex for the design view ?This article is fine for those who use the query design view. But, in the world of real applicstions, some SQL queries are reported by the design view wizard as being "... too complex ... ". In such cases,...

Tags: access, datatype, hardware, kaspencer, Microsoft Access, parameters, queries, SQL, SQL View

Discussion threads 2005-05-25