    UPDATE tbluser SET DateField = DATEADD(ss,numOfSeconds,DateField)

Note the first parameter &quot;ss&quot;.  This shows that you are adding seconds to the date.

[Check the docs][1] for more info.


  [1]: http://msdn.microsoft.com/en-us/library/ms186819.aspx

You should look into [DATEADD][1].

  [1]: http://msdn.microsoft.com/en-us/library/ms186819.aspx

`DATEADD (datepart , number , date)` 

or the full update syntax

`UPDATE tbl SET YourDateField = DATEADD (ss, 2, YourDateField)`

In my application, I want to create entries in certain tables when a new user signs up. For instance, I want to create a userprofile which will then reference their company and some other records for them. I implemented this with a post_save signal:

    def callback_create_profile(sender, **kwargs):
        # check if we are creating a new User
        if kwargs.get(&#39;created&#39;, True):
            user = kwargs.get(&#39;instance&#39;)
            company = Company.objects.create(name=&quot;My Company&quot;)
            employee = Employee.objects.create(company=company, name_first=user.first_name, name_last=user.last_name)
            profile = UserProfile.objects.create(user=user, employee=employee, partner=partner)
    # Register the callback
    post_save.connect(callback_create_profile, sender=User, dispatch_uid=&quot;core.models&quot;)

This works well when run. I can use the admin to create a new user and the other three tables get entries with sensible as well. (Except that is, the employee since the user.first_name and user.last_name aren&#39;t filled out in the admin&#39;s form when it saves. I still don&#39;t understand why it is done like that)

The problem came when I ran my test suite. Before this, I had created a bunch of fixtures to create these entries in the tables. Now I get an error that states:

    IntegrityError: duplicate key value violates unique constraint &quot;core_userprofile_user_id_key&quot;

I think this is because I have already created a company,employee and profile records in the fixture with id &quot;1&quot; and now the post_save signal is trying to recreate it.

My questios are: can I disable this post_save signal when running fixtures? Can I detect that I am running as part of the test suite and not create these records? Should I delete these records from the fixtures now (although the signal only sets defaults not the values I want to be testing against)? Why doesn&#39;t the fixture loading code just overwrite the created records?

How do people do this?

How do I prevent fixtures from conflicting with django post_save signal code?

&gt; **Possible Duplicate:**  
&gt; [How do I iterate through each element in an n-dimensional matrix in MATLAB?](https://stackoverflow.com/questions/758736/how-do-i-iterate-through-each-element-in-an-n-dimensional-matrix-in-matlab)  

&lt;!-- End of automatically inserted text --&gt;

I have a column vector `list` which I would like to iterate like this:

    for elm in list
       //do something with elm
How?

How to iterate over a column vector in Matlab?

This should be a softball for you SQL guys. I know I can add to an int field with something like `UPDATE tblUser SET Total=(Total+2)` but what is the syntax for adding seconds to a datetime field?

I&#39;m using SQLServer 2008

SQL Server: Add seconds to a datetime field?

<p>This should be a softball for you SQL guys. I know I can add to an int field with something like <code>UPDATE tblUser SET Total=(Total+2)</code> but what is the syntax for adding seconds to a datetime field?</p>
<p>I'm using SQLServer 2008</p>




I&#39;m trying to list the latest destination (MAX departure time) for each train in a table, [for example][1]:


    Train    Dest      Time
    1        HK        10:00
    1        SH        12:00
    1        SZ        14:00
    2        HK        13:00
    2        SH        09:00
    2        SZ        07:00

The desired result should be:

    Train    Dest      Time
    1        SZ        14:00
    2        HK        13:00

I have tried using

    SELECT Train, Dest, MAX(Time)
    FROM TrainTable
    GROUP BY Train

by I got a &quot;ora-00979 not a GROUP BY expression&quot; error saying that I must include &#39;Dest&#39; in my group by statement. But surely that&#39;s not what I want...

Is it possible to do it in one line of SQL?


  [1]: http://googledrive.com/host/0B53jM4a9X2fqfnRaUjZQOGhKd2pBbC1Yd1p5UmlJNTRQNEswWnNsZkVfS1p0NEVSSmtHUzA

GROUP BY with MAX(DATE)

How do I do this?

For example, if my column is &quot;cats,dogs,birds&quot; and I want to get any rows where column contains cats?

SQLite string contains other string query

I want a query to insert records from one table to another table in a different database if the destination table already exists, it should append the records at the end of the table.  

How to insert table values from one database to another database?

I&#39;m not sure where to start on addressing this issue but if I have a AJAX web application that sends requests to the server and runs long queries on the database (postgresql in my case), is there a way to stop or kill the queries if while still running, the user refreshes the page or closes the session...etc?


Stop (long) running SQL query in PostgreSQL when session or requests no longer exist?

I have a list like this:

    Red
    Red
    Brown
    Yellow
    Green
    Green
    Brown
    Red
    Orange

I am trying to do a SELECT UNIQUE with LINQ, i.e. I want

    Red
    Brown
    Yellow
    Green
    Orange

    var uniqueColors = from dbo in database.MainTable
                       where dbo.Property == true
                       select dbo.Color.Name;

I then changed this to

    var uniqueColors = from dbo in database.MainTable
                       where dbo.Property == true
                       select dbo.Color.Name.Distinct();

with no success. The first `select` gets ALL the colors, so how do I modify it to only get the unique values?

If there is a better way of structuring this query, more than happy to go that route.

How do I go about editing it so I can have `.OrderBy( &quot;column name&quot; )` i.e. alphabetically by color name, so name property?

I keep getting a message:

&gt; The type arguments cannot be inferred from the usage. Try specifying the type arguments explicitly.


How can I do SELECT UNIQUE with LINQ?

I have tried:

    ALTER TABLE MY_TABLE 
    ADD STAGE INT NOT NULL;

But it gives this error message:

&gt; ALTER TABLE only allows columns to be added that can contain nulls or
&gt; have a DEFAULT definition specified
           

insert a NOT NULL column to an existing table

I want to restore a database from a file (Tasks → Restore → Database; after I select from device and select file) via SQL Server Management Studio. 

After that, I get this error:

&gt; The operating system returned the error &#39;5(Access is denied.)&#39; while attempting
&#39;RestoreContainer::ValidateTargetForCreation&#39; on &#39;E:\Program Files\Microsoft SQL
 Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XXXXXX.mdf&#39;.
Msg 3156, Level 16, State 8, Server XXXX, Line 2

How do I fix this problem? Is it a security error?

mssql &#39;5 (Access is denied.)&#39; error during restoring database

In SQL Server we can type `IsNull()` to determine if a field is null.  Is there an equivalent function in PL/SQL?

What is the Oracle equivalent of SQL Server&#39;s IsNull() function?

Is there a way to generate MD5 Hash string of type varchar(32) without using fn_varbintohexstr

    SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes(&#39;MD5&#39;, &#39;email@dot.com&#39;)), 3, 32)

So it could be used inside a view with SCHEMABINDING

Generate MD5 hash string with T-SQL

If I use something like

    [ntext2] &lt;&gt; &#39;1,032.5&#39;,

I get this error:

&gt; The data types ntext and varchar are incompatible in the not equal to operator.

The best possible solution would be if comparison is implemented in the same way for any column type. (&lt;&gt; operator is applicable for both NVARCHAR and INT).


Content Type	Original Author	Original Content on Stackoverflow
Question	Unknown Coder	View Question on Stackoverflow
Solution 1 - Sql	Matthew Jones	View Answer on Stackoverflow
Solution 2 - Sql	Nate	View Answer on Stackoverflow

SQL Server: Add seconds to a datetime field?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

How to iterate over a column vector in Matlab?

How do I prevent fixtures from conflicting with django post_save signal code?

Attributions