Related resources for SQL Query No resource found - Write And Execute Dynamic SQL Query In SQL Server9/28/2017 11:03:23 AM. This example demonstrates how to write and execute dynamic SQL Query in SQL Server. You can execute the Query using EXEC sql command and sp_executesql commands in SQL Server.
- How To Use The SQL Query In LINQ9/28/2017 11:00:48 AM. Here, you will learn how to use the SQL Query in Linq
- 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews9/19/2017 2:12:56 PM. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
- Azure Cosmos DB With SQL Query Cheat Sheet PDF9/8/2017 2:26:14 PM. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly
- Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” Statement9/4/2017 12:25:58 AM. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
- Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#8/21/2017 4:37:24 PM. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to
- Find The 3rd Or Nth Highest Salary In A Table Via SubQuery8/1/2017 2:03:54 AM. This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the follo
- Finding List Of Database Used By A SharePoint Farm Using SQL Query In Configuration Database5/3/2017 4:29:12 PM. This blog helps to find the list of databases used by a SharePoint Farm, using SQL Query In Configuration database.
- Get Week Start Date & Week End Date Using SQL Server4/9/2017 12:05:15 PM. This blog helps in displaying the start of the week date span and end of the week date span, which will be displayed, using SQLl query.
- Get SQL Query With Already Passed Parameter Value By Executing Stored Procedure4/6/2017 5:31:24 PM. This blog helps in getting full details of SQL query by executing stored procedure, which you mentioned inside stored procedure, using table name and defined parameter value.
- Simple Example Of While Loop With Break And Continue In SQL Query2/20/2017 10:50:53 AM. In this blog, you will learn a simple example of While lop with Break and Continue in SQL query.
- Split Comma Separated List Without Using A Function In SQL Query2/17/2017 10:40:52 AM. In this blog, you will learn about split comma separated list without using a function in SQL query.
- Make Row Values In Comma Separate8/8/2016 6:34:26 PM. In this blog, you will learn, how to make the row value in commas separate from other column data.
- Executing SQL Query in Entity Framework7/24/2016 11:36:54 AM. In this blog, I will explain to you how we can use different types of SQL Query methods.
- List All Tables of Database Using SQL Query6/22/2016 1:01:22 PM. In this blog we will see how to list all tables of a database using SQL Query.
- Dynamic SQL Query Injection And Its Prevention Mechanism6/20/2016 10:23:13 AM. In this article, you will learn about dynamic SQL query injection and its prevention mechanism.
- XML as a Parameter in SQL Query6/10/2016 11:00:52 AM. This blog is to show how to handle XML parameter in a SQL Query.
- SQL Query Plans Each Developer Should Know5/26/2016 12:59:28 PM. In this article you will learn about SQL Query Plans for each Developer.
- Identify a SQL Server Express Instance5/20/2016 12:58:13 PM. In this post we will see how to Identify a SQL Server Express Instance using a SQL query.
- Change SA Login Password Using SQL Query5/2/2016 12:10:36 PM. In this post I will show you how to change SQL Server password using SQL Query.
- How To Optimize SQL Queries4/24/2016 10:04:28 PM. In this article you will learn how to optimize an SQL Query.
- How to Find Current Financial Year using SQL Query4/10/2016 1:17:56 PM. In this blog I will show you how to how to find the current financial year using SQL Query.
- How to Exclude Saturday and Sunday Using SQL Query3/1/2016 9:43:39 AM. In this blog you will learn how to exclude Saturday and Sunday using SQL query.
- SQL Query Time Execute Check12/16/2015 6:32:14 AM. This code snippet is for Sql query max time execute check.
- Displaying Line Numbers In SQL Query Editor12/4/2015 11:34:11 AM. In this article we will discuss about the option of displaying Line Numbers in the SQL Server Query editor.
- Execute Long Running SQL Query Or Stored Procedure From .NET10/21/2015 8:19:13 AM. This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
- Various Approaches to Find Nth Salary in SQL Server 2008R28/28/2015 3:23:25 PM. This article describes various approaches to find the nth salary in SQL Server 2008R2.
- Difference Between ROW_NUMBER () OVER () & PARTITION BY Clause7/29/2015 4:50:14 PM. In this article you will learn the difference between ROW_NUMBER(), OVER() and PARTITION BY clauses in SQL Server.
- Tips to Increase SQL Server Query Performance: Part 26/15/2015 6:49:30 PM. This article provides more tips to increase SQL Server query performance.
- Important Queries in SQL6/8/2015 5:16:56 AM. In this article we learn some interesting and useful SQL queries.
- SQL Server Database Basics Query Command 5/3/2015 1:46:08 PM. This article provides some SQL Server database basic information including database creation, data table creation and basic query information.
- SQL Query Performance - Functions and Indexes4/3/2015 11:29:51 AM. In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
- Get Current Financial Year Using SQL Query2/12/2015 3:39:24 AM. This blog show how to Get Current Financial Year Using SQL Query.
- Get Months Within a Date Range With SQL Query2/11/2015 11:28:25 PM. This article shows how to get the months within a date range with SQL Query.
- Difference between Delete and Truncate in SQL Query12/3/2014 1:25:51 PM. This blog describes the difference between Delete and Truncate in a SQL query.
- Transact SQL Query Performance Tuning Tips9/26/2014 9:15:49 AM. In this article, I will discuss some T-SQL query performance tips and tricks for SQL server programmers. The tips mentioned in this article may sound obvious to most of you, but I have seen professional developers who don't think before using them.
- Query Notification in SQL Server6/11/2014 2:41:46 PM. This article explains QueryNotification and SQLCacheDependency in SQL Server.
- Import Data From Database Using Native SQL Query in Microsoft Excel 20133/15/2014 2:48:46 PM. This article shows the powerful features of Excel 2013 to import data from a database.
- Tools in SQL Server Management Studio3/4/2014 1:00:33 PM. This article shows how to use Tools in SQL Server Management Studio.
- LINQ To SQL2/24/2014 5:45:33 PM. Today in this article I will teach you the most interesting and new features of the C# programming language, LINQ-To-SQL.
- How the SQL Query Executes in a Order1/20/2014 3:11:55 AM. Order of the SQL Query processing phases.
- SQL Query of Weekly Most Requested WebPage in SharePoint 20131/14/2014 5:14:47 AM. This sql query brings the most requested webpages in the SharePoint 2013 portal.
- Inventory Management Using SQL Trigger12/30/2013 9:58:41 PM. In this Article I explain how to create a simple Inventory Management transaction Using Insert, Update and Delete Trigger.
- Query Notification in SQL Server12/12/2013 3:35:57 PM. Thisarticle dscribes Query Notification in SQL Server.
- Publishing MySQL Data With PDO Extension In PHP11/16/2013 8:24:05 PM. This article is explain publishing MySQL data with PDO extension in php.
- SQL Query to Search a Column Name in all Tables 11/14/2013 5:59:37 AM. This query will give you column name in all tables,Sps,etc.
just give your column name in place of employee and see the magic.
- Use of IN in Dynamic SQL Query9/30/2013 4:07:09 AM. Use of “IN” in dynamic SQL query.
- SQL Query to Find Required Indexes and Unused Indexes9/23/2013 4:27:22 AM. Find required indexes and unused indexes in a sql server table.
- SQL Query to Get Backup Details in SharePoint9/13/2013 12:30:18 AM. This SQL query gives you the details of when was the last backup of a SharePoint SQL database was taken.
- SQL Query to Get Number of Active Connections9/13/2013 12:23:40 AM. The following query gets number of active SQL Connections.
- SQL Query to Get Details of Index Fragmentation in SharePoint7/26/2013 2:07:37 AM. This article explains how to get the details of index fragmentation in SharePoint and provides a script that can be used to rebuild and reorganize indexes.
- SharePoint SQL Query to Get Details on Disk Utilization and IO7/24/2013 2:34:55 PM. In this article I will demonstrate SharePoint SQL Query to get details of Disk Utilization and IO.
- Some Important Tips For SQL Query Performane7/1/2013 1:13:56 PM. This article provides some important tips for SQL Query Performane.
- Searching, Sorting and Paging Using SQL Query6/25/2013 4:41:14 PM. This article shows how to use a SQL query to perform searching, sorting and paging by one query.
- Finding Duplicates Among Multiple Columns in SQL5/15/2013 1:12:05 PM. Here I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.
- MySQL Fetch Array Function in PHP5/11/2013 5:07:57 PM. In this article I explain the "MySQL_Fetch_Array()" function in PHP.
- DATABASEPROPERTYEX Function in SQL Server5/1/2013 5:16:35 PM. In this article, I would like to show how to extract the metadata about a database in SQL Server.
- Working With Date and Time in SQL Server and C#4/11/2013 3:29:24 PM. In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.
- Getting the Name of the Server and Databases in SQL Server3/19/2013 1:27:58 PM. In this article, I would like to show how to get the name of the server and databases in SQL Server.
- Getting Some Useful Date and Time Information From Getdate Function in SQL Server 20123/6/2013 4:10:55 PM. In this article, I would like to show the utility of Getdate functions in SQL Server.
- Insert and Update Stored Proc With Raw SQL Query Via EDF Framework12/31/2012 4:49:04 PM. Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
- Delete and Update Data With Raw SQL Query Via EDF Framework12/31/2012 4:33:20 PM. Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
- Select Data with Raw SQL Query via EDF Framework12/31/2012 4:20:24 AM. Today, in this blog let's play around with one of the interesting and most useful concept in EDM Framework.
- Select Stored Proc With Raw SQL Query Via EDF Framework12/31/2012 12:28:56 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
- Insert Data With Raw SQL Query Via EDF Framework12/31/2012 12:27:14 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
- Delete Stored Proc With Raw SQL Query Via EDF Framework12/29/2012 12:40:30 PM. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
- Calculating Factorial of a Number in SQL Server 201212/3/2012 12:48:17 PM. Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.
- Count(All) vs Count(Distinct) in SQL Server 201212/1/2012 3:52:42 PM. In this article, you will see the SQL aggregate function count in two forms, Count(All) and Count(Distinct).
- On vs Where Clause in SQL Server 201211/29/2012 2:14:54 PM. Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
- Find Nth Highest Salary in SQL Server11/6/2012 4:49:33 PM. In this article I am explaining various ways to get the Nth highest salary from an EMPLOYEE table.
- SQL Query to find out the frequency of each element in a column 10/17/2012 11:02:02 AM. This blog explain how we can get the frequency distribution of each element in a column using SQL.
- Using LINQ to SQL Query9/30/2012 3:08:05 AM. Here in this article, you will get very basic idea of LINQ to SQL Query using code.
- Executing SQL Query Using LINQ to SQL9/30/2012 2:21:00 AM. In this article, I will discuss how we can execute a SQL Query directly from LINQ.
- Modifying a Database Checkpoint in QTP in Testing8/21/2012 4:12:26 PM. In this article we discuss how to modify a Database Checkpoint in QTP.
- Delete Files with a SQL Job in SQL Server 20088/8/2012 12:28:37 AM. Here I am going to discuss deleting files using SQL Job.
- Conversion Functions Using SQL Query in SQL Server7/2/2012 2:22:09 AM. In this article you will see how to use conversion functions using SQL Query in SQL Server.
- Get am/pm from datetime in sql query5/24/2012 6:25:54 AM. Get time format of datetime in sql.
- SQL Query Optimization FAQ Part 1 (With video explanation)5/20/2012 4:20:41 AM. In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
- Database Objects Information Using SQL Query in SQL Server4/22/2012 12:34:18 PM. In this article we will see how to get the Database objects Information using a query.
- SQL query to fetch all schema/table names and row/column count inside a database11/11/2011 10:20:37 AM. SQL query to fetch all schema/table names and row/column count inside a database.
- Paging Using Sql Query In Gridview,Repeater 10/11/2011 5:56:06 AM. Without Using Paging in Asp.net
- Using Temp Table in SQL Server And Adding Columns Dynamically7/16/2011 12:26:04 PM. In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dynamically.
- Dynamic Query to Search by Column Value in All Referencing Tables in SQL SERVER7/12/2011 12:30:36 PM. In this article I'll show you how to search a column value in all the referencing tables.
- LINQ to SQL Stored Procedure7/1/2011 3:19:16 AM. In this Video you will see how to use LINQ to SQL Stored Procedure.
- SQL Server Transact Basic to Expert - Concantenate Integer and string in SQL Query6/16/2011 9:18:48 AM. SQL Server Transact Basic to Expert - Concantenate Integer and string in SQL Query
- SQL Server Transact Basic to Expert - Decreasing a date and time by 30 Mins using SQL query6/16/2011 9:00:29 AM. SQL Server Transact Basic to Expert - Decreasing a date and time by 30 Mins using SQL query
- SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query6/16/2011 8:56:17 AM. SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query
- Using Query Batch in T-SQL4/4/2011 7:44:02 AM. Query Batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution
- Date formatting in SQL query10/4/2010 6:36:43 AM. Date formatting in SQL query
- Cumulative sum in sql query8/19/2010 12:12:39 PM. here i will show you how you can calculate cumulative sum
- How to print long string in SQL5/23/2007 6:25:55 AM. This article shows how to print the long string of sql query inside a procedure.
- Transact-SQL Query Performance Tuning Tips5/4/2007 12:10:09 AM. In this article, I will discuss some T-SQL query performance tips and tricks for SQL server programmers. The tips mentioned in this article may sound obvious to most of you, but I have seen professional developers who don't think before using them.
- Add, Update, and Delete using ADO3/9/2006 6:59:26 AM. In this example, I am using mcb.krz database which is an access database. The table I do have in example is 'Access' that has two fields, i.e., Name and HTML, both are Text type fields. Microsoft.Jet.OLEDB.3.51 is OLE_DB provider for MS Access. To use ADO, you must have OLE-DB provider for that database.
- Alter an Existing Database Table2/21/2006 11:44:50 PM. This article explains how to alter an existing Database table.There are some occasions when you need to change your database schema at runtime.
- Add, update, delete data using SQL query2/18/2006 12:10:45 AM. This article explains how to access the sql database i.e, adding, deleting and updating the sql database.Database manipulations are performed by using sql query.
- Accessing Excel Database using ADO.NET1/30/2006 4:28:13 AM. This simple program shows how access an access database using ADO.NET. It opens a database mcTest.mdb from your application directory.
- Using SQL Queries in ADO.NET1/30/2006 3:48:55 AM. In this article, I will show you how to execute SQL queries from your VB.NET applications.
- SQL Server Database Explorer12/16/2005 5:18:36 AM. This application connects to a running SQL Server 2000 and displays all the available databases in it.
- TRY...CATCH Keyword in Yukon7/8/2005 1:39:07 PM. This article provides information about the TRY...CATCH keyword that is added to T-SQL in the latest release of SQL Server Yukon.
- Delete Sql Query3/11/2005 1:43:00 AM. This article belongs to DELETE statement, which is used to delete rows in a table.
