TechRepublic Resources
- Advanced SQL Server Documentation Generator (msi)
- Relational database utility that automates generation of Microsoft SQL Server 2000 and Microsoft SQL Server 2005 database documentation in HTML, PDF and RTF formats. The application handles the following database object types: tables, views, stored procedures, triggers and user-defined functions. HTML format: For each database the application generates an HTML...
- Tags: Application, HTML, Adobe PDF, Microsoft SQL Server, User-defined Function, Server, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2008-02-08
- Advanced SQL Server 2000 Documentation Generator (msi)
- Relational database utility that automates generation of Microsoft SQL Server 2000 database documentation in HTML, PDF and RTF formats. The application handles the following database object types: tables, views, stored procedures, triggers and user-defined functions. HTML format: For each database the application generates an HTML index document and a CSS...
- Tags: Application, HTML, Adobe PDF, Microsoft SQL Server, Microsoft SQL Server 2000, User-defined Function, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2008-02-08
- SharePoint 2007 Sample: user-defined functions for Excel 2007 and Excel Services Sample Solution (exe)
- The SharePoint 2007 Sample: User-Defined Functions for Excel 2007 and Excel Services Sample Solution demonstrates how you can develop and reuse UDFs for Excel 2007 and Excel Services. This version is the first release on CNET Download.com.
- Tags: Microsoft SharePoint, User-defined Function, Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-10-05
- 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
- 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
- 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
- How do I... Create a user-defined function in Microsoft Excel
- Sometimes you find yourself in a situation where you can't get Microsoft Excel to do exactly what you want it to do without coding a complicated formula over and over again. Microsoft Excel allows users to create their own user-defined functions. Using the power of Visual Basic for Applications (VBA),...
- Tags: User-defined Function, Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software
- Download resources 2006-10-04
- SQL Script Recovery Pro (zip)
- SQL Script Recovery is a decrypt software for SQL Server 7 and 2000 with examining stored procedures, triggers, views, and user-defined functions. If you encrypt your own source code of stored procedures, triggers, views, or user-defined functions with encryption option, but you neglectful lost it, the application can help you...
- Tags: User-defined Function, SQL, SQL Script Recovery, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-03-03
- 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
- Integrate C# code with Microsoft Excel
- Excel is the application most frequently programmed against in the Microsoft Office family.This sample chapter from Visual Studio Tools for Office: Using C# with Excel, Word, Outlook, and InfoPath briefly considers several of the ways that you can integrate your C# code with Excel, explores building user-defined functions for Excel,...
- Tags: Addison-Wesley, Microsoft Corp., Microsoft Excel, Microsoft InfoPath, Microsoft Outlook, Microsoft Visual Studio, Microsoft Word, C#, programming, tool
- Download resources 2006-05-05
- 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
- 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
- Create a user-defined function in Microsoft Excel
- ProblemSometimes you find yourself in a situation where you can't getMicrosoft Excel to do exactly what you want it to do withoutcoding a complicated formula over and over again. In such a scenario, you oftenhave to spend an unacceptable amount of time finding circular logic errors orfixing syntax problems. Using...
- Tags: user-defined function, Mark Kaelin, commission, Microsoft Corp., Microsoft Excel
- Technical articles 2004-08-17
- 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
- Writing user-defined functions in PHP
- PHP lets you write your own functions, which saves you from rewriting code and helps keep your applications smaller. Here's a look at the basics of writing user-defined functions and some examples of how you can put them to work.By definition, PHP is just a scripting language used on Web...
- Tags: Scripting languages, OOA/OOD/OOP, command function, Vincent Danen, PHP
- Technical articles 2002-03-04
- 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
Additional Resources
- ImageCD Catalog (exe)
- Browse all your image CDs while you keep them on the shelf. Variable user defined thumbnail size and quality, let you to manage how much space will take on disk your catalog and to share it to your friends with easy. The build in full screen viewer will exactly point...
- Tags: Disk, Catalog
- Software downloads 2007-05-25
- Subclassing ActiveX (zip)
- The control element accomplishes a subclassing for a window stated by its handle. The window function is the function of a window, which completely determines the behavior of the window (and thus the reaction of the window to user inputs). This window function is replaced by another function by the...
- Tags: Window, ActiveX, Control Element, Window Function, Construction
- Software downloads 2008-02-13
- Sicyon Lite (exe)
- Sicyon is all-in-one freeware tool for every scientist. The core of Sicyon is an VBScript/JScript scripter and the principal features are: estimate a function using variables and user-defined functions; matrix operations; plot/tabulate a function; find real roots, minimums, maximums and definite integral of a function; fit a function over data...
- Tags: Function, Freeware, Sicyon, Productivity, Scripting Languages, Software/Web Development, Web Development
- Software downloads 2006-02-09
- << Previous
- page 1 of 1
- Next >>
