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,290 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: )

32,968 reads

Blogs

Inspector V2.6 now available

By

As always the code can be found here in our github repoWe updated our...

Data Mesh: Centralized ownership vs decentralized ownership

By

I have done a ton of research lately on Data Mesh (see the excellent...

Daily Coping 23 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Define All The Steps Up Front

By Grant Fritchey

Comments posted to this topic are about the item Define All The Steps Up...

Having users access .dtsx (package file) saved on LAN

By redoak

Hello All, I created a package file (.dtsx) via SSDT. I took the folder...

AG is continually reporting failover due to mirroring connect error

By webrunner

Hello experts, I'm seeing this Always On Availability Group behavior around every 5 minutes....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers