sql procedure

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database

The SQL procedure has been used for years as the way many SAS clients and solutions query for their data. Examine the new SQL performance optimizations that have been added to this bellwether procedure, optimizations designed to greatly expand query pass-through capability to databases and shorten the SAS client and...

Tags: Database, Microsoft Access, Performance, Optimization, SAS Institute, SQL, SQL Procedure

White papers 2008-02-27

Additional Resources

HOW REDUCE EXECUTION TIME OF STROE PROCEDURE

HOW CAN I REDUCE THE EXECUTION TIME OF STORE PROCEDUREOptimise the SQL inside itAll a stored procedure is, is a pre-parsed query with some add-ons. How much performance improvement you get from it being an SP depends on how much SQL to parse and whether the server keeps it cached...

Tags: Programming languages, pravin.mankape1@...

Discussion threads 2007-07-19

run SQL stored procedure from Excel

I have a stored procedure in SQL2005 that builds7refreshes a table. I cannot use SQL Views due to highly complex programming that is needed. I have an excel pivot table that uses that table afterwards. I would like the user to be able to refresh the data in the pivot,...

Tags: Programming languages, Microsoft Excel, highlander718, SQL

Discussion threads 2007-08-09

Tweak SQL Server options to gain functionality

xp_cmdshell has been available since at least SQL Server 7.0SQL Server has offered xp_cmdshell since SQL Server 7.0 (when I started using it - it could have existed before that) and is not new to SQL 2005. I thought I would clarify that, since this post says it is new...

Tags: Databases, Chris.Conner@..., xp_cmdshell, Microsoft SQL Server, server

Discussion threads 2007-06-19

Calculating Statistics Using PROC MEANS Versus PROC SQL

PROC SQL is a widely used language for retrieving and updating data in tables/views. Mainly it is used to retrieve data from RDBMS, calculate the descriptive statistics or summarize the data. The MEANS procedure provides data summarization tools to compute descriptive statistics for variables across all observations and within groups...

Tags: Statistics, SAS Institute, PROC SQL, MEANS Procedure, Databases, Enterprise Software, Software, Data Management

White papers 2007-05-14

Stored Procedure & Views

I Want to create a stored procedure on MS VISUAL STUDIO.Then later use the stored procedure to develop a report using Crystal Report XI. How can this be Achieve this ?Bit confused hereYou mean you want to write some code to create the stored procedure in a database...

Tags: Databases, tmmokoena@..., stored procedure

Discussion threads 2007-07-27

I don't have that popup

Hi SirI gone thru U'r artical on debugging sql server storedprocedureI tried to dedbug a procedurewhen I right click on a procedure I didn't find any debug option Can U help me how can I debug a procedure its very IMPORTANT me Thanks in Advance

Tags: Programming languages

Discussion threads 2005-07-14

SQLAutoScripting (zip)

Database automate tool help create very common sql store procedure. Suport Sql server 2000,SQL Server 2005,MSDE,SQL Server 2005 Express. Required .Net Framwork 2.0. Auto generating 5 type of store procedure: Add new a record, Update a record, Delete a record, Select a record and Select all records data table. This...

Tags: Record, Databases, Productivity, .Net, Programming Languages, Application Servers, Middleware, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-06-13

DOWNLOAD: 10 common SQL Server problems and solutions

This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From "Out of Space" errors to a database going suspect, this list is great quick reference for every SQL administrator.Download and review the list:http://techrepublic.com.com/5138-10879-5995232.htmlThen join this discussion and let us know if this download provides...

Tags: 10 things, Bill Detwiler - TechRepublic, database, dynamic SQL, executor, josh hoskins, Microsoft SQL Server, server, software, SQL, sql server

Discussion threads 2005-12-14

Send parameters to a AS400 stored procedure from a SQL server stored proc

Does anyone know if I can send parameters from a Stored Procedure or a trigger from SQL 2000 to an AS400 stored procedure? AS400 act as a linked server inside SQL server.

Tags: IBM AS/400, Microsoft SQL Server, server, janania@..., programming

Discussion threads 2007-03-07

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

Debugging a Stored procedure in SQL server

For debugging purpose I have put a print statement in the procedure. When I execute the procedure using exec proce_name, the value returned by print statement is 'Failure'But when I try to execute the procedure through query analyser, the value returned by print is 'Success'How come the same piece of...

Tags: aparna.vpai@..., it management, e-mail, Microsoft SQL Server, server

Discussion threads 2007-02-05

Follow the evolution of an SQL query and automate your database reporting

This download shows you how a relatively simple SQL query can evolve into a complex SQL Server stored procedure that automatically sends the correct data to the correct person responsible for acting on that information. Creating an automated SQL query that will retrieve timely data and transmit...

Tags: Download, Microsoft SQL Server, SQL, Databases, Programming Languages, E-mail, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Online Communications

Download resources 2005-07-11

SQL SP Generator (zip)

Benefits of using SQL SP Generator: Completely Integrated with SQL Management Studio; Easy to use step by step Wizard to generate Stored Procedures. Allows script generation using the following options: To SQL File with Unicode or ANSI format; Copy to Clipboard; Copy to New Query Editor Window. Allows assignment of...

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

Software downloads 2007-08-01

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

The SQL Procedure: When and How to Use It?

As a data analyst who did Oracle and SQL Server Database programming before diving into the SAS world, the author is thrilled to find SAS also provides its own version of Structured Query Language SQL. Sure, the DATA step can do a lot of work, but sometimes PROC SQL can...

Tags: SAS Institute, SQL, Databases, Enterprise Software, Software, Data Management

White papers 2006-02-28

Obtain your database's location within a stored procedure

There may be times when your application needs to know the specific directory where your database resides. If you need this information within a stored procedure, find out two ways to obtain the location. Sometimes your application needs to know the specific directory where your database...

Tags: Microsoft SQL Server, SQL, Databases, Arthur Fuller, SQLDataRoot, database, SQL Server Newsletter, TechRepublic Inc., Procedure, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Technical articles 2005-07-22

SQL2000: DTS Query Task - Return Value

In SQL Server 2000, in DTS, a SQL Query Task executes a stored procedure that returns 0 or -1. Either value causes a Workflow property of success, but I require two different actions. I do not want to cause the package to fail for example with raiseerror. ...

Tags: Databases, DTS

Q&A 2006-08-19

How do I... Transfer logins from one SQL Server 2005 instance to another?

about sql 2007i have a liscence 2007 sql server do this procedure will work on it?RE: How do I... Transfer logins from one SQL Server 2005 instance to another?Good article, one additional option for resolving orphaned logins is the sp_change_users_login procedure. Running sp_change_users_login 'report' will show mismatched logins. ...

Tags: Databases, shankardudhane@..., Microsoft SQL Server, Listing B., Microsoft SQL Server 2005

Discussion threads 2007-09-27

ActiveDB (msi)

With ActiveDB you can access your SQL Server stored procedures from a .NET program with one line of code. It's like having IntelliSense on your database. Just point ActiveDB at your development database and let it generate all the stored procedure call stubs. Then give ActiveDB the actual connection string...

Tags: Stored Procedure, mfByte, ActiveDB

Software downloads 2008-06-23