What about creating a startup script with SET NOCOUNT ON in the script (assign the script to the SQLCMDINI environment variable). http://msdn.microsoft.com/en-us/library/ms162773.aspx


The `-i` and `-q` options [are mutually exclusive][1].

Create a file named setnocount.sql with the content:

    SET NOCOUNT ON;

And you might be able to do `-i setnocount.sql,otherscript.sql` using the multiple files feature and effectively an &quot;included&quot; common first file.

  [1]: http://msdn.microsoft.com/en-us/library/ms162773.aspx


You can also run multiple lines in the `-Q` parameter, separated by semicolon, like below

eg:

    -Q &quot;set nocount on;select * from table;delete from table where some_condition=true&quot;

What are some common mistakes made by Clojure developers, and how can we avoid them?

For example; newcomers to Clojure think that the `contains?` function works the same as `java.util.Collection#contains`.  However, `contains?` will only work similarly when used with indexed collections like maps and sets and you&#39;re looking for a given key:

    (contains? {:a 1 :b 2} :b)
    ;=&gt; true
    (contains? {:a 1 :b 2} 2)
    ;=&gt; false
    (contains? #{:a 1 :b 2} :b)
    ;=&gt; true

When used with numerically indexed collections (vectors, arrays) `contains?` **only** checks that the given element is within the valid range of indexes (zero-based):

    (contains? [1 2 3 4] 4)
    ;=&gt; false
    (contains? [1 2 3 4] 0)
    ;=&gt; true

If given a list, `contains?` will never return true.


Common programming mistakes for Clojure developers to avoid

I have just tried implementing a class where numerous length/count properties, etc. are `uint` instead of `int`. However, while doing so I noticed that it&#39;s actually painful to do so, like as if no one actually wants to do that.

Nearly everything that hands out an integral type returns an `int`, therefore requiring casts in several points. I wanted to construct a `StringBuffer` with its buffer length defaulted to one of the fields in that class. Requires a cast too.

So I wondered whether I should just revert to `int` here. I&#39;m certainly not using the entire range anyway. I just thought since what I&#39;m dealing with there simply *can&#39;t* be negative (if it was, it&#39;d be an error) it&#39;d be a nice idea to actually use `uint`.

P.S.: I saw [this question](https://stackoverflow.com/questions/6301/why-is-array-length-an-int-and-not-an-uint) and this at least explains why the framework itself always uses `int` but even in own code it&#39;s actually cumbersome to stick to `uint` which makes me think it apparently isn&#39;t really wanted.

Should I use uint in C# for values that can&#39;t be negative?

Is there a way to suppress &quot;x rows affected&quot; in SQLCMD from the command line?  

I&#39;m running an MSBuild script and don&#39;t want it clogging up my log on my build server.

I&#39;d rather not have to add &quot;SET NOCOUNT ON&quot; in every script, so if there&#39;s a way to do it from the command line, that would be fantastic.

Is there a way to suppress &quot;x rows affected&quot; in SQLCMD from the command line?

Is there a way to suppress "x rows affected" in SQLCMD from the command line?
I'm running an MSBuild script and don't want it clogging up my log on my build server.
I'd rather not have to add "SET NOCOUNT ON" in every script, so if there's a way to do it from the command line, that would be fantastic.

I have the following test table in SQL Server 2005:

    CREATE TABLE [dbo].[TestTable]
    (
     [ID] [int] NOT NULL,
     [TestField] [varchar](100) NOT NULL
    ) 

Populated with:

    INSERT INTO TestTable (ID, TestField) VALUES (1, &#39;A value&#39;);   -- Len = 7
    INSERT INTO TestTable (ID, TestField) VALUES (2, &#39;Another value      &#39;); -- Len = 13 + 6 spaces

When I try to find the length of TestField with the SQL Server LEN() function it does not count the trailing spaces - e.g.:

    -- Note: Also results the grid view of TestField do not show trailing spaces (SQL Server 2005).
    SELECT 
     ID, 
     TestField, 
     LEN(TestField) As LenOfTestField, -- Does not include trailing spaces
    FROM 
     TestTable


How do I include the trailing spaces in the length result?

LEN function not including trailing spaces in SQL Server

Is there a command in Microsoft SQL Server T-SQL to tell the script to stop processing?
I have a script that I want to keep for archival purposes, but I don&#39;t want anyone to run it.


T-SQL STOP or ABORT command in SQL Server

Given the query below there might be multiple rows in dps_markers with the same marker key but we only want to join against the first.  If I take this query and remove the top 1 and ORDER BY I get a value for mbg.marker_value but run as it is it always returns null

    SELECT u.id, mbg.marker_value 
    FROM dps_user u
    LEFT JOIN 
        (SELECT TOP 1 m.marker_value, um.profile_id
         FROM dps_usr_markers um (NOLOCK)
             INNER JOIN dps_markers m (NOLOCK) 
                 ON m.marker_id= um.marker_id AND 
                    m.marker_key = &#39;moneyBackGuaranteeLength&#39;
         ORDER BY m.creation_date
        ) MBG ON MBG.profile_id=u.id 
    WHERE u.id = &#39;u162231993&#39;


Top 1 with a left join

I&#39;ll use a concrete, but hypothetical, example.

Each **Order** normally has only one **line item**:

**Orders:**

&lt;!-- language: lang-none --&gt;

    OrderGUID   OrderNumber
    =========   ============
    {FFB2...}   STL-7442-1      
    {3EC6...}   MPT-9931-8A

**LineItems:**

&lt;!-- language: lang-none --&gt;

    LineItemGUID   Order ID Quantity   Description
    ============   ======== ========   =================================
    {098FBE3...}   1        7          prefabulated amulite
    {1609B09...}   2        32         spurving bearing

But occasionally there will be an order with two line items:

&lt;!-- language: lang-none --&gt;

    LineItemID   Order ID    Quantity   Description
    ==========   ========    ========   =================================
    {A58A1...}   6,784,329   5          pentametric fan
    {0E9BC...}   6,784,329   5          differential girdlespring 

Normally when showing the orders to the user:

&lt;!-- language: lang-sql--&gt;

    SELECT Orders.OrderNumber, LineItems.Quantity, LineItems.Description
    FROM Orders
        INNER JOIN LineItems 
        ON Orders.OrderID = LineItems.OrderID

I want to show the single item on the order. But with this occasional order containing two (or more) items, the orders would *appear* be **duplicated**:

&lt;!-- language: lang-none --&gt;

    OrderNumber   Quantity   Description
    ===========   ========   ====================
    STL-7442-1    7          prefabulated amulite
    MPT-9931-8A   32         spurving bearing
    KSG-0619-81   5          panametric fan
    KSG-0619-81   5          differential girdlespring

What I really want is to have SQL Server *just pick one*, as it will be *good enough*:

&lt;!-- language: lang-none --&gt;

    OrderNumber   Quantity   Description
    ===========   ========   ====================
    STL-7442-1    7          prefabulated amulite
    MPT-9931-8A   32         differential girdlespring
    KSG-0619-81   5          panametric fan

If I get adventurous, I might show the user, an ellipsis to indicate that there&#39;s more than one:

&lt;!-- language: lang-none --&gt;

    OrderNumber   Quantity   Description
    ===========   ========   ====================
    STL-7442-1    7          prefabulated amulite
    MPT-9931-8A   32         differential girdlespring
    KSG-0619-81   5          panametric fan, ...

So the question is how to either
 
 - eliminate &quot;duplicate&quot; rows
 - only join to one of the rows, to avoid duplication


## First attempt ##
My first naive attempt was to only join to the &quot;**TOP 1**&quot; line items:

&lt;!-- language: lang-sql --&gt;

    SELECT Orders.OrderNumber, LineItems.Quantity, LineItems.Description
    FROM Orders
        INNER JOIN (
           SELECT TOP 1 LineItems.Quantity, LineItems.Description
           FROM LineItems
           WHERE LineItems.OrderID = Orders.OrderID) LineItems2
        ON 1=1

But that gives the error:

&gt; The column or prefix &#39;Orders&#39; does not  
&gt; match with a table name or alias name  
&gt; used in the query.  

Presumably because the inner select doesn&#39;t see the outer table.


How to Join to first row

I tried to create a database diagramm with SQL Server 2008, but an error occurs:

&gt; Database diagram support objects
&gt; cannot be installed because this
&gt; database does not have a valid owner.
&gt; To continue, first use the Files page
&gt; of the Database Properties dialog box
&gt; or the ALTER AUTHORIZATION statement
&gt; to set the database owner to a valid
&gt; login, then add the database diagram
&gt; support objects.

Then I tried the following:

    EXEC sp_dbcmptlevel &#39;Ariha&#39;, &#39;90&#39;;
    GO
    ALTER AUTHORIZATION ON DATABASE::Ariha TO [WIN-NDKPHUPPNFL\Administrator]
    GO
    USE Ariha
    GO
    EXECUTE AS USER = N&#39;dbo&#39; REVERT
    GO
Next erorr pops up: 

&gt; Msg 15404, Level 16, State 11, Line 1
&gt; Could not obtain information about
&gt; Windows NT group/user
&gt; &#39;WIN-NDKPHUPPNFL\Administrator&#39;, error
&gt; code 0x534.

The Problem is the name of the PC has changed into &quot;DevPC&quot; I also changed this in the update script, but still the same error 15404. 

What can I do to fix this annoying error?

    

Database Diagram Support Objects cannot be Installed ... no valid owner

How can I access the number of rows affected by:

    cursor.execute(&quot;SELECT COUNT(*) from result where server_state=&#39;2&#39; AND name LIKE &#39;&quot;+digest+&quot;_&quot;+charset+&quot;_%&#39;&quot;)

Python: Number of rows affected by cursor.execute(&quot;SELECT ...)

I am using R and need to select rows with aged (age of death) less than or equal to laclen (lactation length). I am trying to create a new data frame to only include rows/ids whereby the value of column&#39;aged&#39; is less than its corresponding &#39;laclength&#39; value.
 
    df:
     id1   id2    laclen    aged
    9830  64526    26       6 
    7609  64547    28       0 
    9925  64551     3       0 
    9922  64551     3       5 
    9916  64551     3       8 
    9917  64551     3       8 
    9914  64551     3       2 

the new data frame should look like this:

    dfnew:
    id1   id2    laclen    aged
    9830  64526    26       6 
    7609  64547    28       0 
    9925  64551     3       0 
    9914  64551     3       2


Any help would be appreciated!

Bazon

Select only rows if its value in a particular column is less than the value in the other column

I have the following 2 data.frames:

    a1 &lt;- data.frame(a = 1:5, b=letters[1:5])
    a2 &lt;- data.frame(a = 1:3, b=letters[1:3])

I want to find the row a1 has that a2 doesn&#39;t.

Is there a built in function for this type of operation?

(p.s: I did write a solution for it, I am simply curious if someone already made a more crafted code)

Here is my solution:

    a1 &lt;- data.frame(a = 1:5, b=letters[1:5])
    a2 &lt;- data.frame(a = 1:3, b=letters[1:3])
    
    rows.in.a1.that.are.not.in.a2  &lt;- function(a1,a2)
    {
    	a1.vec &lt;- apply(a1, 1, paste, collapse = &quot;&quot;)
    	a2.vec &lt;- apply(a2, 1, paste, collapse = &quot;&quot;)
    	a1.without.a2.rows &lt;- a1[!a1.vec %in% a2.vec,]
    	return(a1.without.a2.rows)
    }
    rows.in.a1.that.are.not.in.a2(a1,a2)



Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2

How does one add rows to a numpy array?

I have an array A:

    A = array([[0, 1, 2], [0, 2, 0]])

I wish to add rows to this array from another array X if the first element of each row in X meets a specific condition.

Numpy arrays do not have a method &#39;append&#39; like that of lists, or so it seems.

If A and X were lists I would merely do:

    for i in X:
        if i[0] &lt; 3:
            A.append(i)

Is there a *numpythonic* way to do the equivalent?

Thanks,
S ;-)

Numpy - add row to array

I am trying to add rows to the `tbody` of a table. But I am having issues with achieving that. Firstly, the function where everything takes place is called on change of a dropdown from a html page. I created a `tr` string containing all the `td` inside that containing the html elements, text and other stuff. But when I am trying to add that generated row to the table using:

    $(newRowContent).appendTo(&quot;#tblEntAttributes tbody&quot;);

I am encountering an error. The name of the table is `tblEntAttributes` and I am trying to add it to the `tbody`.

Actually what&#39;s happening is jQuery is unable to get `tblEntAttributes` as an html element. But I can access it using `documemt.getElementById(&quot;tblEntAttributes&quot;);` 

Is there any way I can achieve this by adding rows to the `tbody` of the table. Maybe a bypass or something.

Here&#39;s the entire code:

    var newRowContent = &quot;&lt;tr&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;&quot; + chkboxId + &quot;\&quot; value=\&quot;&quot; + chkboxValue + &quot;\&quot;&gt;&lt;/td&gt;&lt;td&gt;&quot; + displayName + &quot;&lt;/td&gt;&lt;td&gt;&quot; + logicalName + &quot;&lt;/td&gt;&lt;td&gt;&quot; + dataType + &quot;&lt;/td&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;chkAllPrimaryAttrs\&quot; name=\&quot;chkAllPrimaryAttrs\&quot; value=\&quot;chkAllPrimaryAttrs\&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;chkAllPrimaryAttrs\&quot; name=\&quot;chkAllPrimaryAttrs\&quot; value=\&quot;chkAllPrimaryAttrs\&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;

    $(&quot;#tblEntAttributes tbody&quot;).append(newRowContent); 

One thing I forgot to mention is the function where this code is written is actually the success callback function for a ajax call. I am able to access the table using `document.getElementById(&quot;tblEntAttributes&quot;)` but for some reason `$(#tblEntAttributes)` doesn&#39;t seem to work.

Adding rows to tbody of a table using jQuery

I am using a SQL 2008 database project (in visual studio) to manage the schema and initial test data for my project. The atabase project uses a post deployment which includes a number of other scripts using SQLCMD&#39;s &quot;:r &lt;filename&gt;&quot; syntax.

I would like to be able to conditionally include certain files based on a SQLCMD variable. This will allow me to run the project several times with our nightly build to setup various version of the database with different configurations of the data (for a multi-tenant system).

I have tried the following:

    IF (&#39;$(ConfigSetting)&#39; = &#39;Configuration1&#39;)
      BEGIN
        print &#39;inserting specific configuration&#39; 
    :r .\Configuration1\Data.sql
      END
    ELSE
      BEGIN
        print &#39;inserting generic data&#39; 
    :r .\GenericConfiguration\Data.sql
      END

But I get a compilation error: 
**SQL01260: A fatal parser error occurred: Script.PostDeployment.sql**

Has anyone seen this error or managed to configure their postdeployment script to be flexible in this way? Or am I going about this in the wrong way completely?

Thanks,
Rob

P.S. I&#39;ve also tried changing this around so that the path to the file is a variable, [similar to this post][1]. But this gives me an error saying that the path is incorrect.


  [1]: https://stackoverflow.com/questions/5653103/sqlcmd-r-path-where-path-is-a-variable
  

Conditional logic in PostDeployment.sql script using SQLCMD

I installed SQL Server 2008 R2 to my local machine. But, I can&#39;t create a new database because of rights (or lack of).

&gt; &quot;CREATE DATABASE PERMISSION DENIED&quot;

So, I tried to assign the admin privileges to my current login

&gt; &quot;User does not have permission to perform this action.&quot;

I also tried to create a new login that would have admin privileges but with no luck. **How do I grant myself admin rights so that I can create a database?** I can re-install, but I prefer not to.

How do I grant myself admin access to a local SQL Server instance?

I&#39;m in the research phase trying to adopt 2012 Database Projects on an existing small project. I&#39;m a C# developer, not a DBA, so I&#39;m not particularly fluent with best practices. I&#39;ve been searching google and stackoverflow for a few hours now but I still don&#39;t know how to handle some key deployment scenarios properly.

1) Over the course of several development cycles, how do I manage multiple versions of my database? If I have a client on v3 of my database and I want to upgrade them to v8, how do I manage this? We currently manage hand-crafted schema and data migration scripts for every version of our product. Do we still need to do this separately or is there something in the new paradigm that supports or replaces this?

2) If the schema changes in such a way that requires data to be moved around, what is the best way to handle this? I assume some work goes in the Pre-Deployment script to preserve the data and then the Post-Deploy script puts it back in the right place. Is that the way of it or is there something better?

3) Any other advice or guidance on how best to work with these new technologies is also greately appreciated!

**UPDATE:** My understanding of the problem has grown a little since I originally asked this question and while I came up with a workable solution, it wasn&#39;t quite the solution I was hoping for. Here&#39;s a rewording of my problem:

The problem I&#39;m having is purely data related. If I have a client on version 1 of my application and I want to upgrade them to version 5 of my application, I would have no problems doing so if their database had no data. I&#39;d simply let SSDT intelligently compare schemas and migrate the database in one shot. Unfortunately clients have data so it&#39;s not that simple. Schema changes from version 1 of my application to version 2 to version 3 (etc) all impact data. My current strategy for managing data requires I maintain a script for each version upgrade (1 to 2, 2 to 3, etc). This prevents me from going straight from version 1 of my application to version 5 because I have no data migration script to go straight there. The prospect creating custom upgrade scripts for every client or managing upgrade scripts to go from every version to every greater version is exponentially unmanageable. What I was hoping was that there was some sort of strategy SSDT enables that makes managing the data side of things easier, maybe even as easy as the schema side of things. My recent experience with SSDT has not given me any hope of such a strategy existing but I would love to find out differently.

How to properly manage database deployment with SSDT and Visual Studio 2012 Database Projects?

Is it possible instruct cURL to suppress output of response body?

In my case, the response body is an HTML page, which overflows the CLI buffer, making it difficult to find the relevant information. I want to examine the other parts of the output such as HTTP response code, headers, e.t.c. - everything *except* the actual HTML.

Content Type	Original Author	Original Content on Stackoverflow
Question	Josh Kodroff	View Question on Stackoverflow
Solution 1 - Sql Server	fupsduck	View Answer on Stackoverflow
Solution 2 - Sql Server	Cade Roux	View Answer on Stackoverflow
Solution 3 - Sql Server	Rob	View Answer on Stackoverflow

Is there a way to suppress "x rows affected" in SQLCMD from the command line?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Should I use uint in C# for values that can't be negative?

Common programming mistakes for Clojure developers to avoid

Attributions