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,…
Tag: SQL
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 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…
Tips to protect your site from hackers
Keep software up to date It may seem obvious, but ensuring you keep all software up to date is vital in keeping your site secure. This applies to both the…
How to prevent SQL Injection in iOS apps?
Application Security is a primary concern of every mobile application developer whether it is iPhone app, iPad app, Universal app in iOS, Android app, Blackberry app, Windows Phone app or…
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)…
How to puzzle SET ANSI_NULLS and resultset in sqlserver
SET ANSI_NULLS ON; — Query1 SELECT ‘SQLAuthority’ AS Statement11 WHERE ‘Authority’ IN (‘m’,’y’, ‘c’, ‘tips’, NULL); — Query 2 SELECT ‘SQLAuthority’ AS Statement12 WHERE ‘Authority’ NOT IN (‘S’,’Q’, ‘L’,…
How to update specific column in entire database using SQL
Using INFORMATION_SCHEMA SELECT ‘UPDATE ‘ + T.TABLE_SCHEMA + ‘.’ + T.TABLE_NAME + ‘ SET ModifiedDate = GETDATE() WHERE ModifiedDate IS NULL;’ FROM INFORMATION_SCHEMA.TABLES T INNER JOIN INFORMATION_SCHEMA.COLUMNS C ON T.TABLE_NAME =…
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) >…
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…