datatype to use for timespan data type (sql server 2008)

I need to store timespan data types in a column. SQL server 2008 doesn't have a timespan column. What should I use instead?

Message posted on the April 2nd, 2009 - 7:58 AM ET

FairCom’s Newest c-treeACE® Bridges SQL, NoSQL Worlds

For the First Time, Developers can Map Non-relational Data as Relational (SQL), Without Modifying the Data, and Realize Significant Performance Gains.

Press published on the November 12th, 2012 - 7:00 AM ET

Infinitely Virtual Announces Support for Microsoft SQL Server 2012, Providing Cloud-Ready Hosting with Mission-Critical Level Data Protection

MS SQL Server 2012 Improves Data Query, Adds ‘Always On’ Reliability, More Custom Programming Features.

Press published on the May 7th, 2012 - 4:04 AM ET

Condusiv Technologies New V-locity Server I/O Optimization Software Accelerates Exchange and SQL by 50% or More without the Cost of New Storage Hardware

Optimizing I/O at the source with V-locity® Server powers faster applications and eliminates performance bottlenecks, so organizations can protect existing CAPEX equipment and save investment dollars by going 50% faster on the ...

Press published on the April 21st, 2013 - 10:01 PM ET

Logicworks Digital Media Series Presents “Just Say No To SQL: The Where and When of NoSQL Platforms”

The Next Wave of Open-Source Innovation Hits the Mainstream: Highly Scalable NoSQL Databases.

Press published on the July 20th, 2011 - 5:00 AM ET

Cirro Launches Company to Bring Big Data to the Desktop

Cirro enables easy access to any type of data, on any platform, in any environment.

Press published on the June 20th, 2012 - 8:00 AM ET

Amazon Web Services Announces New Managed Services for Windows Developers Worldwide

Launches Amazon Relational Database Service (Amazon RDS) for Microsoft SQL Server and ASP.NET support for AWS Elastic Beanstalk Now it’s even easier for Windows and ASP.NET developers to offload database and ...

Press published on the May 8th, 2012 - 3:00 PM ET

Veracode State of Software Security Report Finds Eight Out of 10 Applications Fail to Meet New Security Standards

With Higher Concentrations of Cross-Site Scripting and SQL Injection Errors, Security of Government Applications Lags Behind Other Industries.

Press published on the December 7th, 2011 - 5:00 AM ET

Bug#702574: TYPO3-CORE-SA-2013-001: SQL Injection and Open Redirection in TYPO3 Core

Package: typo3-src Severity: critical Tags: security It has been discovered that TYPO3 Core is susceptible to SQL Injection and Open Redirection Component Type: TYPO3 Core Affected Versions: 4.5.0 up to 4.5.23, 4.6.0 up to 4.6.16, 4.7.0 up to ...

Message posted on the March 8th, 2013 - 10:10 AM ET

Error in sql server logs

Hi Geiing this error message on multiple sql servers (sql server 2008, 2005) today. No changes from last few months on the sql servers. Message: DESCRIPTION: The login packet used to open the connection is structurally invalid; the connection has ...

Message posted on the February 16th, 2010 - 12:10 PM ET

Whatto setup in ClusterAdmin for a SQL 2005 cluster

Hello, I am trying to install SQL 2005 as Active/Active Cluster. You may refer to my other posting, "HELP: Problem installing SQL 2005 with Clustering". I believe that I need to do something additional in the Cluster Admin MMC, but I ...

Message posted on the March 23rd, 2009 - 12:26 PM ET

Bug#702403: davical.sql function language incorrect case for PlPgSQL

Package: davical Version: 1.1.1-1 Severity: important Tags: upstream I'm running this machine with the pgdg postgres packages and am using pg 9.2. When running the create-database.sh script, I get the errors listed below. The first time through I ...

Message posted on the March 6th, 2013 - 1:40 AM ET

Bug#691087: webgui: deprecated syntax in create.sql.gz

Package: webgui Version: 7.10.26-1 Severity: important Dear Maintainer, the create.sql.gz file contains the TYPE=MyISAM syntax, but this is deprecated and should be ENGINE=MyISAM TYPE= was completely removed in mysql 5.5 so the sql file is broken ...

Message posted on the October 21st, 2012 - 6:20 AM ET

Bug#675834: hsqldb: FTBFS: The import java.sql.SQLFeatureNotSupportedException cannot be resolved

Package: src:hsqldb Version: 1.8.0.10-12 Severity: serious Tags: sid wheezy User: debian-bsd@lists.debian.org Usertags: kfreebsd X-Debbugs-Cc: debian-bsd@lists.debian.org Justification: fails to build from source (but built successfully in the past) ...

Message posted on the June 3rd, 2012 - 11:50 AM ET

type sql