No announcements
Found 2870195 threads
-
1 Voteswhat is difference between views and table and stored procedure
http://www.google.com/search?Answered | 3 Replies | 8091 Views | Created by pnreddy - Wednesday, February 1, 2012 6:10 PM | Last reply by Kalman Toth - Saturday, February 4, 2012 11:17 AM
-
7 Votes
Difference between Function and Stored Procedure
So now whats the difference between stored procedure and a view.Answered | 9 Replies | 8232 Views | Created by czarvk - Tuesday, August 16, 2011 2:00 PM | Last reply by TechVsLife2 - Tuesday, August 16, 2011 5:54 PM -
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 | 27784 Views | Created by cse_supriya - Thursday, August 26, 2010 7:32 AM | Last reply by Ramkumar Gopal - Tuesday, August 9, 2011 1:17 PM -
3 Votes
Difference between Stored Procedure and extended Stored Procedure
http://www.nullskull.com/q/10014003/tell-me-the-difference-between-stored-procedure-and-extended-stored-procedure.aspx &# ...Answered | 4 Replies | 1574 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
Joins between View and Store Procedure
Hi, You can create a simple view or a table value parameter to accomplish this.Answered | 3 Replies | 2150 Views | Created by Ashish Gupte - Wednesday, July 4, 2012 2:51 PM | Last reply by Satheesh Variath - Wednesday, July 4, 2012 3:53 PM -
3 Votes
how to share table between stored procedure?
Hi First read what is GLOBAL Temporar table as below, then use it in storead procedure.Answered | 3 Replies | 7849 Views | Created by moshik.salem - Saturday, July 14, 2012 4:49 PM | Last reply by Ahsan Kabir - Saturday, July 14, 2012 8:46 PM -
1 Votes
Comparision between Stored procedure, Views and Function
Stored procedure are the most flexible DB programming objects.Answered | 4 Replies | 5815 Views | Created by Gopi Krishna Thakur - Friday, December 4, 2009 2:27 PM | Last reply by Gopi Krishna Thakur - Monday, December 14, 2009 1:36 PM -
1 Votes
Using views in stored procedure instead of tables
Indexed views are completely different story.Answered | 7 Replies | 10829 Views | Created by Florian Santi - Tuesday, October 2, 2012 8:53 AM | Last reply by Aalamjeet Rangi - Saturday, November 10, 2012 5:48 PM -
8 Votes
Views vs Stored Procedures
Chinta is right, there is negligible performance differences between ad hoc (dynamic) SQL and stored procedures--despite the fact that the tests he quotes are ...Answered | 10 Replies | 42295 Views | Created by Rohan Kalra - Saturday, May 1, 2010 8:01 AM | Last reply by Naomi N - Thursday, September 17, 2015 10:29 PM -
0 Votes
Folders for Managing Stored Procedure, Tables, Views
It may seem logically to store it in SQL Server, but the Database Engine does not really know what SSMS is.Answered | 3 Replies | 892 Views | Created by Sodi Singh - Wednesday, March 25, 2015 5:24 PM | Last reply by Erland Sommarskog - Wednesday, March 25, 2015 10:52 PM -
0 Votes
stored procedure from view
Under normal circumstances you'd be able to load the SP results into a temp table and use the temp table in place of the view... but... since the SP is using a dynamic ...Answered | 5 Replies | 2299 Views | Created by kdinuk - Wednesday, August 22, 2012 6:40 PM | Last reply by Jason A Long - Thursday, August 23, 2012 2:21 AM -
5 Votes
what is the difference between using Cursors and aTemp table
ALTER PROCEDURE [dbo].Answered | 7 Replies | 16552 Views | Created by anjigvr - Tuesday, September 22, 2009 10:23 AM | Last reply by Abdshall - Tuesday, September 22, 2009 2:13 PM -
1 Votes
Calling a View in a Stored Procedure
If the view only refers to one table, you can do an update without problems.Answered | 4 Replies | 2666 Views | Created by ti2 - Wednesday, November 16, 2011 11:35 AM | Last reply by Steen Schlüter Persson - DK - Wednesday, November 16, 2011 2:08 PM -
0 Votes
Scripting Stored Procedures to Table
In SSMS, open the file of stored procedures you saved above, and run it.Answered | 4 Replies | 4520 Views | Created by Trancedified - Wednesday, June 22, 2011 12:13 AM | Last reply by Trancedified - Thursday, June 23, 2011 4:07 PM -
1 Votes
Stored Procedures and table references
You can get list of Views, SP, functions which use your table by executing below SQL: EXEC sp_depends @objname = N'dbo.MyTable' ; To get the ...Answered | 4 Replies | 883 Views | Created by warnerrj79 - Monday, July 28, 2014 11:36 AM | Last reply by Kalman Toth - Monday, July 28, 2014 5:55 PM -
0 Votes
What is the difference between a LightSwitch entity and a SQL table?
We're all quite familiar with that data model: tables, views, columns, keys, constraints and so forth are all elements of that data model.Answered | 5 Replies | 5485 Views | Created by mdlm - Monday, September 27, 2010 1:27 AM | Last reply by Oscar Agreda - Wednesday, October 6, 2010 7:26 PM -
6 Votes
What is difference between CTE(Common Table Expression) and Variable Tables?
What is the main difference: Table variable is like Temporary Table.Answered | 4 Replies | 2468 Views | Created by Dariush_Malek - Sunday, November 17, 2013 5:58 AM | Last reply by Dariush_Malek - Monday, November 18, 2013 8:23 AM -
0 Votes
Create a View, function or stored procedure for query?
The sole alternative that remains as long as you have the temp table is a stored procedure.Answered | 3 Replies | 882 Views | Created by jaggy99 - Thursday, March 19, 2015 12:41 PM | Last reply by Jason A Long - Thursday, March 19, 2015 2:04 PM -
3 Votes
Difference between Index on Table and Index on View
http://stackoverflow.com/questions/2595136/what-is-the-difference-between-an-table-index-and-a-view-indexAnswered | 4 Replies | 9032 Views | Created by Sambasiva Reddy - Thursday, March 15, 2012 11:57 AM | Last reply by willsonsingh - Saturday, March 17, 2012 8:46 AM -
1 Votes
difference between ALTER and DROPCREATE VIEW
This includes an indexed view.Answered | 3 Replies | 2839 Views | Created by Hennie7863 - Wednesday, April 11, 2012 5:46 PM | Last reply by Hennie7863 - Thursday, April 12, 2012 11:34 AM - Items 1 to 20 of 2870195 Next ›
No announcements
