This should work for you. Infact the one which you are thinking will also work:-

     .......
     DECLARE @returnvalue INT

     EXEC @returnvalue = SP_One
     .....

The accepted answer is invalid with the double EXEC (only need the first EXEC):

    DECLARE @returnvalue int;
    EXEC @returnvalue = SP_SomeProc
    PRINT @returnvalue

And you still need to call PRINT (at least in Visual Studio).

Assign after the `EXEC` token:

    DECLARE @returnValue INT

    EXEC @returnValue = SP_One

I just started using R, and came across data.table. I found it brilliant. 

A very naive question: Can I ignore data.frame to use data.table to avoid syntax confusion between two packages?

What you can do with a data.frame that you can&#39;t with a data.table?

In C# language and .NET framework, could you help me with understanding delegates?
I was trying to check some code, and found that the results I received were unexpected for me. Here it is:

    class Program
    {
        public static int I = 0;
        
        static Func&lt;string&gt; del = new Func&lt;string&gt;(I.ToString);
       
        static void Main(string[] args)
        {
            I = 10;
            Console.WriteLine(&quot;{0}&quot;, del());
        }
    }

The answer was 0, but not 10. Why? 


Using delegates in C#

I have a stored procedure where it ends with a RETURN value of 0 or 1.

I want to use this value in an IF statement in another stored procedure.

How can I get the return value of the former stored procedure and save it in a variable in the latter?

I couldn&#39;t find anything related. All questions are about fetching the RETURN values in C#.

I was thinking, maybe something like this :

**SP_Two**

    DECLARE @returnValue INT
    SET @returnValue = EXEC SP_One
    
    IF @returnValue = 1
    BEGIN
       --do something
    END
    ELSE
    BEGIN
       --do something else
    END

Get RETURN value from stored procedure in SQL

I have a stored procedure where it ends with a RETURN value of 0 or 1.
I want to use this value in an IF statement in another stored procedure.
How can I get the return value of the former stored procedure and save it in a variable in the latter?
I couldn't find anything related. All questions are about fetching the RETURN values in C#.
I was thinking, maybe something like this :
SP_Two
<pre><code class="hljs language-sql">DECLARE @returnValue INT
SET @returnValue = EXEC SP_One

IF @returnValue = 1
BEGIN
 --do something
END
ELSE
BEGIN
 --do something else
END
</code></pre>

I am trying to populate any rows missing a value in their `InterfaceID (INT)` column with a unique value per row.

I&#39;m trying to do this query:

    UPDATE prices SET interfaceID = (SELECT ISNULL(MAX(interfaceID),0) + 1 FROM prices) 
           WHERE interfaceID IS null

I was hoping the the `(SELECT ISNULL(MAX(interfaceID),0) + 1 FROM prices)` would be evaluated for every row, but its only done once and so all my affected rows are getting the same value instead of different values.

Can this be done in a single query?

Update int column in table with unique incrementing values

I&#39;m finding a way to aggregate strings from different rows into a single row. I&#39;m looking to do this in many different places, so having a function to facilitate this would be nice. I&#39;ve tried solutions using `COALESCE` and `FOR XML`, but they just don&#39;t cut it for me.

String aggregation would do something like this:

    id | Name                    Result: id | Names
    -- - ----                            -- - -----
    1  | Matt                            1  | Matt, Rocks
    1  | Rocks                           2  | Stylus
    2  | Stylus

I&#39;ve taken a look at [CLR-defined aggregate functions][1] as a replacement for `COALESCE` and `FOR XML`, but apparently **SQL Azure** *does not* support CLR-defined stuff, which is a pain for me because I know being able to use it would solve a whole lot of problems for me.

