News

Date and Time in SQL Server 2008

  • Article

SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.

4.13 (32)

2007-10-24

12,220 reads

Passing a Table to a Stored Procedure

  • Article

SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.

4.23 (22)

2009-02-13 (first published: )

31,620 reads

Blogs

Arrays in PowerShell–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Passwords = A Good Thing

By

Those my friends are, in my opinion, one of the single most wonderful things...

Speaking at SQL Saturday Oregon

By

SQL Saturday Oregon — in the city of Portland — is taking place next...

Read the latest Blogs

Forums

Looking for simple non-aggregate version of PIVOT to transpose Rows into Columns

By YSLGuru

I know I've found the answer to this before but I'm having trouble now...

Briefcase Missing Old Functionality

By TUellner

I haven't tried to save anything to my briefcase since the website rebuild. I...

Dynamic Partitions for Flight Data

By barclke

I am parsing 30+ meg binary files, as varbinary(max), containing parameter data from an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers