Database Viewer and reporter (Access Viewer) provide you facility to explorer Access 2003,2007 and XML database. With this you could explorer these databases even if...
Their are many approaches to get alternate record from SQL server database table. Here i have discussed 2 approaches1. Complex Query2. Using Views Complex Query: SELECT...
Union is to select all records from two table but common record only once. Select * from tbemp1UNIONSelect * from tbemp2 Inersect is to select common records...
Read complete article
SQL XML: You can generate XML from SQL queries without even doing single line of code in your programming language. Below is the script used...
Three basic rules only. Where you can place sub query?3 places where you can place your sub query:SELECT —– FROMFROM —– WHEREWHERE —–> SELECT...
What View do ?• First, It help you break down complex queries.• Secong, Query reusability.• Third, Security.(not fully recommendable) What is View ?View is just...
SQL (Structured Query Language) It is high level language which provide you capability to query data from any structured data source (Tables). High level language...
Finding expensive queries can be challenging on SQL Server, this tutorial will help you in finding expensive queries on production. Using below DMVs: SYS.DM_EXEC_QUERY_STATS SYS.DM_EXEC_SQL_TEXT...