    UPDATE tblKit
    SET number = REPLACE(number, &#39;KIT&#39;, &#39;CH&#39;)
    WHERE number like &#39;KIT%&#39;

- [SQLFiddle Demo](http://sqlfiddle.com/#!3/cac38/1)

or simply this if you are sure that you have no values like this `CKIT002`

    UPDATE tblKit
    SET number = REPLACE(number, &#39;KIT&#39;, &#39;CH&#39;)

- [SQLFiddle Demo](http://sqlfiddle.com/#!3/348e3/1)

I don&#39;t have use for the menu and tools bars in gvim on Windows; Can I hide them?

This will give more space to the text area.


![enter image description here][1]


  [1]: http://i.stack.imgur.com/ImpLH.png

How to hide the menu/tool bar of gvim?

When you implement SpinnerAdapter you get [getDropDownView][1], how does it differ from `getView` which you have when you need to extend `BaseAdapter`.


  [1]: http://developer.android.com/reference/android/widget/SpinnerAdapter.html#getDropDownView%28int,%20android.view.View,%20android.view.ViewGroup%29

Difference between getView &amp; getDropDownView in SpinnerAdapter

I have a table `TblKit` that has columns `Id` and `Number`. `Id` is `primary key` of type `int` and `Number` is `varchar(50)`. 

The data in the table looks like this: 

    Id     Number
    ---    ------
    1      KIT001
    2      KIT002 
    3      DMB001
    4      DM002
    5      KIT003

I want to replace all the rows of `KIT%` with `CH` in the Number field. The desired output would look like:

    Id     Number
    ---    ------
    1      CH001
    2      CH002 
    3      DMB001
    4      DM002
    5      CH003

I have tried this update query: 

    UPDATE TblKit SET Number = REPLACE(Number, N&#39;%KIT%&#39;, &#39;CH&#39;) 

But it is not working. 

Can anyone help me regarding this? 

SQL Server find and replace specific word in all rows of specific column

I have a table <code>TblKit</code> that has columns <code>Id</code> and <code>Number</code>. <code>Id</code> is <code>primary key</code> of type <code>int</code> and <code>Number</code> is <code>varchar(50)</code>.
The data in the table looks like this:
<pre><code class="hljs language-diff">Id Number
--- ------
1 KIT001
2 KIT002 
3 DMB001
4 DM002
5 KIT003
</code></pre>
I want to replace all the rows of <code>KIT%</code> with <code>CH</code> in the Number field. The desired output would look like:
<pre><code class="hljs language-diff">Id Number
--- ------
1 CH001
2 CH002 
3 DMB001
4 DM002
5 CH003
</code></pre>
I have tried this update query:
<pre><code class="hljs language-ini">UPDATE TblKit SET Number = REPLACE(Number, N'%KIT%', 'CH') 
</code></pre>
But it is not working.
Can anyone help me regarding this?

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 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 am using SQL Server 2008 R2 Standard (version 10.50.1600.1) for my production website and 
SQL Server Express edition with Advanced Services (v10.50.1600.1) for my localhost as a database.

Few days back my SQL Server crashed and I had to install a new 2008 R2 Express version on my localhost. It worked fine when I restored some older versions taken from Express edition but when I try to restore database from `.bak` file which is taken from production server it is causing the following error:

&gt; *Error: Specified cast is not valid. (SqlManagerUI)*

and when I try to restore the database using command 

    Use Master
    Go
    RESTORE DATABASE Publications
    FROM DISK = &#39;C:\Publications.bak&#39;
    WITH MOVE &#39;Publications&#39; TO &#39;C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008R2\MSSQL\DATA\Publications.mdf&#39;,--adjust path
    MOVE &#39;AlPublications_log&#39; TO &#39;C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008R2\MSSQL\DATA\Publications.ldf&#39;

It generates a different error 

&gt; *Msg 3154, Level 16, State 4, Line 1  
&gt; The backup set holds a backup of a database other than the existing &#39;Publications&#39; database.  
&gt; Msg 3013, Level 16, State 1, Line 1  
&gt; RESTORE DATABASE is terminating abnormally.*

I have cross checked the versions. They all seem matching to me as shown in the image below

Previously I was able to restore a database from standard version to express edition but now it fails. I deleted the database and tried to recreate it. That fails, too.

I am not sure what I am doing wrong. I would appreciate help in this regarding 


**Issue was resolved** as it seems .bak file was corrupt. When I tried it with a different file it worked.

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

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 am getting the following error

    Cannot execute as the database principal because the principal &quot;dbo&quot; 
    does not exist, this type of principal cannot be impersonated,
    or you do not have permission.

I read about `ALTER AUTHORIZATION`, but I have no idea what database this is happening in. This error is getting spit out very frequently, and grows the error log by about 1GB every day. 

SQL Server principal &quot;dbo&quot; does not exist,

I need to drop the primary key of a table `Student` in a SQL Server database.

I have edited in the table and the script I got is
  
    ALTER TABLE dbo.Student
    	DROP CONSTRAINT PK__Student__9CC368536561EF8B

But when I run this script in SQL Server query browser to drop the primary key

It shows the message

&gt; *Msg 3728, Level 16, State 1, Line 1  
&gt; &#39;PK\_\_Student\_\_9CC368536561EF8B&#39; is not a constraint.  
&gt; Msg 3727, Level 16, State 0, Line 1*

To my concern I think `PK__Student__9CC368536561EF8B` this will be generated randomly
please help me to drop the primary key constraint using **script**.

Thanks in advance


Content Type	Original Author	Original Content on Stackoverflow
Question	Dev	View Question on Stackoverflow
Solution 1 - Sql	John Woo	View Answer on Stackoverflow

SQL Server find and replace specific word in all rows of specific column

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Difference between getView & getDropDownView in SpinnerAdapter

How to hide the menu/tool bar of gvim?

Attributions