The following command may help you..

    EXEC sp_configure &#39;show advanced options&#39;, 1
    RECONFIGURE
    GO
    EXEC sp_configure &#39;ad hoc distributed queries&#39;, 1
    RECONFIGURE
    GO

You may check the following command

    sp_configure &#39;show advanced options&#39;, 1;
    RECONFIGURE;
    GO  --Added        
    sp_configure &#39;Ad Hoc Distributed Queries&#39;, 1;
    RECONFIGURE;
    GO
    
    SELECT a.*
    FROM OPENROWSET(&#39;SQLNCLI&#39;, &#39;Server=Seattle1;Trusted_Connection=yes;&#39;,
         &#39;SELECT GroupName, Name, DepartmentID
          FROM AdventureWorks2012.HumanResources.Department
          ORDER BY GroupName, Name&#39;) AS a;
    GO

Or this [documentation link](http://technet.microsoft.com/en-us/library/ms187569.aspx)




If ad hoc updates to system catalog is &quot;not supported&quot;, or if you get a &quot;Msg 5808&quot; then you will need to configure with override like this:

	EXEC sp_configure &#39;show advanced options&#39;, 1
	RECONFIGURE with override
	GO
	EXEC sp_configure &#39;ad hoc distributed queries&#39;, 1
	RECONFIGURE with override
	GO

    sp_configure &#39;show advanced options&#39;, 1;
    GO
    RECONFIGURE;
    GO
    sp_configure &#39;Ad Hoc Distributed Queries&#39;, 1;
    GO
    RECONFIGURE;
    GO

How are variables and memory managed in Python? Does it have a stack and a heap and what algorithm is used to manage memory? Given this knowledge are there any recommendations on memory management for large number/data crunching?

Does Python have a stack/heap and how is memory managed?

I am still trying to grasp the finer points of how I can run a linux or windows shell command and capture output within node.js; ultimately, I want to do something like this...

    //pseudocode
    output = run_command(cmd, args)

The important piece is that `output` must be available to a globally scoped variable (or object).  I tried the following function, but for some reason, I get `undefined` printed to the console...

&lt;!-- language: lang-js --&gt;

    function run_cmd(cmd, args, cb) {
      var spawn = require(&#39;child_process&#39;).spawn
      var child = spawn(cmd, args);
      var me = this;
      child.stdout.on(&#39;data&#39;, function(me, data) {
        cb(me, data);
      });
    }
    foo = new run_cmd(&#39;dir&#39;, [&#39;/B&#39;], function (me, data){me.stdout=data;});
    console.log(foo.stdout);  // yields &quot;undefined&quot; &lt;------

I&#39;m having trouble understanding where the code breaks above... a very simple prototype of that model works...

&lt;!-- language: lang-js --&gt;

    function try_this(cmd, cb) {
      var me = this;
      cb(me, cmd)
    }
    bar = new try_this(&#39;guacamole&#39;, function (me, cmd){me.output=cmd;})
    console.log(bar.output); // yields &quot;guacamole&quot; &lt;----

Can someone help me understand why `try_this()` works, and `run_cmd()` does not?  FWIW, I need to use [`child_process.spawn`](http://nodejs.org/api/child_process.html#child_process_child_process_spawn_command_args_options), because [`child_process.exec`](http://nodejs.org/api/child_process.html#child_process_child_process_exec_command_options_callback) has a 200KB buffer limit.



Final Resolution
----------------

I&#39;m accepting James White&#39;s answer, but this is the exact code that worked for me...

    function cmd_exec(cmd, args, cb_stdout, cb_end) {
      var spawn = require(&#39;child_process&#39;).spawn,
        child = spawn(cmd, args),
        me = this;
      me.exit = 0;  // Send a cb to set 1 when cmd exits
      me.stdout = &quot;&quot;;
      child.stdout.on(&#39;data&#39;, function (data) { cb_stdout(me, data) });
      child.stdout.on(&#39;end&#39;, function () { cb_end(me) });
    }
    foo = new cmd_exec(&#39;netstat&#39;, [&#39;-rn&#39;], 
      function (me, data) {me.stdout += data.toString();},
      function (me) {me.exit = 1;}
    );
    function log_console() {
      console.log(foo.stdout);
    }
    setTimeout(
      // wait 0.25 seconds and print the output
      log_console,
    250);

node.js shell command execution

When I run a query with `OPENROWSET` in SQL Server 2000 it works.

But the same query in SQL Server 2008 generates the following error:

&gt;SQL Server blocked access to STATEMENT &#39;OpenRowset/OpenDatasource&#39; of component &#39;Ad Hoc Distributed Queries&#39; because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of **&#39;Ad Hoc Distributed Queries&#39;** by using **sp_configure**


How to enable Ad Hoc Distributed Queries

When I run a query with <code>OPENROWSET</code> in SQL Server 2000 it works.
But the same query in SQL Server 2008 generates the following error:
>SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

How can I group only by month from a date field (and not group by day)?

Here is what my date field looks like:

    2012-05-01

Here is my current SQL:

    select  Closing_Date, Category,  COUNT(Status)TotalCount from  MyTable
    where Closing_Date &gt;= &#39;2012-02-01&#39; and Closing_Date &lt;= &#39;2012-12-31&#39;
    and Defect_Status1 is not null
    group by  Closing_Date, Category

How to group by month from Date field using sql

If we had a table like this:

Books (pretend &quot;ISBN&quot; doesn&#39;t exist)


 - Author
 - Title
 - Edition
 - Year of publication
 - Price

One could argue that {Author,Title,Edition} could be a candidate/primary key. 

What determines whether the candidate/primary key should be {Author,Title,Edition} or whether an ID column should be used, with {Author,Title,Edition} a unique index/key constraint?

So is

 - Author (PK)
 - Title (PK)
 - Edition (PK)
 - Year of publication
 - Price

better, or:

 - ID (PK)
 - Author
 - Title
 - Edition
 - Year of publication
 - Price

where {Author,Title,Edition} is an additional unique index/constraint?

Composite Primary key vs additional &quot;ID&quot; column?

**I have a simple table Structure like this:**

Table **tempData**


    ╔══════════╦═══════╗
    ║   NAME   ║ MARKS ║
    ╠══════════╬═══════╣
    ║ Narendra ║    80 ║
    ║ Ravi     ║    85 ║
    ║ Sanjay   ║    90 ║
    ╚══════════╩═══════╝
     

And I also have another table names as **tempDataView** like this

    ╔══════════╦═══════╗
    ║   NAME   ║ MARKS ║
    ╠══════════╬═══════╣
    ║ Narendra ║       ║
    ║ Narendra ║       ║
    ║ Narendra ║       ║
    ║ Narendra ║       ║
    ║ Ravi     ║       ║
    ║ Ravi     ║       ║
    ║ Sanjay   ║       ║
    ╚══════════╩═══════╝

I want to update the table **tempDataView** , by setting the **Marks**  according to the **tempDataView** - **Name** compared with **tempData** - **Name**

Yes let me show you what I tried, I tried to solve this using the Cursor and its solved perfectly, but I am finding the way to solve it using the **Subquery**

Here it is:


    Declare @name varchar(50),@marks varchar(50)
    Declare @cursorInsert CURSOR
    set @cursorInsert = CURSOR FOR
    Select name,marks from tempData
    OPEN @cursorInsert
    FETCH NEXT FROM @cursorInsert
    into @name,@marks
    WHILE @@FETCH_STATUS = 0
    BEGIN
    UPDATE tempDataView set marks = @marks where name = @name
    FETCH NEXT FROM @cursorInsert
    INTO @name,@marks
    END
    CLOSE @cursorInsert
    DEALLOCATE @cursorInsert

Actually it&#39;s like the homework for me to solve it using the Subquery. 

Update query using Subquery in Sql Server

What I&#39;m trying to do is use more than one CASE WHEN condition for the same column.

Here is my code for the query:

       SELECT	Url=&#39;&#39;,
    			p.ArtNo,
    			p.[Description],
    			p.Specification,
    			CASE 
                WHEN 1 = 1 or 1 = 1 
                   THEN 1 
                   ELSE 0 
    			END as Qty,
    			p.NetPrice,
    			[Status] = 0
          FROM	Product p (NOLOCK)

However, what I want to do is use more then one WHEN for the same column &quot;qty&quot;.

As in the following code:

    IF
    // CODE
    ELSE IF
    // CODE
    ELSE IF
    // CODE
    ELSE
    // CODE



How do I do multiple CASE WHEN conditions using SQL Server 2008?

I need help with setting a database that was restored in `SINGLE_USER` mode to `MULTI_USER`. Every time I run

    ALTER DATABASE BARDABARD
    SET MULTI_USER;
    GO

I get this error: 

&gt;Changes to the state or options of database &#39;BARDABARD&#39; cannot be made at this time. 
&gt;
&gt;The database is in single-user mode, and a user is currently connected to it.

It needs to be in non-`SINGLE_USER` mode to set it to another mode, but I can’t set the database in any another mode while it is `SINGLE_USER` mode.

Set database from SINGLE USER mode to MULTI USER

Please help me, how to filter words in SQL using a function? 

I&#39;m having a hard time if I explain it so I&#39;m giving example:

    ID       |       WebsiteName      |
    -----------------------------------
    1        |      www.yahoo.com     |
    2        |      www.google.com    |
    3        |      www.youtube.com   |

What I want is, how to get the name of the website. I want to select the record with an output like this. How to remove the &#39;www.&#39; and &#39;.com&#39; in the record.

    ID      |      WebsiteName
    --------------------------    
    1       |        yahoo

thanks for the help. :D

How to create a function in SQL Server

I understand that hashes will be different based on different datatypes in SQL Server. One support Unicode another not .... so on (also collation)

I am using char(32) as a datatype but the output is weird. 
Using this

    select HASHBYTES(&#39;MD5&#39;,&#39;MD5Text&#39;)

gives this ouput:

    0xA891DB2DA259280A66FD5F35201CAB6A

and when

    declare @h char(32)
    select @h=HASHBYTES(&#39;MD5&#39;,&#39;MD5Text&#39;)
    select @h,LEN(@h)
output:

Ё‘Ы-ўY( fэ_5 &#171;j 

So I am new to SQL Server.  
Could anyone, please, tell me what datatype should I use to store hashes ??

               

 

What kind of datatype should one use to store hashes?

I have trailing spaces in a column in a SQL Server table called `Company Name`.

All data in this column has trailing spaces.

I want to remove all those, and I want to have the data without any trailing spaces.

The company name is like `&quot;Amit Tech Corp         &quot;`

I want the company name to be `&quot;Amit Tech Corp&quot;`

Remove Trailing Spaces and Update in Columns in SQL Server

I&#39;ve got a table with data named `energydata`

it has just three columns

    (webmeterID, DateTime, kWh)

I have a new set of updated data in a table `temp_energydata`.

The `DateTime` and the `webmeterID` stay the same. But the `kWh` values need updating from `temp_energydata` table.

How do I write the T-SQL for this the correct way?


Content Type	Original Author	Original Content on Stackoverflow
Question	emergency coder	View Question on Stackoverflow
Solution 1 - Sql	Hasib Tarafder	View Answer on Stackoverflow
Solution 2 - Sql	user1977878	View Answer on Stackoverflow
Solution 3 - Sql	Robino	View Answer on Stackoverflow
Solution 4 - Sql	user2129794	View Answer on Stackoverflow

How to enable Ad Hoc Distributed Queries

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

node.js shell command execution

Does Python have a stack/heap and how is memory managed?

Attributions