Functions and Stored procedures in SQL

Here are some notes I found useful in terms of functions and stored procedures in SQL:

• Functions are used for computational purposes and they cannot be used to perform operations such as UPDATE or INSERTS.
• Functions cannot call a stored procedure or run a dynamic SQL statement.
• Stored procedures are used to modify the data (i.e. UPDATE or INSERT statements) in database and communicate with outside. In other words outside programs cannot call a function directly but they can call a stored procedure.
• Stored procedures can call functions, other stored procedures, and run dynamic SQL statements.

Read Full Post »

SQL row_number

row_number() is a SQL command that provides a sequential number for the results starting from 1. The following link provides more information in this regard:

http://msdn.microsoft.com/en-us/library/ms186734.aspx

Read Full Post »

Creating a Flat Dataset in WPF

There are three ways to retrieve and store data into DataSet: a connection object, a command object, and a DataAdapter object. Note that all WPF controls’ data bindings must be bind to an object that implements the IEnumerable interface. This link walks through a simple example to create a flat Dataset:

http://help.infragistics.com/NetAdvantage/WPF/2010.3/CLR4.0/

Read Full Post »