Is there any possible workaround, or similarly optimal method (which might not be as optimal as CLR, but *hey* I&#39;ll take what I can get) that I can use to aggregate my stuff?

[1]: http://picnicerror.net/development/sql-server/concatenate-multiple-row-values-sql-server-with-clr-2012-01-10/

Optimal way to concatenate/aggregate strings

I have an existing table with data. I have just added a new column but I cannot find how to add a unique constraint on that column. Could someone please advise? Right-clicking and selecting &quot;check constraints&quot; wasn&#39;t helpful.

Add unique constraint in SQL Server 2008 GUI?

I&#39;m trying to achieve a &quot;One to one&quot; relationship in a MySQL database. For example, let&#39;s say I have a Users table and an Accounts table. I want to be sure that a User can have only one Account. And that there can be only one Account per User.

I found two solutions for this but don&#39;t know what to use, and are there any other options.

### First solution:

    DROP DATABASE IF EXISTS test;
    CREATE DATABASE test CHARSET = utf8 COLLATE = utf8_general_ci;
    USE test;
    
    CREATE TABLE users(
    	id INT NOT NULL AUTO_INCREMENT,
    	user_name VARCHAR(45) NOT NULL,
    	PRIMARY KEY(id)
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
    
    CREATE TABLE accounts(
    	id INT NOT NULL AUTO_INCREMENT,
    	account_name VARCHAR(45) NOT NULL,
    	user_id INT UNIQUE,
    	PRIMARY KEY(id),
    	FOREIGN KEY(user_id) REFERENCES users(id)
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8;

In this example, I define the foreign key in accounts pointing to the primary key in users.
And then I make foreign key UNIQUE, so there can&#39;t be two identical users in accounts.
To join tables I would use this query:

    SELECT * FROM users JOIN accounts ON users.id = accounts.user_id;

### Second solution:

    DROP DATABASE IF EXISTS test;
    CREATE DATABASE test CHARSET = utf8 COLLATE = utf8_general_ci;
    USE test;
    
    CREATE TABLE users(
    	id INT NOT NULL AUTO_INCREMENT,
    	user_name VARCHAR(45) NOT NULL,
    	PRIMARY KEY(id)
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
    
    CREATE TABLE accounts(
    	id INT NOT NULL AUTO_INCREMENT,
    	account_name VARCHAR(45) NOT NULL,
    	PRIMARY KEY(id),
    	FOREIGN KEY(id) REFERENCES users(id)
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8;

In this example, I create a foreign key that points from the primary key to a primary key in another table. Since Primary Keys are UNIQUE by default, this makes this relation One to One.
To join tables I can use this:

    SELECT * FROM users JOIN accounts ON users.id = accounts.id;

Now the questions:

 - What is the best way to create One to One relation in MySQL?
 - Are there any other solutions other than these two?

I&#39;m using MySQL Workbench, and when I design One To One relation in EER diagram and let MySQL Workbench produce SQL code, I get One to Many relation :S That&#39;s what&#39;s confusing me :S

And if I import any of these solutions into MySQL Workbench EER diagram, it recognizes relations as One to Many :S That&#39;s also confusing.

So, what would be the best way to define One to One relation in MySQL DDL. And what options are there to achieve this?


MySQL - One To One Relationship?

I have simple question:

I have a **`postgresql`** table: `Scores(score integer)`.

How would I get the highest 10 scores the fastest?  

**UPDATE:** 

I will be doing this query multiple times and am aiming for the fastest solution.

How to get the top 10 values in postgresql?

I know how to get the last executed queries using the following SQL in SSMS -

    SELECT deqs.last_execution_time AS [Time], dest.text AS [Query]
    FROM sys.dm_exec_query_stats AS deqs
    CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
    ORDER BY deqs.last_execution_time DESC

But I want to find them for a specific database. I don&#39;t want to use SQL Profiler, if I don&#39;t have to. Plus I don&#39;t think SQL Profiler will allow me to view queries that were already run without profiling turned on. I need to do this from SSMS.

Last executed queries for a specific database

I want to update my column CODE_DEST with an incremental number.  I have:

    CODE_DEST   RS_NOM
    null        qsdf
    null        sdfqsdfqsdf
    null        qsdfqsdf

I would like to update it to be:

    CODE_DEST   RS_NOM
    1           qsdf
    2           sdfqsdfqsdf
    3           qsdfqsdf

I have tried this code:

    UPDATE DESTINATAIRE_TEMP
    SET CODE_DEST = TheId 
    FROM (SELECT  Row_Number()   OVER (ORDER BY [RS_NOM]) AS TheId FROM DESTINATAIRE_TEMP)

This does not work because of the `)`

I have also tried:

    WITH DESTINATAIRE_TEMP AS
      (
        SELECT 
        ROW_NUMBER() OVER (ORDER BY [RS_NOM] DESC) AS RN
        FROM DESTINATAIRE_TEMP
      )
    UPDATE DESTINATAIRE_TEMP SET CODE_DEST=RN

But this also does not work because of union.

How can I update a column using the `ROW_NUMBER()` function in SQL Server 2008 R2?

Content Type	Original Author	Original Content on Stackoverflow
Question	hermann	View Question on Stackoverflow
Solution 1 - Sql	Rahul Tripathi	View Answer on Stackoverflow
Solution 2 - Sql	Nicholas Petersen	View Answer on Stackoverflow
Solution 3 - Sql	Alex K.	View Answer on Stackoverflow

Get RETURN value from stored procedure in SQL

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Using delegates in C#

What you can do with a data.frame that you can't with a data.table?

Attributions