Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Queries


Search:
What's New - What's Hot
jQuery Change the Text Size (zoom in and out)  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: shinuraj      Rating:  
Read Reviews | Write Review |  Your Rating: 

Try it out the text resize functionality using jQuery.

Add this code in the head section:...

SqlDependency based caching of LINQ Queries  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: rusanu      Rating:  
Read Reviews | Write Review |  Your Rating: 

Query Notifications is the SQL Server feature that allows a client to subscribe to notifications that are sent when data in the database changes irrelevant of how that change occurs. I have talked before about how Query Notifications works in the article The Mysterious Notification. This feature was designed specifically for client side cache invalidation: the applications runs a query, gets back the result and stores it in the cache. Whenever the result is changed because data was updated, the ...

Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: AnupKumarYadav      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are now and then faced with the problem with storing data corresponding to Binary Tree and querying it. We generally rely on Recursion (hence costly ) to query tree structure. Here is a simple data structure change in order query tree structure using simple SQL statement - No Recursion required....

Linq queries for beginners  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Ravi Panara      Rating:  
Read Reviews | Write Review |  Your Rating: 

Following are some of the basic Linq command/samples for those who just want to start learning Linq. So this will help a lot to all the beginners to easily understand Linq queries....

Sortable interaction in JQuery UI  Version: 0.00     Price: $0.00  
Total Hits: 31  |  Today: 0Author: Sateesh Arveti      Rating:  
Read Reviews | Write Review |  Your Rating: 

In previous article, we looked into selectable interaction. In this article, we will cover sortable interaction. This interaction will allows us to sort a group of DOM elements. We can drag an element in the sortable group to new location and other elements will get auto adjust to fit in the group. Sortable items share properties of draggable. We can define callbacks on element's sorting start, in progress and stop....

Implementing Effects in JQuery  Version: 0.00     Price: $0.00  
Total Hits: 27  |  Today: 0Author: Sateesh Arveti      Rating:  
Read Reviews | Write Review |  Your Rating: 

In previous article, we looked into events of JQuery. In this article, we will cover Effects and its implementation. JQuery provides lot of effects to improve the look and feel of the page. It supports fade in, fade out, slide etc. JQuery provide built-in functions to support these effects....

Some internal SQL Sever Queries  Version: 0.00     Price: $0.00  
Total Hits: 80  |  Today: 0Author: Gaurav Dudeja India      Rating:  
Read Reviews | Write Review |  Your Rating: 

The following query uses the sys.objects catalog view to return all database objects that have been modified in the last 10 days....

How to: Edit TableAdapter Queries  Version: 0.00     Price: $0.00  
Total Hits: 22  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

You edit TableAdapter queries with the TableAdapter Query Configuration Wizard in the Dataset Designer. You should modify a TableAdapter query when it no longer suits the needs of your application. (Alternatively, you can create additional queries on the TableAdapter. For more information on adding new queries, see How to: Create TableAdapter Queries.)...

Row Numbers in SQL Query (Microsoft SQL Server 2000 and 2005)  Version: 0.00     Price: $0.00  
Total Hits: 20  |  Today: 0Author: P. Ganesh Kumar      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sometimes we may need to assign row numbers in the returned result of an SQL query. Since Microsoft SQL server 2000 doesn't support row number function, it has to be achieved through the introduction of IDENTITY column when we use ‘into’ clause in the select statement. The temp table can be populated first. Finally, the temp table can be used to fetch the rows along with the field row number....

An Oracle Query Tool (part 1)  Version: 0.00     Price: $0.00  
Total Hits: 23  |  Today: 0Author: Danilo Corallo      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is a small tool for creating and executing queries. The main purpose of this article is to create an Oracle query tool with syntax coloring. This article is written using the Visual Basic 2005 Express Edition, and requires Microsoft NET Framework v2.0 to run....

Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008     
Total Hits: 127  |  Today: 0Author: Michelle Gutzait      Rating:  
Read Reviews | Write Review |  Your Rating: 

