SqlQueries

SQL Query To Drop a Table in SQL Server

2009-06-26T05:52:00.000-07:00

Sql Server Faqs
Check this post for SQL Query to Return Information About all Databases in SQL Server

SQL Query To Drop a Table in SQL Server.

syntax:Drop Table Tablename

ex:DROP TABLE Emp

Above Query Drops Emp table in the current database.

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Return Information about a single database

2009-05-06T07:47:00.000-07:00

Sql Server Faqs

Check this post for SQL Query to Return Information About all Databases in SQL Server

SQL Query to Return Information about a single database

Syntax:exec sp_helpdb databasename

ex:exec sp_helpdb lakshmi

SQL Query to Return Information About all Databases in SQLServer

2009-04-23T07:50:00.000-07:00

Check this post for sqlserver faqs

SQL Query to Return Information About all Databases in SQL Server

exec sp_helpdb

Check here for SQL Query to delete multiple databases in sqlserver
SQL Query to rename database in sqlserver.
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Delete Multiple Databases in SQL Server-SQL Queries

2009-04-13T06:16:00.000-07:00

Check This Post for sql query to delete single database in sql server

SQL Query to drop multiple databases in sqlserver.

Syntax:DROP DATABASE databasename1, databasename2

Example:Drop Database Lakshmi1,Lakshmi2

Check This SQL Query to Rename Database
Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.
Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Delete Database in Sql Server-SQL Queries in SQLServer

2009-04-05T21:49:00.000-07:00

Check this post for SqlServer Faqs

SQL Query to Drop Database in Sql Server

Syntax:DROP DATABASE databasename

Example:drop database lakshmi

Check This SQL Query to Rename Database

Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.
Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Rename Database in SQL Server

2009-04-01T23:45:00.000-07:00

SQL Query to rename database.

Syntax: sp_renamedb 'olddatabasename','newdatabasename'

Example: sp_renamedb 'Lakshmi','Laxmi'

Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.
Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.

2009-02-16T11:05:00.000-08:00

sql query to get min sal from emp table

Check this post to find 2nd and 3rd Highest salary

sql query to get least salary from emp table

Syntax:select min(columnname)as MIN_SAL from tablename

Ex:select min(sal)as MIN_SAL from emp

Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query To Find Maximum Salary From Emp Table in SQLSERVER.

2009-02-05T02:39:00.000-08:00

Check here to find 2nd and 3rd Highest salary

sql query to get first highest salary from emp table

Syntax:select max(columnname)as MAX_SAL from tablename

Ex:select max(sal)as MAX_SAL from emp

Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

Sql Query to Retrieve Nth Highest Salary From Table in SQL Server

2009-01-30T02:39:00.000-08:00

SQL Server Faqs

SQL Query to find Nth Highest Salary in SQL Server.

SELECT * FROM tablename e1 WHERE N = (SELECT COUNT(DISTINCT (e2.sal))
FROM tablename e2 WHERE e2.sal >= e1.sal)

For example to get 3rd highest salary:
SELECT * FROM emp e1 WHERE 3 = (SELECT COUNT(DISTINCT (e2.sal))FROM emp e2 WHERE e2.sal >= e1.sal)

Similarly to get 2nd highest salary:
SELECT * FROM emp e1 WHERE 2 = (SELECT COUNT(DISTINCT (e2.sal))FROM emp e2 WHERE e2.sal >= e1.sal)

SQL Server Faqs
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

How to Retrieve a Random Record from a Table in SqlServer

2009-01-06T07:20:00.000-08:00

SQL Query to display a random record from table in sqlserver.

Syntax:Select Top 1 * From tablename Order By NewId()

Example:Select Top 1 * From emp Order By NewId()

Above query will display one random record.

SQL Query to copy structure and data of one table to other in Sql Server.

Software Testing-QTP,Testing Tools,Testing Faqs

Collection of SQL Queries

SQL Query to Copy Structure and Data of One table To Other in SQLServer

2008-12-29T20:47:00.000-08:00

How to copy structure and data of one table into another table?

Syntax: Select * into Newtable from Oldtable

Ex: select * into emp1 from emp

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

How to Copy Structure of One Table into Another Table?

2008-12-26T05:45:00.000-08:00

SQL Query to copy structure of one table to another table in SQL Server.

Syntax: Select * into Newtable from Oldtable where 1=2

Ex: Select * into emp1 from emp where 1=2

The above query copies only structure(not data) of emp to emp1.

SQL Query to get structure of table

How To Get Structure of a Table in SQL Server?

2008-12-23T02:38:00.000-08:00

SQL Query to view structure of a table in sqlserver.

SP_help tablename

SP_help emp

SQL Query to find total number of rows in a table

2008-12-15T03:40:00.000-08:00

Query to get number of rows in a table.

select count(*) from tablename

ex:select count(*) as Count from emp

Output

Count
10

SQL Server Faqs
Movie Songs Lyrics
SOftware Testing -QTP Scripts,Testing Faqs

SQL Query to Rename Column Name in SQL Server-Query to change Column Name in SQL SERVER

2008-11-20T11:09:00.000-08:00

Query to change Column Name in SQL SERVER

sp_rename 'Tablename.old fieldname', 'new field name'

sp_rename 'xyz.aaa','bbb'

sql query for second highest salary in oracle

2008-04-29T12:41:00.000-07:00

select *from emp a where 2=(select count (distinct(b.sal))from emp b where a.sal<=b.sal);

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7788 SCOTT ANALYST 7566 19-APR-87 3000 20

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

Sql query for top 5 records in oracle

2008-04-29T12:37:00.000-07:00

select*from emp where rownum<=5;

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

Query to add years to particular date

2008-03-25T22:07:00.001-07:00

Query to add years to particular date
select dateadd(year,noofyears to be added,datecolumndate)yearadd from tablename

Query to add years to particular date

2008-03-25T22:07:00.000-07:00

Query to add years to particular date
select dateadd(year,noofyears to be added,datecolumndate)yearadd from tablename

Query to add months to particular date

2008-03-25T22:06:00.002-07:00

Query to add months to particular date
select dateadd(month,noofmonths to be added,datecolumndate)monthadd from tablename

Query to add days to particular date

2008-03-25T22:06:00.001-07:00

Query to add days to particular date
select dateadd(day,noofdays to be added,datecolumnname)dayadd from tablename

Query to get only year from particular date

2008-03-25T22:04:00.002-07:00

Query to get only year from particular date
select year(datecolumnname)as year from tablename

Query to get only month from particular date

2008-03-25T22:04:00.001-07:00

Query to get only month from particular date
select month(datecolumnname)as month from tablename

Query to get only day from particualar date

2008-03-25T22:02:00.000-07:00

Query to get only day from particualar date
select day(datecolumnname)as day from tablename

Query to get only date from datetime field

2008-03-25T22:01:00.000-07:00

Query to get only date from datetime field
select convert(varchar,datecolumnname,110) from tablename