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

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

SSMS & Excel - Copy Paste - DateTime Columns

By AMCiti

Dear Group: I am not sure if this is a T-SQL / SSMS issue,...

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers