Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- table join
- Hey guys what is the best way to join a table like this let say I've got a table Towns with a pkID and TownName field. And I've got a table named Destination with a pkID, DepartureID, DestinationID. Now destination and departure obviosly refer to the towns pkID field.So how...
- Tags: pkID, SELECT
- Discussion threads 2005-05-17
- Look up values in SQL Server using range joins
- Be careful when dealing with floating numberNice, but rather than altering MinWeight to 1.01 we should alter the join condition with x < 1 and x = dbo.ShippingRates.MinWeight AND dbo.Shipments.Weight < dbo.ShippingRates.MaxWeight)
- Tags: Look-up, MinWeight, sql, join, sanjaya.tio@..., software, Microsoft SQL Server, server
- Discussion threads 2006-05-16
- Understand the ambiguities of compound JOINs in SQL
- Arthur Fuller explains why he wants developers to think about this general principle: Compound JOINs become nonsensical when one of the clauses references only one of the tables. This article begins with a test. Look at the SQL below and determine, without using your computer, what the ...
- Tags: SQL, Arthur Fuller, dbo.Orders.OrderID, dbo.Orders.CustomerID, Databases, SELECT dbo.Customers.CustomerID, NULL CustomerID, OUTER JOIN dbo.Orders, dbo.Customers, SQL Server Newsletter, TechRepublic Inc., Clause, Row, dbo.Customers.CustomerID, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-25
- 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
- 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
- Sql Select from Databases on Multiple MSSql Servers
- Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...
- Tags: Programming languages, Databases, awcrichton@..., SQL, database
- Discussion threads 2007-05-16
- Alter every table in a SQL database
- Adding two columns to every table in a database that contains hundreds of tables is impractical to do by hand. Arthur Fuller describes how simple it is to create a query that performs this task. All developers make mistakes from time to time; sometimes this happens...
- Tags: SQL, Databases, Arthur Fuller, database, ALTER TABLE NorthwindTest.dbo, ADD LastUpdated TimeStamp NULL, LastUpdated TimeStamp, SQL Server Newsletter, TechRepublic Inc., Table, Storage, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-22
- 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
- Date Format and correlated subquery
- I need to take a month and day field in a table, and update a new date field, based upon the month and year. I tried this query, which says it updates the records, but none of the date fields are updated. Can someone tell me what is...
- Tags: dateTime, FETCH NEXT, programming, Randy.L.Kemp@...
- Discussion threads 2004-11-05
- Understand the ambiguities of compound JOINs in SQL
- good use of on clauseActually, I do use elements of the on clause that only reference one table to good effect. I use it when the table I'm joining with has a lot of records in it that I would like to filter out before joining, (e.g. a description lookup...
- Tags: clause, dbo.Customers.CustomerID, dbo.Orders.CustomerID, dominic@..., join, joins, software, SQL, sql server
- Discussion threads 2005-11-15
- 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
- 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
- Help with SQL Query (Date ranges)
- I've been struggling with a SQL query and can't find a answer anywhere, although I've come kinda close. I need to pull a range of users by hire date BUT just the month and day. For example I want to pull all users who had a hire date...
- Tags: ADynes@..., DatePart
- Discussion threads 2007-07-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
- Build molecular queries from atoms in SQL Server
- What is your preferred method of doing things? Arthur Fuller says his M.O. is what he calls molecular queries. This scalable technique allows him to re-use and re-combine the atoms as requirements demand. Every SQL Server developer has a preferred method of doing things; mine is what I...
- Tags: Microsoft SQL Server, CustomerID, Databases, Arthur Fuller, server, ExtendedAmount, Northwind_New, SQL Server Newsletter, TechRepublic Inc., Atom, Column, Productivity, Enterprise Software, Software, Data Management
- Technical articles 2006-09-01
- 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
- 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
- Finding the highest value in several SQL Server columns
- greatest at leastFiding the highest or lowest values in a row is something that I stumbled upon years ago.In my job I have to handle several RDBMSs, among them MSSQL, Oracle, Postgresql and MySQL.I added a couple of function in my MSSQL library named dbo.least(@n1,@n2) and dbo.greatest(@n1,@n2) since I...
- Tags: philippe.e@..., NULL VALUE, greatest, least, feedback, arg, Microsoft SQL Server, server
- Discussion threads 2007-02-27
- Finding the highest value in several SQL Server columns
- If your task is to return the maximum value contained on a row from n columns, you may want to program defensively, anticipating that some new columns might be added. See why Arthur Fuller says this approach can leave you with useful functions. You have a SQL Server table...
- Tags: Microsoft SQL Server, Databases, Arthur Fuller, server, supposition, SQL, SELECT dbo.Max2, MinMaxID, SQL Server Newsletter, Column, NULL, dbo.Max2, Enterprise Software, Software, Data Management
- Technical articles 2007-02-26
- << Previous
- page 1 of 1
- Next >>
