How to create table in sqlite data base programmatically in iPhone
How to create table in sqlite data base programmatically in iPhone The database that can be used by apps in iOS (and also used by iOS) is called SQLite, and it’s a relational database. It is contained in a C-library that is embedded to the app…
How to Create Table in Sql Server ?
Tables are used to store data in the database. Tables are uniquely named within a database and schema. Each table contains one or more columns. And each column has an associated data type that defines the kind of data it can store e.g., numbers, strings,…
How to Generate SHA1 Cryptography in C# and VB.Net
Generate SHA1 Cryptography This part has been copied directly from Wikipedia SHA-1 is a cryptographic hash function designed by the United States National Security Agency and published by the United States NIST as a U.S. Federal Information Processing…
How to INSERT data from Stored Procedure to Table ?
How to INSERT data from Stored Procedure to Table ? CREATE PROCEDURE GetDBNames AS SELECT name, database_id FROM sys.databases GO We can execute this stored procedure using the following script. EXEC GetDBNames Now let us see two different scenarios…
How to Add Identity Column to Table Based on Order of Another Column
How to Add Identity Column to Table Based on Order of Another Column USE tempdb GO -- Create Table CREATE TABLE TestTable (Col1 INT, Col2 VARCHAR(100)) GO -- Insert Data INSERT INTO TestTable (Col1, Col2) VALUES (33, 'Ranjan'); INSERT INTO TestTable…
How to puzzle SET ANSI_NULLS and resultset in sqlserver
How to puzzle SET ANSI_NULLS and resultset in sqlserver When ANSI_NULLS is OFF, the Equals (=) and Not Equal To (<>) comparison operators do not follow the ISO standard. A SELECT statement that uses WHERE column_name = NULL returns the rows that…
How to update specific column in entire database using SQL
How to update specific column in entire database using SQL The UPDATE statement changes existing data in one or more rows in a table. The following illustrates the syntax of the UPDATE statement: UPDATE table SET column1 = new_value1, column2 =…
How to start Sqlserver from Command prompt
Instance of SQL Server 2012 and here is what we would in the configuration manager. Now, I would go ahead and stop SQL Service by selecting SQL Server (MSSQLServer) > Right Click > Stop. There are multiple ways to start SQL with startup parameter.…
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…
iphone Interview Questions part-13
141-Helper Objects Helper Objects are used throughout Cocoa and CocoaTouch, and usually take the form of a delegate or dataSource. They are commonly used to add functionality to an existing class without having to subclass it. 142-Cluster Class Class…
iphone Interview Questions part-12
121- Formal vs informal protocol. In addition to formal protocols, you can also define an informal protocol by grouping the methods in a category declaration: @interface NSObject (MyProtocol) //someMethod(); @end Informal protocols are typically declared…