data center

Technical Article

RE: populate one variable with the results from anothe

  • Reply

IS THIS IS WHAT U R LOOKING FOR.... DECLARE @SQLINDEXTABLENAME VARCHAR (200), @SQL_STMT NVARCHAR(4000) SET @SQL_STMT = 'SELECT @SQLINDEXTABLENAME = NAME FROM SYSOBJECTS WHERE ID = 5; ' EXEC SP_EXECUTESQL @SQL_STMT, N'@SQLINDEXTABLENAME VARCHAR(200) OUTPUT', @SQLINDEXTABLENAME OUTPUT PRINT @SQLINDEXTABLENAME Cheers..Prakash Prakash

You rated this post out of 5. Change rating

2003-06-13

Blogs

So You Want to Deploy Power BI Project files (PBIPs)?

By

Have you heard the news about the new Power BI Project files? Okay, maybe...

DBAs, Organizing Your SQL Scripts in Git

By

I wrote an article that was published on SQL Server Central on how to...

Only Capture Extended Events For a Given Time

By

It’s a great question. Let’s say you want to capture stored procedure completions. But,...

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