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

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

What's New - What's Hot
SQL User Defined Function to Parse a Delimited String  Version: 0.00     Price: $0.00  
Total Hits: 25  |  Today: 0Author: Claytong      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of the challenges that always comes up when dealing with data captured from web sites is parsing multi-value fields. Many web forms have "check all that apply" checkbox forms, and the data from questions of this type is often logged as a single delimited field value.

For example, the index values from a block of check boxes may be logged to a text file or returned to the database as a string of delimited numbers: '1|3|6|11'...

SQL 2005 Time Zone Conversion Functions  Version: 0.00     Price: $0.00  
Total Hits: 20  |  Today: 0Author: robertford      Rating:  
Read Reviews | Write Review |  Your Rating: 

I work for a rather large company that spans countries and time zones, with multiple data centers in multiple locations. While working on a project where data was coming from different locations into a common data repository, we ran into a situation. Our application developers had not setup the application to convert date-time values into a common time zone; each application used the local time of the servers that hosted the application. In engaging the vendor, it was soon discovered that it was...

Rounding Functions in SQL Server     
Total Hits: 188  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All of the code is in T-SQL, but I think the reporting issues are related to data types and rounding down or rounding up rules. Do you have any insight into these issues? I would like to see some examples with a variety of coding options....

Using the EventData() Function with DDL triggers in SQL Server 2005     
Total Hits: 229  |  Today: 0Author: Edwin Sarmiento      Rating:  
Read Reviews | Write Review |  Your Rating: 

In SQL Server 2005, you can get data regarding the event that initiated the DDL trigger by accessing the EventData() function. This function returns information about server or database events and is stored in a variable that uses the XML data type. What we need to do is capture the data returned by the EventData() function and store it in a database table for reporting purposes. You can store that data directly in an XML column or process it first before storing it as ordinary columns in a tabl...

SQL Server 2005 Full-Text Search: Internals and Enhancements     
Total Hits: 142  |  Today: 0Author: Andrew Cencini      Rating:  
Read Reviews | Write Review |  Your Rating: 

The full-text search feature of Microsoft SQL Server 2005 delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.

This paper is for database administrators and developers alike. An introduction to full-text search and its architecture is followed by details about important enhancements and new features....

Mathematical User-Defined Functions     
Total Hits: 114  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

I would like to write the series of articles about useful User-Defined Functions grouped by the following categories:

# Date and Time User-Defined Functions
# Mathematical User-Defined Functions
# Metadata User-Defined Functions
# Security User-Defined Functions
# String User-Defined Functions
# System User-Defined Functions
# Text and Image User-Defined Functions...

Calling Stored Procedures from ADO.NET     
Total Hits: 100  |  Today: 0Author: John Paul Cook      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Microsoft .NET Framework offers improved performance in accessing stored procedures through ADO.NET when compared to ADO. The ADO.NET classes have multiple overloaded methods, so it’s important to understand the syntax sufficiently well to get the most from your code. Although the focus of the article is on SQL Server stored procedures, the techniques shown will also work with Oracle and other OLE DB compliant databases....

Rolling Sums in SQL - A Practical Example     
Total Hits: 65  |  Today: 0Author: Jay Pipes      Rating:  
Read Reviews | Write Review |  Your Rating: 

Today, Lenz was putting together some stats on PlanetMySQL feeds added since January this year, and asked in an email whether he should include totals in the stats. I responded yes, and offered a quick SQL solution to get those numbers out of the database. I thought it might be useful for others, so here goes...
Rolling sums (or averages) are a way to include a running, or rolling, aggregate of certain columns in the output of your SQL. For instance, let's say you want to list order totals, g...

SQL Server 2005 Ordered View and Inline Function Problems     
Total Hits: 239  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2000 introduced the TOP n [PERCENT] operator to enable restricting the number of rows in the resultset of a view or inline table-valued function (TVF). In SQL Server 2000, starting the SQL statement for a view or TVF with SELECT TOP n [PERCENT] ... enables adding an ORDER BY clause to order the query's internal rowset so as to return the correct resultset.
As a byproduct of that operation, views and TVFs returned resultsets sorted in accordance with the ORDER BY clause. A SELECT TO...

Summarizing and Grouping Data in SQL     
Total Hits: 240  |  Today: 0Author: Chris Fehily.      Rating:  
Read Reviews | Write Review |  Your Rating: 

