Generic paged data like MySQL LIMIT

This works, however code is creating a live temp_1 table in the database instead of using a #temp_1 temporary table because is just would not work.The next idea I had was to use a unique table name per connection for temp_1, but I would really rather use temporary tables.I am hoping some SQL guru's can […]

2003-07-22

115 reads

Blogs

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Learn from the Troubles of Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn from the Troubles of...

Agile Job Descriptions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Agile Job Descriptions

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers