No announcements
Found 2441796 threads
-
2 VotesSql Server stored procedure issue
We call a stored procedure to Sql Server 2008.Answered | 3 Replies | 910 Views | Created by Peter Campanale - Friday, July 22, 2016 2:35 PM | Last reply by Olaf Doschke - Monday, July 25, 2016 2:35 PM
-
0 Votes
Convert SQL Server Stored Procedure into MY SQL Stored Procedure
Is it possible to use MS SQL Server in Linux OS ?Answered | 5 Replies | 1804 Views | Created by Prabhu.R - Wednesday, October 14, 2015 8:58 AM | Last reply by Prabhu.R - Thursday, October 15, 2015 4:54 PM -
0 Votes
Extended stored procedures in SQL Server
Please see the links ...Answered | 5 Replies | 6104 Views | Created by CSharp Enthusiast - Friday, December 2, 2011 11:26 PM | Last reply by CSharp Enthusiast - Tuesday, December 6, 2011 10:48 PM -
0 Votes
Store Procedures in Sql Server 2008
BOL: Create a Stored Procedure BOL: SQL Stored Procedures BOL: CREATE PROCEDURE ...Answered | 6 Replies | 1113 Views | Created by Engr. Zabih Ullah - Wednesday, October 29, 2014 3:52 PM | Last reply by Kalman Toth - Wednesday, October 29, 2014 6:23 PM -
3 Votes
Stored Procedure Language in SQL Server
Yes, With SQL Server 2005 and above you can use .NET languages to create stored procedures.Answered | 3 Replies | 6184 Views | Created by Raptor_45 - Tuesday, March 5, 2013 4:49 AM | Last reply by Vishal Gajjar - Tuesday, March 5, 2013 7:03 AM -
2 Votes
SQL Server Stored Procedure Standards
Using semicolon statement terminators is not just an ANSI standard, but a SQL Server one.Answered | 10 Replies | 3882 Views | Created by ITBobbyP - Tuesday, January 6, 2015 3:08 PM | Last reply by Shivendra Kumar Yadav - Wednesday, January 7, 2015 2:45 PM -
0 Votes
SQL server Procedure stores plan
And this applies both to plans to stored procedures and ad-hoc queries.Answered | 6 Replies | 1605 Views | Created by vikas kumar pathak - Sunday, December 15, 2013 1:11 PM | Last reply by TiborK - Friday, June 6, 2014 12:54 PM -
0 Votes
Tips for Write Stored Procedures (SQL SERVER)
Hi This is very subjective issue.Answered | 1 Replies | 5910 Views | Created by Tarcísio Corte - Thursday, May 19, 2011 10:06 PM | Last reply by Craig Bryden - Thursday, May 19, 2011 10:51 PM -
1 Votes
sql server stored procedure execution plan
Hi sheshu0022, According to your description, my understanding is that you want to know about SQL Server stored procedure ...Answered | 4 Replies | 1284 Views | Created by sheshu0022 - Monday, October 8, 2018 5:37 PM | Last reply by Puzzle_Chen - Tuesday, October 9, 2018 7:48 AM -
0 Votes
Question on SQL Server Stored procedure
>But which result would it return from the first procedure?Answered | 3 Replies | 3642 Views | Created by Manisha_G - Wednesday, August 17, 2011 8:14 PM | Last reply by Chirag Shah - Wednesday, August 17, 2011 11:16 PM -
0 Votes
Sql Stored procedure Issue
Since you mentioned Query Analyzer, what version of SQL Server are you using?Answered | 3 Replies | 5033 Views | Created by vinoth.f1 - Friday, November 27, 2009 5:27 AM | Last reply by vinoth.f1 - Monday, December 14, 2009 11:59 AM -
1 Votes
Call a SQL Server Stored Procedure from VB.net
Hi M.Wilson, According to your description, you want to call SQL Server stored procedures by using Visual Basic.Net.Answered | 2 Replies | 1819 Views | Created by M. Wilson - Monday, March 24, 2014 1:33 AM | Last reply by Sofiya Li - Tuesday, March 25, 2014 6:03 AM -
0 Votes
Stored procedures and SQL Server 2008 Express R2
There could be other issues with non compliant join systax and depricated features since the old database was SS2000.Answered | 3 Replies | 7444 Views | Created by Steve Ho. _ - Wednesday, August 4, 2010 6:25 PM | Last reply by Steve Ho. _ - Thursday, August 5, 2010 1:01 PM -
10 Votes
How to debug stored procedure in SQL server 2005
I personally get around this issue by using PRINT statements within my stored procedures, then commenting them out before I make the stored ...Answered | 18 Replies | 82933 Views | Created by Sujithf - Thursday, January 18, 2007 12:56 PM | Last reply by Kalman Toth - Thursday, November 29, 2012 10:59 AM -
0 Votes
Sql Server Stored Procedure Error
Use better should use IDENT_CURRENT (Transact-SQL) to get the last identity for a specific table; independend of who/when it was inserted.Answered | 2 Replies | 2455 Views | Created by diddi10 - Wednesday, April 3, 2013 9:24 PM | Last reply by Olaf Helper - Thursday, April 4, 2013 5:27 AM -
3 Votes
Stored Procedures in SQL
In SQL Server 2000, the overhead was much larger.Answered | 17 Replies | 9632 Views | Created by Shobin Mathew - Wednesday, May 28, 2008 1:37 PM | Last reply by Jim McLeod - Wednesday, December 1, 2010 10:28 PM -
2 Votes
Complexity of sql server stored procedure
I am not sure that they have SQL, but it is worth a look.Answered | 3 Replies | 2824 Views | Created by rupal biyani - Wednesday, January 4, 2012 1:37 PM | Last reply by Gert-Jan Strik - Thursday, January 5, 2012 9:03 PM -
1 Votes
SQL Server 2008 - Stored Procedure Question
You can use Profiler to see what is going on in SQL Server.Answered | 13 Replies | 2628 Views | Created by Martin-bc - Thursday, June 20, 2013 2:13 PM | Last reply by --CELKO-- - Saturday, June 22, 2013 11:21 PM -
3 Votes
Export stored procedure to .sql SQL Server
I believe you are interested in scripting out all the SP's of a database to a .sql file.Answered | 4 Replies | 23404 Views | Created by Jarrey - Wednesday, June 26, 2013 9:48 AM | Last reply by SandyPe - Friday, May 8, 2015 3:02 PM -
0 Votes
Issue using SQL stored procedure to insert/update
create type FileDetailsType as table ( FileName varchar(50), CreatedDate varchar(50), Size decimal(18,0) ) create ...Answered | 8 Replies | 889 Views | Created by sid_siv - Friday, April 10, 2015 6:34 PM | Last reply by Charlie Liao - Tuesday, April 14, 2015 6:03 AM - Items 1 to 20 of 2441796 Next ›
No announcements
