Azure Data Factory

Technical Article

SQL OUTPUT

  • 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???????????

You rated this post out of 5. Change rating

2004-09-30

Blogs

Not Selected for the PASS Data Community Summit 2024

By

I got this in an email about a week ago from the PASS Data...

A New Word: Addleworth

By

addleworth – adj. unable to settle the question of whether you’re doing okay in...

Data Technology Learning Resources

By

Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers