Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Stored Procedures


Search:
What's New - What's Hot
Stored Procedure Driven Data Grid  Version: 0.00     Price: $0.00  
Total Hits: 23  |  Today: 0Author: Dogan Erdogant      Rating:  
Read Reviews | Write Review |  Your Rating: 

DataGrid control is the main method to display information for web users. Heavy loaded applications like accounting, stock management, etc. require many more reports and update while application gets bigger. Altering the data source, reflecting the column changes to the datagrid mostly takes the longest time. Moreover displayed data of a report can vary for each branch or user, end-user requests for summary columns, column positions, cell colors, etc. is sometimes frustrating. End-user doesn't w...

Code First Stored Procedures  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: aureolin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Code First is a new, lightweight database interface provided by the same team that brought you MVC3 and Razor. While it does many things well, one hole in its interface is stored procedures. This project provides routines that can call stored procedures and will properly handle input and output parameters, return codes and multiple result sets....

Dynamic Where Clause in Oracle 11g stored procedures  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: kaveh Yazdi Nezhad      Rating:  
Read Reviews | Write Review |  Your Rating: 

Its long time that im using stored procedures in both oracle and sql server to do my programmings and this is all other programmers are doing too.but when we move every thing in spc then some times we need to do search inside our spc too and return the result. so i was asking my own how i can generate a spc in oracle that recices parameters from caller and do a dynamic search based on what is passed to.
certainly i need to have a flexible dynamic WHERE at end of my spc that have to be generat...

Enable Guest Payments Using PayPal’s Adaptive Payments API  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Chris_Hall      Rating:  
Read Reviews | Write Review |  Your Rating: 

The ability to pay without creating an account is often a stopping point for consumers, resulting in lost sales. Implementing this feature has been a challenge for developers, because the solution you choose must comply with payment card industry (PCI) standards for credit card security, a potentially complex challenge. Now you can easily capture those consumers using Guest Payments included in PayPal’s Adaptive Payments API....

Getting all stored procedures from a database  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Hardcoder      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also....

Source control for stored procedures in SQL Server 2005  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Deeraj      Rating:  
Read Reviews | Write Review |  Your Rating: 

However, DBA's need to track the modifications made to the stored procedures and/or schema changes. For this, SQL Server Management Studio (Developer and later versions) support source control not only for stored procedures but also for schema definitions. Having averred that only T-SQL can be saved in .sql files and no graphical user interface can be made available....

Sql Server - How to write a Stored procedure in Sql server  Version: 0.00     Price: $0.00  
Total Hits: 32  |  Today: 0Author: Vivek Johari      Rating:  
Read Reviews | Write Review |  Your Rating: 

Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. There are many benefits of using a stored procedure. The main benefit of using a stored procedure is that it increases the performance of the database.The other benefits of using the Stored Procedure is given below:-...

Inserting & Retrieving Images from SQL Server Database without using Stored Procedures  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Prashanth Chindam      Rating:  
Read Reviews | Write Review |  Your Rating: 

To insert into & retrieve images from SQL server database without using stored procedures and also to perform insert, search, update and delete operations & navigation of records....

WS-I, Exposing Stored Procedures as Web Services, and More  Version: 0.00     Price: $0.00  
Total Hits: 12  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

WS-I stands for the Web Services Interoperability Organization, a new industry consortium whose goal is to promote interoperability across Web Services implementations. The WS-I was announced in February of this year. Founding members include Microsoft®, IBM, Intel, Oracle, SAP, HP, BEA Systems, Fujitsu, and Accenture. The founding members have already been joined by a long list of additional member companies, all of whom seem serious about ensuring interoperability between their various (and of...

Abstract simplified stored procedure execution using .NET interfaces  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Alan Kaplan      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article will show how we can access database without dealing with any ADO.NET objects, and just working with strongly typed interfaces. Let's say we have to call Stored Procedure and using just plain ADO.NET we have to work with Connection, Command, and Parameter objects writing tons of boring code. What if calling stored procedure would be just a simple method call. And yes, there are quite a few frameworks, which simplify this task, and I am not claiming to overpower these frameworks. For...

Useful Undocumented SQL Server Extended Stored Procedures  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Extended stored procedures are used to extend the capabilities of SQL Server. You can take advantage of the many extended stored procedures that come with SQL Server, or you can can write your own in a ...

SQL Server 6.5 Useful Undocumented Stored Procedures  Version: 0.00     Price: $0.00  
Total Hits: 55  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5....

SQL Server 2000 Undocumented Stored Procedures  Version: 0.00     Price: $0.00  
Total Hits: 13  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000....

SQL Server Stored Procedures Comparer  Version: 0.00     Price: $0.00  
Total Hits: 17  |  Today: 0Author: Christopher Ayroso      Rating:  
Read Reviews | Write Review |  Your Rating: 

First and foremost, I'm a developer from Philippines so pardon me for my bad English. I am currently employed in an offshore development company that designs, develops and delivers technology solutions for many pharmaceutical companies. This is my first article for the CodeProject and is entitled "SQL Server Stored Procedures Comparer". The CodeProject community had helped me greatly in many of my programming tasks, so I think it's time that I give back something in return that maybe useful....

Application Code for Mapped Stored Procedures (Entity Framework)  Version: 0.00     Price: $0.00  
Total Hits: 14  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

The application code in this section illustrates how stored procedures that update data are used by the Entity Framework. The object model and stored procedures used in the example are described in Stored Procedure Support (Entity Framework). When stored procedures are defined in the storage schema and mapped in the mapping specification, they are called implicitly. Code sequences used to create, update, and delete entities are the same whether or not you are using stored procedures in the data ...

Simple Stored Procedures in .NET     
Total Hits: 95  |  Today: 0Author: H.Riazi      Rating:  
Read Reviews | Write Review |  Your Rating: 

I was working on a simple CMS (Content Management System) project where I was faced with a tiring and exhausting procedure of defining each of the variables that I used in my SQL Stored Procedures. It was a tedious procedure specially when there were a lot of them and sometimes or shall I say most of the time, it was not easy to remember their data types. So I decided to develop a simpler way of communicating with Stored Procedures without having to write a bunch of code to define the command ty...

Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008     
Total Hits: 127  |  Today: 0Author: Michelle Gutzait      Rating:  
Read Reviews | Write Review |  Your Rating: 

I need to query a large amount of data to my application window and use paging to view it. The query itself takes a long time to process and I do not want to repeat it every time I have to fetch a page. Also, the number of rows in the result set could be huge, so I am often fetching a page from the end of the result set. I can't use the default paging because I wait a long time until I get the data back. What are my options?...

LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures)     
Total Hits: 53  |  Today: 0Author: ScottGu      Rating:  
Read Reviews | Write Review |  Your Rating: 

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data....

Implementing the Table and StoredProcedure     
Total Hits: 96  |  Today: 0Author: Peter A. Bromberg      Rating:  
Read Reviews | Write Review |  Your Rating: 

When ASP.NET 2.0 first arrived last year, there wasn't very good sample code or documentation, and if you didn't have any experience in "rolling your own" provider implementation, there were some drawbacks that didn't look like they would be very easy to fix....

Using SQL Server Cursors     
Total Hits: 82  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you how to create and use server side cursors and how you can optimize a cursor performance.

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. For example, you can use cursor to include a list of all user databases and make multiple operations against each database by passing each database name as a variable.

The ...


1  2  3  4  5  6  7  8  9  10  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net