This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of paper cards crossing a small wooden bridge between two organized file trays.

Copy Data from One Table to Another in SQL Server: SQL in Sixty Seconds #031

October 31, 2012
Pinal Dave
SQL Video
SQL Constraint and Keys, SQL in Sixty Seconds, SQL Scripts, SQL Table Operation

To copy data from one table to another, use INSERT…SELECT for an existing table or SELECT…INTO for a new one. The tests here show what SELECT…INTO carries over and what it drops, the errors you can hit, and a quick way to check the copy.

Read More
Open cleanout hatch aligned with a chimney flue

Finding the Error Log Folder and Other Paths From T-SQL

October 29, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio

Pasted a server path into File Explorer and found nothing? The folder is on the server, not your laptop. Here are the queries that tell you where.

Read More
SQL SERVER - Move Database Files MDF and LDF to Another Location

SQL SERVER – Move Database Files MDF and LDF to Another Location

October 28, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server, Transaction Log

Your new database sits in the default location and keeps growing. Here is how to move the MDF and LDF database files to another disk or drive.

Read More
Punch needle beside a continuous stitched row with its last loose loop withdrawn

Gapless Invoice Numbers That Restart Every Year

October 25, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Transactions

Finance hates a missing invoice number. A small counter table and one short transaction keep the numbers gapless and restart them each year.

Read More
A roofer laying overlapping wooden shingles: one long continuous run, a bare gap, then a short second run.

Merging Overlapping Date Ranges Into Continuous Periods

October 22, 2012
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL DateTime, SQL Scripts, SQL Server

Use running end dates when merging overlapping ranges, choose boundary rules, and return continuous periods without losing nested intervals.

Read More
SQL SERVER - Find First Non-Numeric Character from String

SQL SERVER – Find First Non-Numeric Character from String

October 14, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

No built-in function finds the first non-numeric character in a string, so I use PATINDEX. Here is a quick script with sample data you can try.

Read More
Hands squaring a neat stack of plain envelopes beside a messy pile, a red rubber band around the tidy stack

Cleaning Address Data in T-SQL: Trimming, Casing and Standardizing

October 12, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

Start cleaning address data with preserved originals, normalized spaces, careful casing, street-word mappings, and postal-code review flags.

Read More
Previous 1 … 197 198 199 200 201 202 203 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com