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
SQL SERVER - Definition, Comparison and Difference between HAVING and WHERE Clause

SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause

July 4, 2007
Pinal Dave
SQL Interview Questions and Answers
Best Practices, SQL Scripts

I asked every candidate the difference between HAVING and WHERE clause, and none got it right. HAVING filters groups, while WHERE filters individual rows.

Read More
SQL SERVER - Comparison : Similarity and Difference #TempTable vs @TempVariable

SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable

July 3, 2007
Pinal Dave
SQL Performance
SQL Scripts, SQL TempDB

#TempTable and @TempVariable both live in tempdb, but they differ in scope and purpose. Their similarities and differences, explained side by side.

Read More
SQL SERVER - 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC

SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC

July 2, 2007
Pinal Dave
SQL Performance
SQL Cursor, SQL Download, SQL Scripts, SQL Stored Procedure

SP_EXECUTESQL vs EXECUTE/EXEC in SQL Server 2005: what they share for dynamic SQL, like late compile and variable scope, and how they differ.

Read More
Gouache painting: on a bakery bench a narrow stoneware crock holds risen dough that has been sliced flat at its rim by a bench scraper

REPLACE Return Limits: Cast the Input to max

June 28, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

REPLACE return limits can truncate text at 8,000 bytes. Cast the searched input to max first, then compare Unicode and non-Unicode byte lengths.

Read More
SQL SERVER - Running Batch File Using T-SQL - xp_cmdshell bat file

SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file

June 27, 2007
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Scripts, SQL Utility

What is xp_cmdshell used for, and how do you run a batch file using T-SQL? Examples run a system command, a plain BAT file and one with a parameter.

Read More
Numbered wooden tables arranged in rows inside a database drum.

SQL SERVER – 2005 List All Tables of Database

June 26, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

The simple way to list all tables of a database in SQL Server 2005: select from sys.tables to get every table that users have created.

Read More
SQL SERVER - Repeate String N Times Using String Function REPLICATE

SQL SERVER – Repeate String N Times Using String Function REPLICATE

June 25, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

REPLICATE repeats a string N times. I found this T-SQL string function while searching for replication, and it is handy when you need repeated text.

Read More
Previous 1 … 340 341 342 343 344 345 346 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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