sql server udf

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

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

Additional Resources

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

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

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

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

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management

White papers 2001-07-19

Transferring SQL Server logins between servers or instances

I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...

Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2007-09-25

Some resources on SQL Server 2005

Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner

Blog posts 2005-11-11

Calculating financial values in SQL Server

Although SQL Server 2000 and 2005 do not include much in the way of financial functions, Arthur Fuller shows you how to use the present value and future value functions to calculate financial functions in SQL Server. SQL Server 2000 and 2005 do not include much in the way...

Tags: Microsoft SQL Server, Databases, Arthur Fuller, server, present value, future value, financial, SQL Server Newsletter, TechRepublic Inc., Formula, Enterprise Software, Financial Accounting, Software, Data Management, Finance

Technical articles 2006-08-23

Fast Track DBA

I am looking for a "Boot Camp" for SQL DBA. I have some knowledge of it but I am trying to gain more experience and it helps that my company is going to pay for it. I am looking for something that is a 2 day Session ...any IdeasSQL ServerI...

Tags: Programming languages, Databases, jabney@..., SQL, server

Discussion threads 2005-06-14

EMS SQL Manager 2008 for SQL Server (zip)

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML...

Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

Make the jump from SQL Server 2000/7 to SQL Server 2005 with these notes and tips

There are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently released SQL Server 2005. Migrating from SQL Server 2000 or SQL Server 7 to SQL Server 2005 is not a project...

Tags: Microsoft SQL Server, Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

Download resources 2006-02-07

Microsoft SQL Server Query Processor Internals and Architecture

This article examines how Microsoft SQL Server queries are processed on the client, how the various clients interact with SQL Server, and what SQL Server does to process clients' requests. Hopefully, knowing how SQL Server processes your queries, and how and when it compiles them or recompiles them, will allow...

Tags: Processor, Microsoft SQL Server, Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

White papers

Best Practices for Upgrading to SQL Server 2005

It is not difficult to move from SQL Server 7 or SQL Server 2000 to SQL Server 2005. The key to any successful upgrade is preparation and researching potential problems. Talk to stakeholders, level with them, and get their support, and the upgrade will be a success. SQL Server 2005...

Tags: Microsoft SQL Server, Best Practice, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

White papers 2008-02-19

Incorporate SQL Server UDFs in your .NET applications

User Defined Functions UDFs are a powerful feature that every developer who works with SQL Server needs to know. Learn how to incorporate UDFs in your next .NET project. Database interaction is a standard feature of most .NET applications, with SQL Server as the popular choice for the...

Tags: Microsoft SQL Server Transact-SQL, Microsoft .NET, Microsoft SQL Server, Databases, Tony Patton, .NET, Middleware, Database interaction, User Defined Function, .NET Newsletter, Function, Method, Procedure, User-defined Function, Listing B, Scalar, Listing D, Enterprise Software, Software, Data Management

Technical articles 2005-10-18

Teratrax Performance Monitor (msi)

Monitor SQL Server performance on all enterprise servers from a single interface. Analyze and chart real-time and historical execution of SQL code across users and applications. Isolate SQL Server hardware utilization and correlate it with SQL statements and SPs. Be the first to know about slow and failed SQL Server...

Tags: Microsoft SQL Server, SQL, Databases, Enterprise Software, Software, Data Management

Software downloads 2006-06-16

EMS SQL Manager 2008 Lite for SQL Server (zip)

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...

Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

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

SQL 2000 server/ODBC

Hello. I have installed SQL server 2000 personal edition on a desktop PC to establish a local SQL server for databases connecting via ODBC data source. When I attempt to SQL server verify authenticity of the databases login id, it tells me "connection failed"...SQL server error 11001...SQL...

Tags: hardware, Microsoft SQL Server, ODBC, rcelentano@..., server, SQL

Q&A 2005-04-26

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