I need to query a large amount of data to my application window and use paging to view it. The query itself takes a long time to process and I do not want to repeat it every time I have to fetch a page. Also, the number of rows in the result set could be huge, so I am often fetching a page from the end of the result set. I can't use the default paging because I wait a long time until I get the data back. What are my options?...

Simple Query Tool to Extract Data from Database     
Total Hits: 187  |  Today: 0Author: Mohammad Hamed Akhter      Rating:  
Read Reviews | Write Review |  Your Rating: 

The are various ways to design a UI that helps users to extract specific information from the database. This tool whose UI design is similar to the queries windows in TFS helps users to extract specific data by helping the user to create or form a query. This idea is similar to the query tools available in SQL server and TFS, but it is customized to the user's needs....

Specifying Max Degree of Parallelism in SQL Server for a Query     
Total Hits: 190  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Max Degree of Parallelism or MAXDOP is a configuration indicating how the SQL Server optimizer will use the CPUs. This is a server wide configuration that by default uses all of the CPUs to have the available portions of the query executed in parallel. MAXDOP is very beneficial in a number of circumstances, but what if you have a reporting like query that runs in an OLTP system that monopolizes much of the CPU and adversely affects typical OLTP transactions. How can you scale back the CPU...

Writing SQL Queries: Let's Start with the Basics     
Total Hits: 117  |  Today: 0Author: Jackie Goldstein      Rating:  
Read Reviews | Write Review |  Your Rating: 

With the availability of ever more powerful programming tools and environments such as Visual Basic and Visual Studio.NET, as well as the availability of powerful database engines such as the free SQL Server 2005 Express Edition, more and more people find themselves having to learn the basics of SQL queries and statements. Sometimes they are professional developers who are experienced in other types of programming, and sometimes they are individuals whose expertise lies in other areas, but they ...

Introduction to XQuery in SQL Server 2005     
Total Hits: 100  |  Today: 0Author: Prasadarao K. Vithanala      Rating:  
Read Reviews | Write Review |  Your Rating: 

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful....

A Close Look at the SQL Query     
Total Hits: 205  |  Today: 0Author: O'Reilly Media      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you want to get a better understanding of the SQL query, you've come to the right place. This article is excerpted from chapter four of The Art of SQL, written by Stephane Faroult and Peter Robson (O'Reilly; ISBN: 0596008945). Copyright © 2006 O'Reilly Media, Inc. All rights reserved. Used with permission from the publisher. Available from booksellers or direct from O'Reilly Media....

Using Parameterized Queries with the SqlDataSource     
Total Hits: 197  |  Today: 0Author: Scott Mitchell      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the previous tutorial we saw how to use the SqlDataSource control to retrieve data directly from a database. Using the Configure Data Source wizard, we could choose the database and then either: pick the columns to return from a table or view; enter a custom SQL statement; or use a stored procedure. Whether selecting columns from a table or view or entering a custom SQL statement, the SqlDataSource control’s SelectCommand property is assigned the resulting ad-hoc SQL SELECT statement and it i...

QuickQuery - a database querying tool     
Total Hits: 128  |  Today: 0Author: BlackDice.      Rating:  
Read Reviews | Write Review |  Your Rating: 

QuickQuery is the second program I wrote on my own in C++, just to experiment. It was an attempt to make an app that could run queries on any type of database. This code was written using VC6 and has been run on Windows 2000 and XP....

Keyword search using a tally or sequence table     
Total Hits: 859  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Ryan writes "I am looking for a way of creating a stored procedure that will carry out a keyword search without building up the SQL dynamically in the stored procedure. What I'm after is a method of doing this that doesn't require me to build up a huge string."...

Microsoft Message Queuing – Log Trade information using Microsoft SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Espen Harlinn      Rating:  
Read Reviews | Write Review |  Your Rating: 

My previous article, Microsoft Message Queuing – A simple multithreaded client and server, shows how to easily create a simple Microsoft Message Queue based solution.

My motivation for writing that article was to show how easy it can be done in response to a question posted over in the CodeProject Q&A section. I’ll admit that I was a bit surprised when it turned out that the poster still couldn’t get his solution to work.

Turns out that he was working on a solution for logging trad...


1  2  3  4  5  6  7  8  9  10  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net