Querying searching Pattern Ranges and Wild Cards in sqlserver
Querying Pattern Ranges The % wildcard character represents any number of characters of any length. Let’s find all first names that end in the letter ‘A’. By using the percentage ‘%’ sign with the letter ‘A’, we achieve this goal using the code…
Using the Kindle App for iPhone and iPod Touch
Using the Kindle App for iPhone and iPod Touch A number of e-reader applications are available for the iPhone and iPod Touch, but the big advantage of the Kindle application is its ability to synchronize your Kindle with the iPhone or iPod Touch…
How to add watermark to an image in c#
watermark to an image using System; using System.Drawing; using System.Drawing.Drawing2D; public class Watermark { //this fuction takes an Image and String for watermarking as argument //and returns an Image with watermark public Bitmap…
Dictionary, How to read-write data in using C# and VB.net
What is Dictionaries ? Dictionary is a collection object which is used to store data in key and value pairs. In this, object Key values must be always unique and it won’t accept any null or duplicate values because we use keys to identify values stored…
OFFSET and FETCH NEXT ROWS in SQL Server 2012?
OFFSET provides a starting row from which SQL Server needs to start fetching rows and FETCH provides the number of rows we want to fetch from the result set (or in a query). OFFSET and FETCH can be used only with an order by clause. Offset row count: It…
Generate New GUID (uniqueidentifier) in SQL Server
What is new GUID? The New-GUID cmdlet creates a random globally unique identifier (GUID). If you need a unique ID in a script, you can create a GUID, as needed. What is Uniqueidentifier datatype in SQL Server? The globally unique identifier (GUID) data…
Top New Features in Visual Studio 2012
1-Opening VS2010 Projects and Not Breaking Things Remember when VS2010 came out? Remember wanting to use it on your team? Remember how projects were incompatible so you had to wait forer the whole team to upgrade? Yea, that sucked. Oh wait. Remember…
Top 5 new features of Visual Studio 2010 and .NET 4
There lots of improvement in Visual Studio 2010 over past version. Below are some new great features of Visual Studio 2010 – Better code intellisense Visual Studio 2010 has better code intellisense support which make it easier for look for methods…
How to create printer friendly web page using javascript
When you create a web page you usually keep in mind how it will rendered on the browser and its usability. Sometime, depending upon the content, you also know that your page might be printed by end user. User will click specially open the printable…
iphone Interview Questions part-14
151-Types of NSTableView Cell based and View based. In view based we can put multiple objects. 152-Abstract class in cocoa. Cocoa doesn’t provide anything called abstract. We can create a class abstract which gets check only at runtime, compile time this…