The sql query becomes faster if you use the actual columns names in SELECT statement instead of than ‘*’. For Example: Write the query as SELECT id, first_name, last_name, age,…
Category: Database
Tips for Database ConnectionStrings of Various Provider
Microsoft SQL Server // ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = “Dsn=DsnName;” + “Uid=UserName;” + “Pwd=Secret;”; conn.Open(); // ODBC — Trusted Connection using System.Data.Odbc; OdbcConnection conn…
Tips for beginner programming mistakes
Fear and lack of self-confidence The number one mistake you can make as a beginner programmer is to think you’re not good enough, not smart enough: that you have the…
Tips for performance tuning of databases
Database statistics The most important resource to any SQL optimizer is the statistics collected for different tables within the catalog. Statistics is the information about indexes and their distribution with…
How to Check your browser supports IndexedDB or not .
The very first thing we should do is check for IndexedDB support. While there are tools out there that provide generic ways to check for browser features, we can make…
What is IndexedDB in HTML5 ?
IndexedDB provides a way for you to store large amounts of data on your user’s browser. Any application that needs to send a lot of data over the wire could…
Creating Simple Event with MySQL
Creating a First Event Creating an Event is somewhat like creating stored procedure or user defined function in MySQL. You will have DELIMITER, BEGIN, DO and END keywords. As mentioned…
How to renaming a sqlite table programatically in iphone?
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
NSString *querystring ="ALTER TABLE GlossaryRelation_Temp RENAME TO GlossaryRelation "; [self updateStatus:querystring]; -(void)updateStatus:(NSString *)queryString { NSString *docsDir; NSArray *dirPaths; dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); docsDir = [dirPaths objectAtIndex:0]; strDatabasePath = [NSString stringWithString:[docsDir stringByAppendingPathComponent:database name]]; NSFileManager *filemgr = [NSFileManager defaultManager]; if ([filemgr fileExistsAtPath: strDatabasePath] == YES) { const char *dbpath = [strDatabasePath UTF8String]; if (sqlite3_open(dbpath, &sqlDatabase) == SQLITE_OK) { const char* beginString = "BEGIN;"; sqlite3_stmt *compiledstatement; sqlite3_prepare_v2(sqlDatabase, beginString, -1, &compiledstatement, NULL); if (sqlite3_step(compiledstatement) == SQLITE_DONE) {} else NSLog(@"Failed!"); sqlite3_finalize(compiledstatement); NSLog(@"QUERY : %@",queryString); const char *selectStatement = [queryString UTF8String]; sqlite3_prepare_v2(sqlDatabase, selectStatement, -1, &compiledstatement, NULL); if (sqlite3_step(compiledstatement) == SQLITE_DONE) {} else NSLog(@"Failed!"); sqlite3_finalize(compiledstatement); const char* endString="END;"; sqlite3_prepare_v2(sqlDatabase, endString, -1, &compiledstatement, NULL); if (sqlite3_step(compiledstatement) == SQLITE_DONE) {} else NSLog(@"Failed!"); sqlite3_finalize(compiledstatement); sqlite3_close(sqlDatabase); } else NSLog(@"Failed to open table"); } } @end |
How to create sqlite database programmatically?
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
-(void)createDatabase { NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); NSString *documentsDirectory = [paths objectAtIndex:0]; databasePath = [[NSString alloc]initWithString:[documentsDirectory stringByAppendingPathComponent:@"timings.db"]]; if ([[NSFileManager defaultManager] fileExistsAtPath:databasePath] == FALSE) { if (sqlite3_open([databasePath UTF8String], &timingsDatabase) == SQLITE_OK) { const char *sqlStatement = "CREATE TABLE IF NOT EXISTS TIMINGS (ID INTEGER PRIMARY KEY AUTOINCREMENT, TIMESTAMP TEXT, TIMING TEXT)"; char *error; sqlite3_exec(timingsDatabase, sqlStatement, NULL, NULL, &error); sqlite3_close(timingsDatabase); } } } |
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 (Col1, Col2)…