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 Delete top 1 rows
  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 + '%'

Delete top 1 rows

to sql by taurin on Mar 07, 2008
// Deletes the top 1 row from the table

set rowcount 1
DELETE FROM xxx WHERE xxx
set rowcount 0

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 Delete top 1 rows
  3. 3 Reindex and rebuild statistics for entire database