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,226 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,146 reads

Blogs

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

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

SQL Server and VMware Resource Pools

By

Resource pools are used to hierarchically partition available CPU and memory resources, and are...

Read the latest Blogs

Forums

Tools for DISA's SQL Server STIGs

By aborelli1

Is it possible to request a review of a tool I created to automate...

bcp format file and import fixed width text file

By smattiko83

I'm trying to set up a format file using bcp but I'm unsure of...

insert random value from predefined list of possible values

By marchello

Hi all, My need is to insert random value from predefined list of possible...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Linux Support

See possible answers