Sql Select statement with auto generated row id

I would like to create a select query statement with autonumber.. like..

select Id,Name from myTable

will give me everything from table.

The result I'd like to get is..

1 data1

2 data2

3 data3

So i have used the below query

SELECT ROW_NUMBER() OVER (ORDER BY Name) , * FROM myTable

Comments

Code To Convert rupees(numbers) into words using C#.Net

Introduction: In my previous article I have explained about how to validate emailid using javascript . In this article I am going to explain about code used to convert rupees(numbers) into words using C#.Net . Explanation: For explanation purpose I have a page. It has a textbox to input the numbers. And when you click on the convert to words button then it will convert the input numbers into words and shows it in the below label. Below is the C# code used to do this functionality. public static string NumbersToWords( int inputNumber) { int inputNo = inputNumber; if (inputNo == 0) return "Zero" ; int [] numbers = new int [4]; int first = 0; int u, h, t; System.Text. StringBuilder sb = new System.Text. StringBuilder (); if (inputNo < 0) { ...

C# Extension Methods Example

In this article i am going to explain about Extension Methods with example. Extension methods enable you to "add" methods to existing types without creating a new derived type, recompiling, or otherwise modifying the original type. Extension methods are a special kind of static method, but they are called as if they were instance methods on the extended type. For client code written in C# and Visual Basic, there is no apparent difference between calling an extension method and the methods that are actually defined in a type. If you do implement extension methods for a given type, remember the following points: An extension method will never be called if it has the same signature as a method defined in the type. Extension methods are brought into scope at the namespace level. For example, if you have multiple static classes that contain extension methods in a single namespace named Extensions, they will all be brought into scope by the using Extensions; directive. ...

CHECK IF FUNCTION EXISTS EXAMPLE

http://css-tricks.com/snippets/javascript/check-if-function-exists-before-calling/ When using scripts that are shared between different areas of a site, there may be cases where a function is called that doesn't exist. It makes sense on one page (the dependency is there) but not another. The difference is too slight to warrant forking the file into different versions. Instead, you can just check if the function exists before calling it to avoid the error: if ( typeof yourFunctionName == 'function' ) { yourFunctionName ( ) ; } jQuery code snippet to check whether a function exists within the JavaScript code. This can be easily achieved by using the jQuery.isFunction() function. Useful for checking if a jQuery function exists before calling it! < script type = "text/javascript" > function somenoobfunction ( ) { } // using jQuery if ( $. isFunction ( wi...

.Net Pickles

Search This Blog