On CHOW: Eat well for LESS MONEY
1 Resources for

sql scripting

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

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

Additional Resources

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
SQL Ser2005-ActiveX Script -DTS_E_AXTASKUTIL_SCRIPTHOST_CREATE_FAILED.
Hi, I get the following error when trying to add a VB script. I'm rewriting from SQL 2000 to 2005. but i get the following error when trying to parseActiveX Script TaskAn error occurred while creating the ActiveX scripting host. Verify that the scripting host is installed properly.I've checked on...
Tags: ActiveX/COM/COM+/DCOM, Programming languages, ismailc@..., SQL
Discussion threads 2007-07-30
SQL Companion (zip)
SQL Companion is designed and developed to ease your everyday SQL development. This is the very first release of the tool. In order for the installation and the application to work you have to have MS SQL Client tools installed on your system. Currently only Microsoft SQL Server is supported....
Tags: Procedure, Microsoft SQL Server, Server, SQL, SQL Companion, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
Software downloads 2005-11-29
Apex SQL Script (exe)
Apex SQL Script converts databases to scripts, .net exe's and deployment packages. Apex SQL Script creates insert scripts from any Microsoft SQL Server database that can be archived, Emailed, checked into source control, run against another database. Apex SQL Script handles Identity fields and Apex SQL Script can auto-sequence the...
Tags: SQL, Apex SQL Script, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
Software downloads 2007-01-30
Virtual Server Scripting
The presenter of this webcast will talk about scripting Virtual Server 2003 R2. He will discuss the benefits of scripting, scenarios that will utilize scripting, and requirements for scripting in Windows. Also the presenter will cover different scripting tools that can be used. He will go into detail on different...
Tags: Microsoft Virtual Server, Virtual Server, Microsoft Corp., Server Virtualization, Virtualization, Servers, Hardware
Webcasts
Apex SQL Code (exe)
Apex SQL Code is a Rapid Application Development RAD Code Generation tool for Microsoft SQL Server that enables you to automatically generate thousands of lines of perfect ASP, VB, C#, SQL and more code in just seconds using familiar ASP.NET syntax. The key feature of Apex SQL Code tool is...
Tags: SQL, Tool, Apex SQL Code, C#, Programming Languages, .Net, Productivity, Microsoft Development Tools, Databases, Software Development, Software/Web Development, Development Tools, Enterprise Software, Software, Data Management
Software downloads 2007-01-30
TechNet Webcast: Virtual Server Scripting (Level 200)
The presenter of this webcast explains scripting in Microsoft Virtual Server 2003 R2. He discusses the benefits of and requirements for scripting in Windows, and illustrates typical scripting scenarios. The viewer of this webcast will learn about the various scripting tools and the different scripts used in a virtual environment,...
Tags: Microsoft Virtual Server, Webcast, Virtual Server, Microsoft Operations Manager, Microsoft Corp., Microsoft TechNet, Server Virtualization, Virtualization, Digital Media, Productivity, Servers, Hardware, Consumer Electronics, Personal Technology
Webcasts
Accessing SQL Server 2005 Databases With PHP
PHP:Hypertext Preprocessor PHP is a scripting language that is suited for developing Web applications. A PHP script can be embedded in an HTML page and run as a .php script or as a Windows Script Host script (.wsf file). PHP 5.1.6 is the latest version of PHP and includes extensions...
Tags: Microsoft SQL Server, PHP, Microsoft SQL Server 2005, PHP 5.1.6, Scripting Languages, Databases, Enterprise Software, Software/Web Development, Web Development, Software, Data Management
White papers 2006-09-01
can any one help me how to write & implement scripting...
Hi frnds,I'm a beginner..can any one help me how to implement scripting at domain level.Would be gald if any one can provide me some document which can helps me to get knowledge on scripting.
Tags: vinod.tammana@...
Discussion threads 2007-05-31
TechNet Webcast: Next Generation Command Line Scripting With Monad (Part 1 of 2) (Level 300)
What is the next generation Microsoft command-line shell automation and scripting technology (codenamed "Monad") and how does it fit into the realm of tools and languages? This webcast highlights how the architecture of the shell supports consistent, production-oriented commands. In the webcast, you will learn about the power to navigate...
Tags: Webcast, Microsoft Corp., Microsoft TechNet, Microsoft Windows Active Directory, Digital Media, Directory Services, Enterprise Software, Software, Consumer Electronics, Personal Technology
Webcasts
MSDN Webcast: Writing Secure Code (Part 2 of 3): Threat Defense (Level 200)
Does user input help you to build your SQL statements? If so, you may be a victim of SQL injection. This webcast explains best practices for applying security principles throughout the development process. The webcast discusses learn effective strategies for defending common security threats such as buffer overruns, cross-site scripting,...
Tags: Microsoft Developer Network, Webcast, SQL, SQL Injection, Programming Languages, Digital Media, Databases, Security, Software Development, Software/Web Development, Consumer Electronics, Personal Technology, Enterprise Software, Software, Data Management
Webcasts
Scripting Exchange Using VBScript and ADSI (Part 1)
Scripting can be a powerful tool. There are a lot well written scripts for use with Exchange floating around the Internet that can be quite useful. Changing to fit person's needs is not too difficult, but writing his own scripts and making scripts work better for his needs requires some...
Tags: ADSI, Microsoft VBScript, Script, TechGenix, Microsoft Windows Active Directory, Directory Services, Scripting Languages, Internet, Enterprise Software, Software, Software/Web Development, Web Development
White papers 2005-06-21
Scripting Course recommendations?
Can anyone recommend a good beginner course to somone who knows nothing about scripting? I'm thinking MOC course 2433 - Microsoft Visual Basic Scripting Edition & Microsoft Windows Script Host Essentials, but would like a second opinion.Thanks in advance!
Tags: Microsoft development tools, Programming languages
Discussion threads 2005-07-22
How to Start (Programming) Where do You Begin?
Scripting is a whole set of languages, and can be done for many different things. Scripting can also be one of the easiest types of programming. It is also a quick way to get productive doing some basic programming. (I believe that people get the most out of something when...
Tags: Programming, Development Tools, Software Development, Software/Web Development
White papers
System Administration Scripting in the Microsoft Windows Environment
A powerful scripting environment is an indispensable tool in the fight to reduce Total Cost of Ownership TCO by automating system and network administration tasks. Windows Script Host WSH, when used in conjunction with ADSI and the WMI scripting library, provides just such a scripting environment. In this webcast, the...
Tags: Environment, TCO, Microsoft Corp., System Administration, Scripting Environment, Roi/Tco, Microsoft Windows, Network Administration, Microsoft Windows Active Directory, Networking, Finance, Managerial Accounting, Operating Systems, Software, Directory Services, Enterprise Software
Webcasts
TechNet Webcast: Things the Scripting Guys Never Told You (Level 200)
In this webcast, the Microsoft Scripting Guys will fill the attendee in on useful scripting techniques, everything from using the Dictionary object to sending e-mail from within a script.
Tags: Webcast, Microsoft Corp., Microsoft TechNet, Digital Media, Productivity, Consumer Electronics, Personal Technology
Webcasts
Making Scripting Languages JSR-223-Aware
The new Java Scripting API integrates scripting languages into the Java environment. JSR-223-aware applications can execute scripts and, if the scripting language supports this feature, exchange data objects with them. This paper explains how to query available languages and how to communicate with them. But what does it take to...
Tags: Author, Scripting Language, Java Scripting API, Scripting Languages, Software/Web Development, Web Development
White papers 2006-09-21
GO Script (exe)
The key features of GO Script are: Dynamic and Collaborative Snippet system for easy and fast scripting; Save your code as snippets easily to avoid repetitive coding using GO Script Snippet Editor; Supports 9 different scripting languages; Scripting Languages include Batch(MSDOS/NT/Shell scripting), Javascript, html, php, and ini to mention a...
Tags: Scripting Language, Scripting Languages, Software/Web Development, Web Development
Software downloads 2007-08-27
Scripting for Windows admins, what should I use?
Well as it says... Im trying to automate a few processes and im not big on scripting. anyone know of any tools or sites that could help?www.w3schools.comThat one helped a non-scripter like me.Kix32Try www.kixtart.orgThis is a VERY good scripting language and isn't that hard to learn.I've used it...
Tags: Instant messaging, eclopton@..., Microsoft Windows
Discussion threads 2007-06-13
  • << Previous
  • page 1 of 1
  • Next >>


TechRepublic Power Checklist: Troubleshooting Windows Backup
Windows' native Backup program, while devoid of fancy frills such as intricate compression algorithms, offers a proven method for protecting data. Her ...
Buy Now
TechRepublic's Peer To Peer Policy
Peer-to-peer networks--such as BearShare, Kazaa, LimeWire, Morpheus, and others--present numerous significant security threats to organizations. Permi ...
Buy Now

Cracking Open