Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Strategies for approaching null values with SQL Server
- By Kaye GartenData integrity is a critical aspect of any database system. No matter how well a system is planned, the issue of null data values is always present. Let's examine the three aspects of dealing with these values in SQL Server: counting, using null table values, and dealing with...
- Tags: Databases, strategy, server, Guest Contributor, Microsoft SQL Server, Col1, CREATE TABLE xCount, ISNULL
- Technical articles 2003-01-24
Additional Resources
- Access append records from form
- I have a form that gets data from two linked tables and also user input. I would like to create a command button and have the fields on the form be appended to a new table. Can someone point in the the right direction of how to start?Posting...
- Tags: Databases, dcorleto@..., Microsoft Access
- Discussion threads 2007-08-14
- Building a data values dictionary
- This week's SQL Server newsletter presents the basic SQL for building a data values dictionary.Will you follow the steps in this tip to create a data values dictionary? Do any of your clients ever request this kind of data? Please let us know.If you aren't subscribed to the free SQL...
- Tags: Adding Owner, data values dictionary, dictionary, Newsletter Editor, proc, software, Value at Risk, values dictionary
- Discussion threads 2004-10-11
- Using SQL Server 2008's MERGE statement
- Can you get the Identity key back?This is a great idea. It can reduce the "CU" of my CRUD stored procedures to have one for both create and update.When doing the "WHEN MATCHED", can you do a begin/end block there so that you can capture the @@IDENTITY value?YesYou could do...
- Tags: Paul C., Using SQL Server 2008, SELECT CustomerID, TotalSalesCount, TotalSalesAmount, GetDate, LoadDate
- Discussion threads 2007-09-25
- Access Excel 2003 from a C# component
- I have a customer that wants data from excel printed onto a crystal report. They want the row of data sent the the crystal report at a time. I have created a component that can be called from VBA within excel and sends the data to the report...
- Tags: C#, jarmani@..., Microsoft Access, programming
- Q&A 2004-11-17
- Use presentation layer table sorting to achieve a better user experience
- Which is the best?The article and accompanying download describe several different methods developers can use to give end-users the ability to sort data. But which method is the best?[b]Which sorting method do you recommend and why?[/b]that's a fairly broad questionThat really depends on how fast you want it to be.For...
- Tags: database, Mark W. Kaelin, server
- Discussion threads 2005-01-13
- CSS 101: Decide what to style with selectors
- Get more information about the many nuances of the CSS standard by learning about adjacent sibling and attribute selectors, as well as pseudo-classes and pseudo-elements. A CSS selector is made up of a pattern that is matched against all elements in the document tree. Its CSS rule is...
- Tags: Listing B, CSS, Tony Patton, CSS selector, selector, Web Development Zone Newsletter, Listing E, Scripting Languages, Software/Web Development, Web Development
- Technical articles 2007-04-09
- << Previous
- page 1 of 1
- Next >>
