Technical Article

_Select Update

I made some modifications to D Simmon's original sp.  1. I added dynamic feature to query tables in other databases (not linked servers) from one sp. I know dynamic sql isn't preferable in most cases but this is the route I took for this.  2. I enabled table name to be sent with owner qualification […]

You rated this post out of 5. Change rating

2007-09-18 (first published: )

601 reads

Blogs

Spark Connect Dotnet Variant Data Type

By

All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Read the latest Blogs

Forums

restore a cdc db from 2016

By Sailor

I'm backing up a SQL 2016 db and copying it to SQL Server 2022. ...

Serverless Gets Faster

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Serverless Gets Faster

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers