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…