Day: March 12, 2005

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

Exforsys
This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code. Creating Stored Procedure with Input ParametersInput Parameters in Stored Procedures are placeholders for data that the user needs to send. Technically, input parameters are memory variables because they are stored in memory. For creating Stored Procedure with Input Parameters, just change the above code to look like CREATE PROCEDURE Show_Customer @City varchar(50) AS SELECT FirstName, LastName FROM Customer WHERE Location=@City ORDER BY FirstName Here the placeholder… Read More

SQL Server 2000:Creating and Using Stored Procedures

Exforsys
This tutorial series covers the basic concepts of Stored Procedures in SQL Server and hot create and execute a simple stored procedure.Using Stored ProceduresSome of the most important concerns to a database user are speed and efficiency. Faster data retrieval provides applications to responds and behaves quickly. SQL Server provides “Stored Procedures” for faster and quick data access. Stored Procedures is a query that is stored in a database on SQL Server rather than being stored in the front-end code on users machine. You may think that storing queries in… Read More

Using Rich Server Controls with C#

Exforsys
In the last article we saw some of the simple controls. Those included validation controls, TextBox, Label and other simple controls. Microsoft.net framework provides the developer with more advanced controls. Among those are the Calendar, AdRotator and the Xml Control. In this Tutorial we will see how we can make use of the rich controls provided by the framework.Using Rich Server Controls with C# Introduction: In the last article we saw some of the simple controls. Those included validation controls, TextBox, Label and other simple controls. Microsoft.net framework provides the… Read More