19,155 tutorials online
12 tutorials pending review
763 dead links removed





How to search for date and time values using Microsoft SQL Server 2000

User Rating: Not yet rated
Source Website: www.codebeach.com
Viewed: 34 times
Reported For Abuse / Broken Link: 0 times
(Report Link)

Rate this tutorial:


Description:
Because of the way date and time values are stored in SQL Server 2000, searching for a particular date or time isn’t as straightforward as you might think it would be. This article describes how date/time values are stored, how the database design can simplify (or complicate) data retrieval, and how to query date/time data to get the right results every time.






Other Tutorials From This Category
    How to Use the INNER JOIN Keyword in SQL Server
    Working with alias data types in SQL Server 2005 using T-SQL
    SQL Server 2005 Admin:(10 Hours)
    Easy way to connect to your Remote Database
    SQL Server FAQs - Transact-SQL Managing Character Strings and Binary Strings
    Using Stored procedure with mySQL and PHP
    SQL Server FAQs - Transact-SQL Understanding Stored Procedures
    Easy way to Enable/Activate your SQL Server Agent Service 2005 & 2008
    SQL Server 2005 Express Tools
    How to Use the GROUP BY Statement in SQL Server