Spatial Data Types

Technical Article

RE: Move data from staging to production

  • Reply

There is no need to use an activex task unless you want to enrich or change the data you are copying in. Just write your query inside a Transform Data Task between the 2 connections. Example, 'Select columns... from DTS_companies where not exists (select * from MAXSYR_COMPANIES)' Then you can match the columns up on […]


Technical Article

RE: Why is exec() not working in a loop

  • Reply

I meant in the first exec.Don't know the exact explanation, but it is like it is executed in a diferent context or connection.If you create a #temp table with EXEC (EXEC ('CREATE #TABLE...')) you won't see it in the actual connection, the same if you declare variables EXEC ('DECLARE @Test AS INT SELECT @Test = […]



Daily Coping 1 Dec 2022


Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan


So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?


SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs


Merge String into single string

By sabarishbabu

Hello Team, I have a input fields like below with fixed value separator (6) ...

How to get intellisense on CLR types in SQL Server Management Studio

By FirstByte

I created a CLR user defined type in C#/Visual Studio and added it to...

Display Top N values of a table with calculation next to it

By Soof1234

Hi, In Power BI Report Builder I need to use SSRS code for my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers