On CBSNews.com: Can 365 Nights Of Sex Fix A Marriage?
3 Resources for

geeit and sql

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Change Case in SQL 2000
I have a set of tables in a SQL 2000 database. The information names and addresses has been entered in 'CAPITAL LETTERS' and I need to alter this to 'Sentence Case'. I can't just use upper and lower as the fields contain details that need capital letters at the start...
Tags: geeit, software, SQL, String
Q&A 2005-12-14
Updating Records in SQL database
I have a client who has a SQL derver database. They have reecently moved some data files to a new server. My problem is that within one of the SQL tables is a list of records that are pointing to files on the old server. E.g. w:msofficewordmynameclientfile.doc or...
Tags: database, geeit, SQL
Q&A 2005-11-29
SQL and MS Word
I have a client that wants to be able to create word documents and pull contact information (name/addresses/contact info) from a sql database. It's for thier admin staff and for multiple documents. Can anyone advise of the enst way to do this or let me know any utilities that can...
Tags: database, geeit, Microsoft Access, Microsoft Corp., Microsoft Word, SQL
Q&A 2005-10-10

Additional Resources

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...
Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management
White papers 2001-07-19
SQL PathFinder for Oracle (msi)
SQL Pathfinder is for Oracle SQL programmers who live in an environment where multiple versions of SQL scripts and multiple SQL execution environments exist. Pathfinder determines the SQL path that SQL Plus will use, and traces and displays all of the script dependencies for your SQL script. The dependencies are...
Tags: Oracle Corp., SQL, SQL PathFinder, Pathfinder, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2006-11-21
Cache Monitor (zip)
Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...
Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2007-05-11
What is the difference between Oracle, SQL and PL/SQL?
Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...
Tags: Oracle Corp., PL/SQL, SQL
Blog posts 2006-05-30
Some resources on SQL Server 2005
Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner
Blog posts 2005-11-11
Transferring SQL Server logins between servers or instances
I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...
Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren
Blog posts 2007-09-25
EMS SQL Manager 2008 for SQL Server (zip)
EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML...
Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development
Software downloads 2007-12-20
EMS SQL Manager 2008 Lite for SQL Server (zip)
EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...
Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
Software downloads 2007-12-20
BlackBall SQL Agent (exe)
The BlackBall SQL Agent fills the gap that Microsoft Express Edition 2005 left with its ommission of a SQL Server Agent. Use the BlackBall SQL Agent to automatically backup your SQL Server database at periodic intervals, or run other arbitrary SQL commands such as executing stored procedures.Also includes email notifications...
Tags: Microsoft SQL Server, SQL, BlackBall SQL Agent, E-mail, Databases, Enterprise Software, Programming Languages, Online Communications, Software, Data Management, Software Development, Software/Web Development
Software downloads 2007-06-29
How do I run code automatically when SQL Server starts?
The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. Today, consultant Tim Chapman gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on...
Tags: Stored Procedure, Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, John Sheesley
Blog posts 2008-11-10
Towards an Industrial Strength SQL/XML Infrastructure
XML has become an attractive data processing model for applications. SQL/XML is a SQL standard that integrates XML with SQL. It introduces the XML datatype as a native SQL datatype and defines XML generation functions in the SQL/XML 2003 standard. The goal for the next version of SQL/XML is integrating...
Tags: SQL, XML, Programming Languages, Databases, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management
White papers 2004-07-21
Fast Track DBA
I am looking for a "Boot Camp" for SQL DBA. I have some knowledge of it but I am trying to gain more experience and it helps that my company is going to pay for it. I am looking for something that is a 2 day Session ...any IdeasSQL ServerI...
Tags: Programming languages, Databases, jabney@..., SQL, server
Discussion threads 2005-06-14
SQL Tools Make Fast Work
The purpose of any interactive SQL tool is to let the user enter SQL statements and get results back. The term SQL statements includes PL/SQL blocks and now, in Oracle Database 10g Release 2, XML queries. SQL*Plus has long been the tool of choice for executing ad hoc SQL statements,...
Tags: Oracle Corp., SQL, Tool, SQL*Plus, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
White papers 2006-01-01
How do I... Configure transactional replication between two SQL Server 2005 systems?
Replication between sql 2000 and sql 2005This article was good for basic knowledge. Is it possible to use sql 2005 as a distributor and sql 2000 as a publisher. Subscriber could be any.ORsql 2000 as publisher and distributor but subscribers as sql 2005.Please point me if there is any reference...
Tags: Programming languages, Databases, Microsoft SQL Server 2005, alalani@..., Microsoft SQL Server, SQL
Discussion threads 2007-09-12
Apex SQL Report (exe)
Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a Web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports. New Apex SQL Report includes fusion charts, multi column sorting, grouping & filtering using Janus...
Tags: SQL, Apex SQL Tools, Apex SQL Report, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2007-01-30
Teratrax Performance Monitor (msi)
Monitor SQL Server performance on all enterprise servers from a single interface. Analyze and chart real-time and historical execution of SQL code across users and applications. Isolate SQL Server hardware utilization and correlate it with SQL statements and SPs. Be the first to know about slow and failed SQL Server...
Tags: Microsoft SQL Server, SQL, Databases, Enterprise Software, Software, Data Management
Software downloads 2006-06-16
General SQL Parser .NET version (zip)
General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete...
Tags: Microsoft .NET, Statement, SQL, General SQL Parser, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2006-12-07
  • << Previous
  • page 1 of 1
  • Next >>


Disaster Prevention and Recovery in Windows Server 2003
The Windows Server 2003 Volume Shadow Copy Service offers even small IT shops a unique opportunity to back up just like the big guys. Our Windows Serv ...
Buy Now
TPG Power Checklist: Troubleshooting TCP/IP
TCP/IP, the protocol powering Internet, Intranet and Extranet communications, provides critical functionality withinmost every organization. Numerous ...
Buy Now