No announcements
Found 3290211 threads
-
3 VotesDifference between Stored Procedure and extended Stored Procedure
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seAnswered | 4 Replies | 1599 Views | Created by MU DBA - Wednesday, August 8, 2018 11:18 AM | Last reply by Erland Sommarskog - Wednesday, August 8, 2018 9:48 PM
-
0 Votes
Risk of Stored Procedures executing differently in newer version of SQL Server
The actual output of the stored procs should not change between versions.Answered | 6 Replies | 757 Views | Created by goofygdog2 - Thursday, November 2, 2017 2:37 PM | Last reply by goofygdog2 - Friday, November 3, 2017 6:33 PM -
7 Votes
Difference between Function and Stored Procedure
So now whats the difference between stored procedure and a view.Answered | 9 Replies | 8247 Views | Created by czarvk - Tuesday, August 16, 2011 2:00 PM | Last reply by TechVsLife2 - Tuesday, August 16, 2011 5:54 PM -
0 Votes
executing stored procedure from different server
As ArthurZ advised correctly, you have define the LinkedServer to execute the storedprocedure from different server.Answered | 4 Replies | 28607 Views | Created by Leo00 - Wednesday, September 29, 2010 8:30 PM | Last reply by SIVAPRASAD S - SIVA - Thursday, September 30, 2010 2:22 AM -
0 Votes
Execute stored procedure in different server
So that procedure is created on server A..Answered | 4 Replies | 2762 Views | Created by Manjunath.M - Monday, November 7, 2011 9:11 AM | Last reply by Manjunath.M - Monday, November 7, 2011 9:43 AM -
0 Votes
convert Oracle stored procedures to SQL Server
SQL Server Agent would be the way to schedule running those procedures.Answered | 2 Replies | 9038 Views | Created by GoldenTalent - Thursday, July 8, 2010 5:54 AM | Last reply by Stoyko Kostov - MSFT - Friday, July 9, 2010 4:45 PM -
0 Votes
create a oracle stored procedure
Sorry, this is not an Oracle forum.Answered | 1 Replies | 6692 Views | Created by Sathishkumar.spsk - Wednesday, September 14, 2011 6:33 PM | Last reply by Jens K. Suessmeyer - - Wednesday, September 14, 2011 9:08 PM -
1 Votes
Stored Procedure to drop users from different database
That works, thanks so much!Answered | 2 Replies | 694 Views | Created by AlHowarthWF - Monday, March 12, 2018 1:37 PM | Last reply by AlHowarthWF - Monday, March 12, 2018 8:27 PM -
0 Votes
Dataset from different stored procedures
Push your stored procedures down a level.Answered | 1 Replies | 2562 Views | Created by AvivaG - Monday, June 11, 2012 6:16 PM | Last reply by BI Baracus - Monday, June 11, 2012 7:05 PM -
4 Votes
WCF OracleDB binding and different Oracle schema on different environment
To have these vary from environment to environment would, IMO, be the same as having different WSDL's for a Web Service in QA and Production!Answered | 4 Replies | 1188 Views | Created by Rahul_Madaan - Tuesday, November 11, 2014 2:54 PM | Last reply by Rahul_Madaan - Thursday, November 13, 2014 4:53 PM -
0 Votes
Stored procedure seen as different despite identical content
I bet SQL Server is canonicalizing the script for you.Answered | 5 Replies | 4194 Views | Created by Richard Gavel - Friday, July 20, 2012 6:12 PM | Last reply by MSD and Technoloy - Friday, October 14, 2016 1:50 PM -
0 Votes
Different query plans for the same stored procedure against different logins
Inside the sp, does it refer to linked server tables?Answered | 6 Replies | 1790 Views | Created by Nirupam - Tuesday, January 8, 2013 1:55 PM | Last reply by Nirupam - Thursday, January 10, 2013 1:30 PM -
0 Votes
Executing a Stored Procedure for a Parameter Dataset on a different database
I did not want to get into the business of having and providing multiple data sources specifying different databases on the same server.Answered | 3 Replies | 975 Views | Created by ITBobbyP - Wednesday, June 13, 2018 7:40 PM | Last reply by ITBobbyP - Thursday, June 14, 2018 1:33 PM -
0 Votes
Convert an Oracle Stored Procedure to SQL Server
SQL Server will return a result set for you and you don't need anything special here.Answered | 3 Replies | 914 Views | Created by Runner288 - Wednesday, October 7, 2015 7:08 PM | Last reply by CarlGanz - Wednesday, October 7, 2015 8:06 PM -
0 Votes
Differences between Clustering in oracle and SQL
The biggest difference is that Oracle supports writing to many different nodes where SQL Server does not.Answered | 2 Replies | 1038 Views | Created by venkatesh1985 - Monday, October 5, 2015 8:15 PM | Last reply by burt_king - Tuesday, October 6, 2015 1:25 PM -
0 Votes
Stored procedure giving different output for static database
Without a repro, you could either open an incident with MS and see if they can work privately with you to sort this out, or just go with MAXDOP 1.Answered | 4 Replies | 530 Views | Created by A2605 - Thursday, February 8, 2018 12:45 AM | Last reply by TiborK - Thursday, February 8, 2018 10:14 AM -
1 Votes
oracle store procedure in vb.net
Is the server plugged in?Answered | 6 Replies | 1348 Views | Created by APriya - Thursday, February 21, 2013 5:26 AM | Last reply by Paul P Clement IV - Thursday, February 21, 2013 2:01 PM -
0 Votes
Different results in Stored Procedure and in the report
Hi DReddyC, According to your description, the stored procedure contains a parameter, when you run the procedure in dataset, it can return corresponding ...Answered | 2 Replies | 750 Views | Created by DReddyC - Wednesday, October 21, 2015 6:39 PM | Last reply by Qiuyun Yu - Thursday, October 22, 2015 6:36 AM -
0 Votes
Performance difference between view and stored procedure
http://beyondrelational.com/blogs/livingforsqlserver/archive/2011/08/09/interview-question-difference-between-views-and-stored-procedures.aspxAnswered | 8 Replies | 27810 Views | Created by cse_supriya - Thursday, August 26, 2010 7:32 AM | Last reply by Ramkumar Gopal - Tuesday, August 9, 2011 1:17 PM -
0 Votes
LinqToSql stored procedures and executing as a different user?
; perform Linq functions } However, if you do have to have security at the sql user level, you could have ...Answered | 1 Replies | 3770 Views | Created by Matt234939393 - Wednesday, March 25, 2009 11:39 PM | Last reply by Narayan Sainaney - Tuesday, March 31, 2009 4:35 AM - Items 1 to 20 of 3290211 Next ›
No announcements
