Azure Data Factory

Technical Article


  • Topic

I want to write select store procedure with 4 columns Passing a single variable and returning all the 4 columns as an output can someone help mehow to return 4 coulmsn for example:create proc test@id int output,@name char(10) output,@city char(20) output,@state char(2) outputasselect id,name,city,state from test_table where id = @id???????????



Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Multitenant architecture

By mto89

Hi all, i have to refactor an existing database multi-tenant. All tables should be...

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers