Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Understand when to use user-defined functions in SQL Server
- In the simplest terms, a user-defined function UDF in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued. (I will not be covering...
- Tags: Function, Parameter, Microsoft SQL Server, Server, Value, Table, UDF, SalesHistory, SaleDate, SalePrice, Tim Chapman
- Blog posts 2007-09-04
- Understand when to use user-defined functions in SQL Server
- Thank Tim.Good information.You said, "I usually discourage using scalar-valued UDFs in a WHERE criteria statement" and that's exactly some of the things a developing database manager, like myself, needs to know. It's one of those things I find myself wondering about, but I just can't make the time to...
- Tags: Databases, user-defined function, Microsoft SQL Server, thisisfutile, server, UDF
- Discussion threads 2007-09-04
- UDF Packet Writing over USB with InCD from Nero?
- I want to buy an external USB DVDRW burnerLG GSA-E10L for my notebook IBM ThinkPad 600X,Pentium III / 500 MHz, 256 MB RAM, USB 1.1.I have Windows 98, Release 1.1. Is it possible to use a UDF formatted CDRW ("Packet writing")with this burner with programm InCD?(InCD is part of Nero...
- Tags: UDF, burner, niagara1234@..., InCD, USB, packet writing, windows, software, hardware, burning, Nero
- Discussion threads 2007-02-02
- Invoke UDFs that accept tables with SQL Server 2005's APPLY operator
- Hihgly proprietaryThis is a highly proprietary and seems to be an attempt to mimic procedural programming. The right answer is never pass a table name as a parameter. You need to understand the basic idea of a data model and what a table means in implementing a data model....
- Tags: Invoke UDF, sql udf apply, jcelko212@..., software, Microsoft SQL Server, Microsoft SQL Server 2005, UDF
- Discussion threads 2006-09-05
- Invoke UDFs that accept tables with SQL Server 2005's APPLY operator
- A new feature in SQL Server 2005 is the APPLY operator, which allows the database developer to invoke a user-defined function that takes table value parameters. In this article, Tim Chapman shows you how to use this incredibly useful new operator.A user-defined function UDF is a database objectintroduced in SQL...
- Tags: Databases, Enterprise software, Microsoft SQL Server 2005, Tim Chapman, UDF, Microsoft SQL Server, APPLY operator
- Technical articles 2006-08-24
- Building and using table UDFs in SQL Server
- Great Info Thanks!Great Info Thanks!Great articleThat was one of the most useful articles i have ever read. Thanks to the author.They can be usefulbut keep them simple, or you'll spend a lot of time optimising. I've seen people go overboard with the corresponding facility in oracle. They were joining four...
- Tags: Building, fshahzad@..., Microsoft SQL Server, server, software, sql server, UDF
- Discussion threads 2006-08-10
- Building and using table UDFs in SQL Server
- Table UDFs (user-defined functions) are one of Arthur Fuller's favorite features of SQL Server 2000 and 2005. Find out why he says that, if you've never used them, you may be in for a surprise. Table UDFs (user-defined functions) are one of my favorite features of SQL Server...
- Tags: Microsoft SQL Server, UDF, Databases, Arthur Fuller, server, SQL Server Newsletter, TechRepublic Inc., Fun, Table, Enterprise Software, Software, Data Management
- Technical articles 2006-08-07
- Excel UDF Help - "Select Case"
- I'm trying to write a function to forecast a value based on historical data. The UDF has three arguments: range of cells must be within a single row or column, method (1-4), and an optional rate (-1
- Tags: Cell, excel, fRangeLastCol, fRangeLastRow, Integer Dim fRangeLastCol, Integer Dim fRangeLastRow, Microsoft Excel, programming, rford2112@..., RngChk, Rob Public Function rForecast, Select Case, Value, Value at Risk
- Discussion threads 2006-02-06
- Incorporate SQL Server UDFs in your .NET applications
- The article shows a misuse of UDFsIt’s nice to see UDFs get some attention. But the author exhibits a common misuse of UDFs. Take a look at this procedure:CREATE PROCEDURE dbo.ReturnAllEmployees AS BEGIN SELECT dbo.GetEmployeeName(e.EmployeeID) As FullName, Address, City, PostalCode FROM Employees e END The SELECT statement...
- Tags: anovick@..., create function, Incorporate SQL Server UDF, Microsoft .NET, Microsoft SQL Server, programming, sql server udf, udf, UDF dbo.GetEmployeeName, user-defined function
- Discussion threads 2005-10-20
- CeQuadrat-PacketCD to new packet format
- My friend had a CDBurner failure x4x4x24 using PacketCD from CeQuadrat bought out by Adaptec andbought out by Roxio. Replaced her CDRW with a Lite-on x52x32x52 CDBurner with bundled Nero 5.5 and InCD 4.0 after first unInstalling PacketCD (PacketCd wouldn't recognize the new drive even for reading). ...
- Tags: CeQuadrat, Direct CD UDF, disk, Nero, Roxio, software, tech_wiz03@..., windows
- Q&A 2004-12-11
- TechRepublic Tutorial: Increase your SQL power with user-defined functions
- In SQL 2000, Microsoft introduced its implementation of user-defined functions UDFs. You’re probably already familiar with many of the built-in functions such as GetDate, User_Name, and so on. You may not know that the master database contains a collection of UDFs as well, some of which are encrypted; others are...
- Tags: Arthur Fuller, SQL, user-defined function
- Technical articles 2003-07-09
- SQL Server 2000's user-defined functions add flexibility, cut coding time
- User-defined functions UDFs can help you increase functionality with less effort. Thankfully, SQL Server 2000 has added UDF support. Check out this article for more information on using them in your applications.Microsoft’s SQL Server may be a big dog in the enterprise database market, but its conspicuous lack of...
- Tags: Databases, Enterprise software, Microsoft SQL Server 2000, UDF, Microsoft SQL Server
- Technical articles 2002-03-25
- Automating your Windows NT installation: The UDF
- Tired of wasting time with manual installs? James McPherson takes a look at the mysteries of the UDF.Unattended installation is a feature that may seem of little use to small IT shops with only a few NT boxes. But in reality, it’s most useful in smaller businesses, where manpower is...
- Tags: Microsoft Windows, James McPherson, unique database file, Unattend.txt, Microsoft Windows NT, UDF
- Technical articles 1999-10-08
Additional Resources
- SR UDF Library (zip)
- SR UDF Library version (2.0.2.0) a user defined function library (161 UDFs) for InterBase and Firebird on the Windows platform. This version of SR UDF Library supports the following standard routins Math, File, DateTime, String, Regional, Hash in addition to Conversion routins for converting different measurement units.
- Tags: User-defined Function
- Software downloads 2006-10-11
- StarBurn SDK (exe)
- StarBurn SDK is advanced CD/DVD burning, grabbing, and mastering toolkit. Features are: All MMC compatible CD/DVD recorders (CD-R/W, DVD-R/W, DVD+R/W and DVD-RAM) are supported. UDF file system mastering (UDF 1.02, 1.50 and 2.01). ISO9660 file system mastering including Joliet Unicde name extensions. Session import (appending already created CD/DVD). Bridge file...
- Tags: CD, File System, StarBurn SDK, DVD, Consumer Electronics, Personal Technology, Home Entertainment
- Software downloads 2005-07-20
- EasyBurn (zip)
- Writes to ALL CD/DVD media types including Blu-Ray (BD-R/BD-RE). Supports all current hardware interfaces (IDE/SCSI/USB/1394/SATA). Writes Multi-Session or Disc-at-Once mode to ALL supported media formats. Supports UDF/ISO9660/Joliet Bridged file systems any combination. Supports UDF/ISO9660/Joliet Bridged file systems any combination. Supports UNICODE for multi-byte languages. Version 5 adds the feature to...
- Tags: Combination, File System, Railfoxsoft
- Software downloads 2008-04-29
- Unable to read CD-ROM contents
- All computers are virus free and the operating systems are up to date:I am attempting to load a cd on only 1 computer, a W2k desktop. The problem is that the computer acts as if the cd is not in the drive when of course it is. The cd is...
- Tags: cd, CD, CD-ROM, PC, tobrahs, windows
- Q&A 2004-10-26
- Build molecular queries from atoms in SQL Server
- Flexible but at a priceCombining several subqueries (hidden in objects such as views, UDF,...) may introduce overhead forcing SQL server to retrieve temporary results, store them in tempdb and only then return final results. Using such a technique on a big databases one should be careful enough to...
- Tags: Aliux, Microsoft SQL Server, server, software, sql, subquery
- Discussion threads 2006-09-19
- User Defined Function (UDF) on a network
- I have created a UDF and an Excel Add-in which contains this function. I want to call this function on a spreadsheet that can be viewed by anyone in my group on our network. The problem is that even if others have the add-in installed, Excel changes the...
- Tags: Microsoft Office, PRODUCTIVITY, network, arizenn, Microsoft Excel, add-in
- Discussion threads 2007-06-08
- Incorporate SQL Server UDFs in your .NET applications
- Database interaction is a standard feature of most .NETapplications, with SQL Server as the popular choice for the data tier.Consequently, .NET developers often find themselves developing T-SQL codewithin their applications or stored procedures on the database server.Developers often overlook a number of the features in theT-SQL language. For instance, when...
- Tags: Database interaction, Microsoft .NET, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, Tony Patton, User Defined Function
- Technical articles 2005-10-18
- << Previous
- page 1 of 1
- Next >>
