SQL Server Stored Procedures Questions and Answers

Recent IT Questions

1 - 20 of 39
<<PREVIOUS 1|2 NEXT>>

PRINT statement in Stored Proc SQL Server 2005

Does PRINT statement in stored proc cause network traffic or any performance issues? Can i get some tips to write good store proc that gains performance.   Thanks.

View Answer   |  Aug 12 2009  6:27 AM GMT
SQL Server 2005, SQL Server stored procedures
asked by Jsql

  140 pts.

Purpose of creating SQL Server stored procedures at run time

Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it's effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance

asked by Skothamasu

  15 pts.

stored procs in Master db, sql server 2005

Does anyone know where I can get a list describing, in layman's terms, all the sp_usr... stored prodedures in the Master database? New to all this and don't have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers

View Answer   |  May 12 2009  3:49 PM GMT
SQL Server stored procedures, SQL Server 2005, T-SQL
asked by GillsJules

  5 pts.

How can I call a trigger in a SQL Server stored procedure?

How can I call a trigger in a SQL Server stored procedure?

asked by SQL Server Ask the Experts

  2445 pts.

How do you create stored procedures in SQL Server 2000?

How do you create stored procedures in SQL Server 2000?

View Answer   |  May 1 2009  7:18 PM GMT
SQL Server 2000, SQL Server stored procedures
asked by SQL Server Ask the Experts

  2445 pts.

Output errors from SQL Server stored procedure

I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details to a...

asked by Spionred

  35 pts.

optimization of stored procedures in sqlserver

is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh

asked by Naresh1226

  5 pts.

Passing data between two SQL Server databases

Is it possible to have a stored procedure in a SQL Server database look at tables in another SQL Server database by sending the second database name as a parameter to the stored procedure?

asked by SQL Server Ask the Experts

  2445 pts.

Optimizing a SQL Server stored procedure

I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

View Answer   |  Apr 2 2009  4:47 PM GMT
SQL Server stored procedures, SQL Server tables, EXEC
asked by SQL Server Ask the Experts

  2445 pts.

SQL Server Stored Procedure

An interesting question asked to me. We always mention, we can do lots of things inside a SQL Server Stored Procedure. But does anyone know what cannot be done inside a SQL Server Stored Procedure?

View Answer   |  Mar 3 2009  7:03 PM GMT
SQL Server stored procedures
asked by Topsidestone

  5 pts.

How do I refresh the Stored Procedure used for Crystal Reports datasource

I have an existing Crystal Report that uses a Stored Procedure as a datasource. The requirements have changed and the Procedure has been updated to have only one parameter instead of two. How do I refresh the Stored Procedure without removing it. I have tried to Verify the Database but just get an...

Answer Question   |  Feb 27 2009  4:12 AM GMT
Crystal Reports, SQL Server, Stored Procedures
asked by Flyght

  55 pts.

How do I avoid a security exposure using XP_SendMail

I'm using XP_Sendmail in a trigger on my database. In order to run the trigger, I have to give database access to the "guest" user. I'm concerned about security. I've tried a Stored Proc called SP_Sendmail that calls XP_Sendmail, but I still have to grant db access to the "guest". Any help here...

asked by Arlin

  70 pts.

Passing an array into a Stored Procedure

is there a possibility of passing an array into a Stored procedure i am using java and sqlserver 2000

View Answer   |  Jan 30 2009  7:40 AM GMT
Arrays, SQL Server stored procedures, Java
asked by Khperi

  5 pts.

I need to up load an excel file to sql server db with vb

I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

asked by Xs40

  10 pts.

Creating tables on a SQL Server

I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want to use a...

View Answer   |  Jan 8 2009  3:29 PM GMT
SQL Server, SQL Server tables, SQL Server Scripts
asked by SQL Server Ask the Experts

  2445 pts.

Is there a query to retrieve datatypes from SQL stored procedures?

I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name =...

asked by SQL Server Ask the Experts

  2445 pts.

Stored procedures to script table data in SQL Server 2005

Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?

asked by SQL Server Ask the Experts

  2445 pts.

Convert SAS to Stored Procedure

How do I convert a SAS job into a Stored Procedure to run on MS SQL Server 2005?

asked by VelameLaCosa

  65 pts.

Calling an Oracle stored procedure in SQL Server

I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

asked by SQL Server Ask the Experts

  2445 pts.

Inserting rows and multiple rows in SQL Server 2005 Express

Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

Answer Question   |  Dec 14 2008  2:16 PM GMT
VB.NET, Visual Basic .NET, Stored Procedures
asked by Ariell

  5 pts.

1 - 20 of 39
<<PREVIOUS 1|2 NEXT>>