Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

Andrew King

3 total

On This Page:

  1. 1 Joining Tables using a Like statement
  2. 2 Get a date without time in SQL
  3. 3 Reindex and rebuild statistics for entire database

Joining Tables using a Like statement

to sql mssql by taurin on Aug 15, 2008
-- This SQL code allows you to join a table to another table by finding columns that contain another column's information
-- (instead of where the columns are equal)

SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.col LIKE '%' + Table2.col + '%'

Get a date without time in SQL

to date mssql datetime by taurin on Apr 09, 2008
--Extracts the date from the date time
CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime)

Reindex and rebuild statistics for entire database

to sql mssql by taurin on Mar 07, 2008
// Reindex and rebuild statistics for each table in the database

EXEC sp_MSforeachtable "dbcc dbreindex('?')"
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
3 total

On This Page:

  1. 1 Joining Tables using a Like statement
  2. 2 Get a date without time in SQL
  3. 3 Reindex and rebuild statistics for entire database