No announcements
Found 2897766 threads
-
0 VotesHarcoding SQL statements VS calling DB functions/procedures with the result set
they can't have stored procedures for the Read Only database. Please get the pros and cons of the Inline VS Stored procedure from ...Unanswered | 5 Replies | 4462 Views | Created by Veverke - Friday, July 27, 2012 10:24 AM | Last reply by Bob Shen - Friday, August 3, 2012 3:03 PM
-
1 Votes
functions vs procedures
code in a stored procedure. Stored procedures contain one or more T-SQL statements, which are compiled and ready to be executed when required. Stored procedures ...Answered | 5 Replies | 4191 Views | Created by psingla - Tuesday, April 13, 2010 3:35 AM | Last reply by Naomi N - Tuesday, April 13, 2010 12:04 PM -
0 Votes
Calling functions/Procedures from forms
Add a Module in your Project. Locate the Function there and make it Public.Answered | 2 Replies | 3626 Views | Created by FrancisEnem - Thursday, November 23, 2006 1:19 PM | Last reply by FrancisEnem - Thursday, November 23, 2006 3:21 PM -
0 Votes
Only for SQL GURUS - Calling external procedures from Functions
Shaun and UmaThe solutions you have given me instead of using external stored procedures I am aware of that. The application would run on Oracle or SQL Server ...Answered | 5 Replies | 8533 Views | Created by Imtiaz3 - Sunday, November 20, 2005 8:07 AM | Last reply by Shaun Wilson - Friday, December 2, 2005 5:38 AM -
1 Votes
Calling SQL statements in a SQL connetion
statements somehow from the sql connection? Any help would be greatly appreciated. I'm using Visual C# Express with sql ...Answered | 5 Replies | 6780 Views | Created by PCRider - Thursday, December 23, 2010 10:02 PM | Last reply by Chirag Shah - Friday, December 24, 2010 8:07 PM -
0 Votes
SQL CLR stored procedures & functions
Hi, I am using SQL Server 2008 R2. I am new to writing SQL CLR stored procedures & functions. Was wondering if there's a good book or an online resource that I ...Answered | 3 Replies | 3678 Views | Created by CSharp Enthusiast - Tuesday, June 25, 2013 8:46 PM | Last reply by CSharp Enthusiast - Wednesday, June 26, 2013 3:09 PM -
0 Votes
adding tags to sql functions or procedures
allows the user to select the desired procedure (friendly name) for calculating payrolls is there a way to add tags to the procedures or ...Answered | 1 Replies | 4502 Views | Created by alihijazi - Tuesday, December 7, 2010 5:17 AM | Last reply by ramireddy - Tuesday, December 7, 2010 5:26 AM -
0 Votes
Stored Procedures with SQL Spatial datatypes/functions
Hi there - Quick question, has anyone else experienced problems calling (from Visual Studio) stored procedures that contain spatial data types? If I ...Answered | 3 Replies | 10843 Views | Created by blomm - Thursday, January 28, 2010 4:58 PM | Last reply by blomm - Friday, January 29, 2010 10:30 AM -
1 Votes
SQL developer - Moving functions and procedures
I have to write procedures and functions( included or not in packages) in the form of .txt or .sql scripts. Then I have to launch in Sql Developer these ...Answered | 3 Replies | 794 Views | Created by Vasi27 - Sunday, October 27, 2013 7:24 PM | Last reply by pituach - Monday, October 28, 2013 7:07 AM -
1 Votes
Stored Procedures versus Functions
result when called with the same values for parameters. For this reason non-deterministic functions such as GetDate() cannot be used in functions. You ...Answered | 5 Replies | 15519 Views | Created by Avada Kedavra - Thursday, September 22, 2005 1:28 AM | Last reply by Kalman Toth - Friday, October 26, 2012 1:46 PM -
0 Votes
Trace/Log execution of T-SQL statements in SQL Server Stored Procedures/User Defined Functions
Hi, I need to track a set of T-SQL statements and their execution sequences in some stored procedures in my test ...Answered | 1 Replies | 4933 Views | Created by Shyam SS - Monday, August 31, 2009 5:56 PM | Last reply by JohnVPetersen - Thursday, September 3, 2009 12:48 PM -
0 Votes
calling user-defined functions in another DB
I have a number of databases that require a set of common functions. I'd like to place all those functions in a central DB. I'm having trouble ...Answered | 4 Replies | 6259 Views | Created by rsd_za - Wednesday, June 28, 2006 9:01 AM | Last reply by rsd_za - Wednesday, June 28, 2006 9:55 AM -
0 Votes
SQL statements vs Excel
Hi all, Just a question. Is it possible to use SQL statements in MS Access VBA to retrieve data in an MS Excel ...Answered | 2 Replies | 240 Views | Created by Deon SA - Thursday, February 1, 2018 2:20 PM | Last reply by Deon SA - Friday, February 2, 2018 5:50 AM -
4 Votes
SQL Server 2005 - Functions and Procedures
Normally you do stored procedures. Functions are significantly limited when compared to stored procedures, for example no database changes in ...Answered | 3 Replies | 4137 Views | Created by ajliaks - Wednesday, October 28, 2009 6:35 AM | Last reply by Kalman Toth - Wednesday, October 28, 2009 6:59 AM -
0 Votes
How to view SQL statements with prepared stored procedures, sp_execute
I am able to get the SQL statements in the profile except for queries having parameters. Profiler doesn't replace the parameters with actual value ...Answered | 7 Replies | 1484 Views | Created by Paul Byrum - Tuesday, June 17, 2014 2:17 AM | Last reply by Jens K. Suessmeyer - - Tuesday, June 17, 2014 4:41 PM -
4 Votes
SQL statements with parameters vs. parameter embedded
Hi everybody, Can you please give me pros and cons in using parameters when sending SQL statements from C# code vs. having them with parameters ...Answered | 14 Replies | 4529 Views | Created by Naomi N - Tuesday, November 12, 2019 5:15 PM | Last reply by Rachel_Wang - Tuesday, November 19, 2019 8:42 AM -
0 Votes
How to return the result set of multiple select statements as one result set?
Hi All, I have multiple select statements in my stored procedure that I want to return as one result set for ...Answered | 2 Replies | 768 Views | Created by Developer life - Tuesday, September 23, 2014 10:17 PM | Last reply by Developer life - Wednesday, September 24, 2014 4:28 AM -
0 Votes
Stored Procedures vs. Dynamic SQL
Search "stored procedure sql statement faster" on http://www.msdn.com and the first result contains the answer to the ...Answered | 3 Replies | 6720 Views | Created by Ajaidass - Sunday, September 27, 2009 9:55 PM | Last reply by Hooray Hu - Monday, September 28, 2009 1:49 AM -
0 Votes
Functions and Procedures
You can use DML statements. However using DDL and DCL would require the usage on dynamic sql i.e. sp_executesqlWith kind regards Krystian ...Answered | 4 Replies | 5002 Views | Created by Gangadhar Thumu - Wednesday, July 20, 2011 6:53 PM | Last reply by Kalman Toth - Wednesday, July 27, 2011 9:04 AM -
0 Votes
dynamic sql vs stored procedures
includes discussion of dynamic SQL vs stored procedures. Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seAnswered | 2 Replies | 3278 Views | Created by Bryan Rev - Thursday, January 19, 2012 12:37 AM | Last reply by Erland Sommarskog - Thursday, January 19, 2012 8:39 AM - Items 1 to 20 of 2897766 Next ›
No announcements
