Create Temporary cursor in MS SQL Server

---

• Create Temporary cursor in MS SQL Server
• Functional Programming using C# 4.0 – Functional Composition
• How to use Coalesce in Sql server
• Explore Razor View Engine Part 2
• Dynamic Polymorphism Example in C#
• Difference Between Abstract Class and Interfaces
• How to check whether user defined XPath is present in XML file or not?
• Generating Executable Code with C# Scripting at Runtime
• T-sql CTE in SQL Server
• Cascading Dropdown lists initialization using javascript
• Working With Nested Grid Views in ASP.NET
• SSIS – Conditional Split Transformation
• C++ Development- An Up-Close Rendezvous

Create Temporary cursor in MS SQL Server Posted: 08 Sep 2012 07:00 AM PDT In this article I am give to explain what is temporary cursor and how you can use it in a stored procedure. Temporary cursor is very useful and it is very simple. The Temporary cursor is very fast and easy and it requires very less code compared to the normal cursor.

Functional Programming using C# 4.0 – Functional Composition Posted: 15 Sep 2012 06:12 AM PDT C# 4.0 treats functions as regular objects which enables programmers to use functions as arguments of other functions. Functions those take other functions as arguments are technically called as <b>higher order functions</b>. <b>Functional composition</b> is one such example of higher order functions. <b>Functional composition </b> is a <b>functional programming</b> concept in which two or more functions can be combined to compose a higher order ...

How to use Coalesce in Sql server Posted: 15 Sep 2012 12:31 PM PDT In this article I will be explaining you about Coalesce Function in MS SQL server. The Coalesce function is one of the very useful function and using that function we can reduce the lot of ode in Sql. In this Article we will see how to use Coalesce function in MS SQL with a sample query.

Explore Razor View Engine Part 2 Posted: 15 Sep 2012 05:19 PM PDT This is continuation of first post about Explore Razor view Engine. In my previous post I have mentioned about basic and some good usage of Razor view engine and it's Syntax. Let's look some more about the Razor in this post.

Dynamic Polymorphism Example in C# Posted: 16 Sep 2012 10:28 AM PDT Polymorphism are of two types 1. Static or Compile Time polymorphism 2. Dynamic or Run Time polymorphism Run time Polymorphism also known as method overriding. In this type the call to a function is decided at the runtime.

Difference Between Abstract Class and Interfaces Posted: 16 Sep 2012 10:05 PM PDT In this short article we will discuss the difference between the Abstract class and the interface, through an example. many of us get confused with the difference between the abstract class and the interface, so let us know the difference of the two through definition only.

How to check whether user defined XPath is present in XML file or not? Posted: 19 Sep 2012 01:52 AM PDT With the help of this code, finding XPath becomes very easy. Code has been developed in C# whereas application is windows based. You can customize this code if you require complex XPaths. This is used as baseline.

Generating Executable Code with C# Scripting at Runtime Posted: 19 Sep 2012 09:12 AM PDT This Article privides a Code Snippet to illustrate generating executanle code (classes) at run time with the help of C# compiler. This Sample also includes Code to use Reflection to create instance of a class (from specified namespace) and also to call class methods alongwith parameters.

T-sql CTE in SQL Server Posted: 19 Sep 2012 11:40 PM PDT Common Table Expression in t-sql is introduced in SQL Server 2005. CTE is a temporary result set used as a derived table and also that can be declared once and reference anywhere in a query. CTE only exist only in the scope of current query. We can also use CTE recursively in a query.

Cascading Dropdown lists initialization using javascript Posted: 20 Sep 2012 01:48 AM PDT This resource provides an approach for 'Reseting 2nd Dropdown list (months) based on SelectedIndexChange event of 1st Dropdown list (years)' with the help of javascript. (for ease i have hard-coded years and months Dropdown lists but available dates (year and months) can be stored in a comma seperated string/text (code behind from database/etc) which can be accessed in javascript using a hidden field to reset Dropdown lists).

Working With Nested Grid Views in ASP.NET Posted: 20 Sep 2012 02:17 PM PDT While working with relational data, you would like to show the data in such a way that it should make sense to the user and have good user experience. In this article I will go over how to use the Nested Grid Views with Expand and collapsed functionality to show the data.

SSIS – Conditional Split Transformation Posted: 21 Sep 2012 11:56 PM PDT In this article, I create a simple ETL package that extracts data from a table and transforms the data using conditional split transformations and finally loads the result into multiple flat file destination.

C++ Development- An Up-Close Rendezvous Posted: 23 Sep 2012 04:28 AM PDT C++ development is generally considered to be of high importance to the programmers. Technically speaking c++ happens to be a multi paradigm language program that offers you a great podium to compile features and get a particular job done with expected level of proficiency.

You are subscribed to email updates from .NET Articles, Tutorials and Resources To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610