How to renaming a sqlite table programatically in iphone?
How to renaming a sqlite table programatically in iphone? SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table, to rename a column within a table, or to add a new column to an existing…
How to create sqlite database programmatically?
How to create sqlite database programmatically? SQLite isn’t the only way to persist data on iOS. Besides Core Data, there are lots of other alternatives for data persistence, including Realm, Couchbase Lite, Firebase, and NSCoding. SQLite does have some…
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.…