Pages - Menu

▼
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, 16 August 2019

Rebuild vs Reorganize

›
Rebuild: An index ‘rebuild’ creates a fresh, sparkling new structure for the index. If the index is disabled, rebuilding brings it back t...
Tuesday, 9 April 2013

Cast and Convert

›
1.CAST and CONVERT are two SQL functions used by programmers to convert one data type to another. 2.The CAST function is ANSI standard a...
Friday, 5 April 2013

nth highest salary in sql server

›
SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary FROM employee ORDER BY salary DESC) a ORDER BY salary
Monday, 24 December 2012

Difference between beginexecutereader and executereader (beginexecutereader Vs executereader)

›
The BeginExecuteReader(...) and EndExecuteReader...() are for performing the ExecuteReader(...) method asynchronously. If you use Execute...
Wednesday, 5 December 2012

Difference between Correlated subquery and Nested subquery

›
Correlated subquery Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value  from th...
Monday, 1 October 2012

Difference between Where and Having clauses

›
The WHERE clause selects rows before grouping. The HAVING clause selects rows after grouping. The WHERE clause cannot contain aggregate f...
Friday, 17 August 2012

ISNULL Vs NULLIF

›
ISNULL: ISNULL ( expression , replacement) Replaces NULL with the specified replacement value. It returns the value of expression if it i...
Wednesday, 30 May 2012

Update sql server from excel

›
update tablename set column=t2.column1 from ( Select ID,column1,column2  FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel...

Import excel data in sql server 2005

›
Run the below Query in Sql Server query window Select * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:...
Monday, 21 May 2012

Permission for MYSQL'S user on particular IP

›
Permission for MYSQL'S user on particular IP. Run the below query : Root=user IP=IP address mysql=Password GRANT ALL PRIVILEGES O...

Create MYSQL users with privileges

›
Create MYSQL users with privileges INSERT INTO user VALUES('localhost','user',PASSWORD('some_pass'),'Y',...
Monday, 30 April 2012

Retrieve Mysql users list and its privilege

›
Run the below query through command prompt of my-sql select * from mysql.user\G;
Friday, 16 March 2012

MySQL error 1236:MySQL replication problem

›
Reasons: the master’s binary log is corrupted, a network problem, or a bug in the master’s or slave’s MySQL code. If you want to check the...
Wednesday, 29 February 2012

Rows count for all tables

›
Use below query for table name with rows count for specific database. SELECT     [TableName] = so.name,     [RowCount] = MAX(si.rows) ...

Column data in to single row with comma seperated

›
Below SQl statement is used for convert single column data in a single row. declare @testdata varchar(8000) set @testdata='' s...
Tuesday, 28 February 2012

Tablespace in sql server

›
we can check used space by a table with below sql-statement in which table name will be passed with sp_spaceused. sp_spaceus​ed 'Table...
Saturday, 11 February 2012

Disable Trigger in SQL-Server

›
The syntax for disable trigger is: DISABLE TRIGGER triggerName ON TableName
Wednesday, 8 February 2012

Odd / Even rows in SQL Server

›
For get even rows: select * from table_1 where id%2=0 For get odd rows select * from table_1 where id%2<>0 Note: Here table_...

Last Run Query in SQL Server

›
Query: SELECT conn.session_id, sson.host_name, sson.login_name,  sqltxt.text, sson.login_time,  sson.status FROM sys.dm_exec_connections...

@@rowcount in SQL Server

›
@@rowcount: Returns the number of rows affected by the last statement. Example: print @@rowcount--It will return 0 select top 10 * f...