Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Generate random sets in SQL Server with NewID()
- Not needed in the select clauseYou can simply ORDER BY NEWID, there's no need to use it in the SELECT as well.
- Tags: NEWID, sql, simonsnewsletters@..., software, Microsoft SQL Server, server
- Discussion threads 2006-07-11
- Generate random sets in SQL Server with NewID()
- Even though SQL Server was not designed to produce random sets, Arthur Fuller explains how the function NewID provides you with a simple way to generate random sets. Our team recently completed a project for a travel-package organization, for which we received glowing thank-you letters and e-mails from...
- Tags: Ingersoll-Rand, Microsoft SQL Server, Databases, Arthur Fuller, server, NEWID, productID, random set, SQL Server Newsletter, Function, TechRepublic Inc., Solution, T-SQL Function, Enterprise Software, Software, Data Management
- Technical articles 2006-07-10
Additional Resources
- Select random rows from a table in SQL
- Random rows are a particularly good way to add dynamism to a site; unfortunately, SQL doesn't permit the selection of random rows. Check out this simple trick to deliver randomly selected rows. There are many ways that you can use randomly selected rows; they're especially effective when you...
- Tags: SQL, Databases, Arthur Fuller, Programming languages, NULL DEFAULT NewID, SQL Server Newsletter, TechRepublic Inc., Solution, Row, News, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-25
- Generating and working with GUIDs in .NET
- TechRepublic's free .NET newsletter, delivered each Wednesday, contains useful tips and coding examples on topics such as Web services, ASP.NET, ADO.NET, and Visual Studio .NET. Automatically sign up today!When Windows developers need a unique value, they oftenutilize a Globally Unique Identifier GUID. Microsoft uses the term GUID for aunique number...
- Tags: GUID, GUID value, Tony Patton, Microsoft .NET
- Technical articles 2005-05-17
- Generating and working with GUIDs in .NET
- A Globally Unique Identifier GUID is a 128-bit integer that you can use across all computers and networks wherever a unique identifier is required. Tony Patton explains how the .NET Framework makes it possible for you to create your own GUID. TechRepublic's free .NET newsletter, delivered each Wednesday, contains...
- Tags: Microsoft .NET, Tony Patton, GUID, Microsoft Windows, Middleware, Databases, .NET, Application servers, Microsoft development tools, Programming languages, sample code, .NET Newsletter, TechRepublic Inc., Microsoft .NET Framework, Namespace, Microsoft SQL Server, Microsoft Corp., C#, Software Development, Software/Web Development, Operating Systems, Software, Enterprise Software, Data Management
- Technical articles 2005-05-17
- Simplify SQL Server 2005 queries with a Dates table
- I find that it can be advantageous to use a Dates table, especially when doing a lot of date calculations. Learn what a Dates table is and how to create one, and then try it out for yourself. What is a Dates table? A Dates table stores a...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Table, DateLookup, DATEPART, SaleDate, Tim, Sales Strategy, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman
- Blog posts 2008-04-14
- 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
- << Previous
- page 1 of 1
- Next >>