The preceding chapter described scalar functions, which operate on individual row values. This chapter introduces SQL’s aggregate functions, or set functions, which operate on a group of values to produce a single, summarizing value. You apply an aggregate to a set of rows, which may be:
All the rows in a table
Only those rows specified by a WHERE clause
Those rows created by a GROUP BY clause No matter how many rows the set contains, an aggregate function returns a single statistic: a ...

SQL Server: Advantages and Drawbacks of User-Defined Functions     
Total Hits: 286  |  Today: 0Author: Baya Pavliashvili.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Why are UDFs important? What can you do with UDFs that you can't do with stored procedures? Although UDFs are not functionally stronger than stored procedures, they do provide certain advantages. Baya Pavliashvili discusses the advantages and limitations that are associated with UDFs and shows you the coding tasks that qualify as good candidates for UDFs. In the previous article in this series, I introduced you to user-defined functions (UDFs), which are excellent tools for certain programming t...

MDX Essentials: String / Numeric Functions: The CoalesceEmpty() Function     
Total Hits: 351  |  Today: 0Author: William Pearson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Within the world of OLAP, sparsity is pervasive. There are many reasons to want to display something other than an empty space in a report, where a "blank" is about as welcome, to most readers, as silence on a radio show. In an Analysis Services cube, as well as in the reporting layer of an integrated business intelligence solution, we have various options for the elimination or suppression of, and substitution for, nulls. This article concerns itself with one of those options for "handling the ...

Functionality as same Val() function in Access in Sql Server  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Vivek.Net      Rating:  
Read Reviews | Write Review |  Your Rating: 

Functionality as same Val() function in Access in Sql Server...

SQL Server 2000: New XML Features Streamline Web-centric App Development  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries....

C Round Function  Version: 0.00     Price: $0.00  
Total Hits: 14  |  Today: 0Author: Ali BaderEddin      Rating:  
Read Reviews | Write Review |  Your Rating: 

It’s really weird that the C math library (math.h) doesn’t support the round function. It only includes the floor function which rounds down a float to an integer (can also be done by implicit or explicit casting) and the ceil function which rounds the value up....

Dynamic Management Views [DMV] – A SQL Server 2005 Feature  Version: 0.00     Price: $0.00  
Total Hits: 33  |  Today: 0Author: Hari Prasad K      Rating:  
Read Reviews | Write Review |  Your Rating: 

The DMVs; newly introduced in SQL Server 2005 gives the database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance. DMVs are designed to be used instead of system tables and various other functions provided in SQL Server 2000. In this article, I will be explaining only about the frequently used DMVs....

MySQL User Defined Functions  Version: 0.00     Price: $0.00  
Total Hits: 23  |  Today: 0Author: DarkLizener      Rating:  
Read Reviews | Write Review |  Your Rating: 

Basically an User Defined Function (UDF) is a piece code that extends the functionality of a MySQL server by adding a new function that behaves just like a native (built-in) MySQL function like abs() or concat(). UDFs are written in C (or C++ if you really need to)! ... well maybe there is a way to write them in BASIC, .NET or whatever but I don't see why anybody would want to do that....

MySql Features  Version: 0.00     Price: $0.00  
Total Hits: 36  |  Today: 0Author: Bubbly      Rating:  
Read Reviews | Write Review |  Your Rating: 

The following paragraphs lists the main features of MySQL.

Features of MySQL

• Speed - MySQL is the fastest. (fastest among all)
• Ease of use - MySQL is a high-performance but relatively simple database system and is much less complex to set up and administer than larger systems.
• Cost - Is free for most in-house uses.
• Query language support - MySQL understands SQL (Structured query language), the language of choice for all modern database systems.
• Capability – M...

COALESCE() function in SQL-Server for getting comma seperated value     
Total Hits: 121  |  Today: 0Author: Ritesh Shah      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft Definition: This function returns first not null expression among its argument. You can use this function to get column values in one record set with separator like comma, dash etc. Before invention of this function, people used to achieve this kind of stuff by cursor which is time consuming....

LINQ to SQL (Part 8 - Executing Custom SQL Expressions)     
Total Hits: 57  |  Today: 0Author: ScottGu      Rating:  
Read Reviews | Write Review |  Your Rating: 

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data....

1  2  3  4  5  Next >> 

Disclaimer - Privacy
© 2002-2017