Use following syntax to create new table from old table in SQL server 2008

    Select * into new_table  from  old_table 


use `SELECT...INTO`

&gt; **The SELECT INTO statement creates a new table and populates it with
&gt; the result set of the SELECT statement.** SELECT INTO can be used to
&gt; combine data from several tables or views into one table. It can also
&gt; be used to create a new table that contains data selected from a
&gt; linked server.

Example,


    SELECT col1, col2 INTO #a -- &lt;&lt;== creates temporary table
    FROM   tablename

- [Inserting Rows by Using SELECT INTO](http://msdn.microsoft.com/en-us/library/ms190750.aspx)

Standard Syntax,


    SELECT  col1, ....., col@      -- &lt;&lt;== select as many columns as you want
            INTO [New tableName]
    FROM    [Source Table Name]



Please be careful,
MSSQL: `&quot;SELECT * INTO NewTable FROM OldTable&quot; `

is not always the same as 
MYSQL: `&quot;create table temp AS select..&quot;`

I think that there are occasions when this (in MSSQL)
does not guarantee that all the fields in the new table are of the same type as the old.

For example :

    create table oldTable (field1 varchar(10), field2 integer, field3 float)
    insert into oldTable (field1,field2,field3) values (&#39;1&#39;, 1, 1)
    select top 1 * into newTable from oldTable

does not always yield:

    create table newTable (field1 varchar(10), field2 integer, field3 float)

but may be:

    create table newTable (field1 varchar(10), field2 integer, field3 integer)



Please try:

    SELECT * INTO NewTable FROM OldTable

Try using SELECT INTO....

    SELECT ....
    INTO     TABLE_NAME(table you want to create)
    FROM source_table
    

    Select [Column Name] into [New Table] from [Source Table]

When I create a project in JetBrains WebStorm, a folder called `.idea` gets created. Is it okay if I delete it? Will it affect my project? 

What is the .idea folder?

I have a `list` of filenames in python and I would want to construct a `set` out of all the filenames.

    
    filelist=[]
    for filename in filelist:
        set(filename)

This does not seem to work. How can do this?



How to construct a set out of list items in python?

I want to create a table from select query result in SQL Server, I tried 

    create table temp AS select.....

but I got an error 

&gt; Incorrect syntax near the keyword &#39;AS&#39;


How to create a table from select query result in SQL Server 2008

I want to create a table from select query result in SQL Server, I tried
<pre><code class="hljs language-lua">create table temp AS select.....
</code></pre>
but I got an error
> Incorrect syntax near the keyword 'AS'

I am using this query to rename the database:

    ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted]

But it shows an error when excuting:

&gt; Msg 5030, Level 16, State 2, Line 1     
&gt; The database could not be exclusively locked to perform the operation.

Is anything wrong with my query?


Error on renaming database in SQL Server 2008 R2

How do I write an SQL query to count the total number of a specific num value in the num column of a table?

Assuming we have the following data.

|NAME|NUM|
|-|-|
|SAM|1|
|BOB|1|
|JAKE|2|
|JOHN|4|

Take the following query:
```sql
SELECT WHERE num = 1;
```
This would return these two rows.

|NAME|NUM|
|-|-|
|SAM|1|
|BOB|1|

Count how many rows have the same value

Like the `--disable-column-names` option, do we have an option to get the SQL query without the table format? For example:

```
mysql -u username -p password  --disable-column-names --execute &quot;select name from test&quot;
```

results below:

    -----
    | A |
    | B |
    | C |
    | D |
    -----

Is it possible to get the query result using some sql program option modifiers as below, **without the table format**?

I want this:

    A
    B
    C
    D


Get the SQL query result without the table format

I&#39;m working on a game which involves vehicles at some point. I have a MySQL table named &quot;vehicles&quot; containing the data about the vehicles, including the column &quot;plate&quot; which stores the License Plates for the vehicles.

Now here comes the part I&#39;m having problems with. I need to find an unused license plate before creating a new vehicle - it should be an alphanumeric 8-char random string. How I achieved this was using a while loop in Lua, which is the language I&#39;m programming in, to generate strings and query the DB to see if it is used. However, as the number of vehicles increases, I expect this to become even more inefficient it is right now. Therefore, I decided to try and solve this issue using a MySQL query.

The query I need should simply generate a 8-character alphanumeric string which is not already in the table. I thought of the generate&amp;check loop approach again, but I&#39;m not limiting this question to that just in case there&#39;s a more efficient one. I&#39;ve been able to generate strings by defining a string containing all the allowed chars and randomly substringing it, and nothing more. 

Any help is appreciated.

Generating a random &amp; unique 8 character string using MySQL

Is it necessary to use `#` before creating a temporary table in SQL server?

Example:

    
    SELECT column1, column2, someInt, someVarChar 
    INTO ItemBack1 
    FROM table2
    WHERE table2.ID = 7


For ItemBack1 is it necessary to use the `#` symbol? 

If not, then what is the use of `#` in creating temp tables?

Is it necessary to use # for creating temp tables in SQL server?

I have a string that is up to 3 characters long when it&#39;s first created in SQL Server 2008 R2.

I would like to pad it with leading zeros, so if its original value was &#39;1&#39; then the new value would be &#39;001&#39;. Or if its original value was &#39;23&#39; the new value is &#39;023&#39;. Or if its original value is &#39;124&#39; then new value is the same as original value.

I am using SQL Server 2008 R2. How would I do this using T-SQL?

Pad a string with leading zeros so it&#39;s 3 characters long in SQL Server 2008

I have developed a query, and in the results for the first three columns I get `NULL`.  How can I replace it with `0`? 

      Select c.rundate, 
        sum(case when c.runstatus = &#39;Succeeded&#39; then 1 end) as Succeeded, 
        sum(case when c.runstatus = &#39;Failed&#39; then 1 end) as Failed, 
        sum(case when c.runstatus = &#39;Cancelled&#39; then 1 end) as Cancelled, 
        count(*) as Totalrun from
        (    Select a.name,case when b.run_status=0 Then &#39;Failed&#39; when b.run_status=1 Then &#39;Succeeded&#39;
        when b.run_status=2 Then &#39;Retry&#39; Else &#39;Cancelled&#39; End as Runstatus,
        ---cast(run_date as datetime)
                    cast(substring(convert(varchar(8),run_date),1,4)+&#39;/&#39;+substring(convert(varchar(8),run_date),5,2)+&#39;/&#39;          +substring(convert(varchar(8),run_date),7,2) as Datetime) as RunDate
        from msdb.dbo.sysjobs as a(nolock) inner join msdb.dbo.sysjobhistory as b(nolock) 
        on a.job_id=b.job_id
        where a.name=&#39;AI&#39;
        and b.step_id=0) as c
        group by 
        c.rundate

Replacing NULL with 0 in a SQL server query

I&#39;m trying to perform an update and a select ... basically, update based on an index, and then select the row id that was updated.

This is simple using the OUTPUT clause:

    UPDATE Foo
    SET Bar = 1
    OUTPUT INSERTED.Id
    WHERE Baz = 2

But now, how do I get this into a variable?

    DECLARE @id INT

These three don&#39;t work:

    UPDATE Foo
    SET Bar = 1
    OUTPUT @id = INSERTED.Id
    WHERE Baz = 2

    SET @id =
    (UPDATE Foo
     SET Bar = 1
     OUTPUT INSERTED.Id
     WHERE Baz = 2)

    SET @id =
    (SELECT Id FROM (UPDATE Foo
                     SET Bar = 1
                     OUTPUT INSERTED.Id Id
                     WHERE Baz = 2) z)

That last one included because it had me temporarily excited when all the red squigglies went away in Management Studio. Alas, I get this error:

    A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in a SELECT statement that is not the immediate source of rows for an INSERT statement.

UPDATE OUTPUT into a variable

I have a query in `SQL`, I have to get a date in a format of `dd/mm/yy` 

Example: `25/jun/2013`. 

How can I `convert` it for `SQL server`?

Convert Date format into DD/MMM/YYYY format in SQL Server

I&#39;ve got a table with two columns, `ID` and `Value`. I want to change a part of some strings in the second column.

Example of Table:

&lt;!-- language: lang-none --&gt;

    ID            Value
    ---------------------------------
    1             c:\temp\123\abc\111
    2             c:\temp\123\abc\222
    3             c:\temp\123\abc\333
    4             c:\temp\123\abc\444

Now the `123\` in the `Value` string is not needed. I tried `UPDATE` and `REPLACE`:

    UPDATE dbo.xxx
    SET Value = REPLACE(Value, &#39;%123%&#39;, &#39;&#39;)
    WHERE ID &lt;= 4

When I execute the script SQL Server does not report an error, but it does not update anything either. Why is that?


UPDATE and REPLACE part of a string

I&#39;ve written a very simple JDBC login test program. And after all kinds of problems I&#39;ve almost got it working. Almost, just can&#39;t seem to get past this problem:

&gt; SQLServerException: Login failed for user xxxxx

I created a simple database PersonInfo then I created user user1 password1 (SQL authentication). And after trying everything was unable to connect to the database.

I am using SqlServer2008 on Win 7, I&#39;ve got the latest JDBC driver from Microsoft. 

My code is:

    import java.sql.*;
    
    public class hell {
    public static void main(String[] args) {
    	
    	try {
    		Class.forName(&quot;com.microsoft.sqlserver.jdbc.SQLServerDriver&quot;).newInstance();
    Connection conn=  DriverManager.getConnection(&quot;jdbc:sqlserver://localhost:1433;databaseName=PersonInfo;user=Sohaib;password=0000;&quot;);
    
    
    System.out.println(&quot;connected&quot;);
           }
    
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    }


Here&#39;s the Exception  

    Exception: Unable to get connect
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user &#39;Sohaib&#39;.
    and all other supporting errors.

SqlServer: Login failed for user

I&#39;m trying to **add custom time to datetime in SQL Server 2008 R2**.

Following is what I&#39;ve tried. 

    SELECT DATEADD(hh, 03, DATEADD(mi, 30, DATEADD(ss, 00, DATEDIFF(dd, 0,GETDATE())))) as Customtime

Using the above query, I&#39;m able to achieve it.  

But is there any shorthand method already available to add custom time to datetime?

Content Type	Original Author	Original Content on Stackoverflow
Question	yogesh9239	View Question on Stackoverflow
Solution 1 - Sql	Sanjeev Rai	View Answer on Stackoverflow
Solution 2 - Sql	John Woo	View Answer on Stackoverflow
Solution 3 - Sql	mssql-mysql	View Answer on Stackoverflow
Solution 4 - Sql	TechDo	View Answer on Stackoverflow
Solution 5 - Sql	Rebika	View Answer on Stackoverflow
Solution 6 - Sql	Prabhash Jha	View Answer on Stackoverflow

How to create a table from select query result in SQL Server 2008

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Solution 5 - Sql

Solution 6 - Sql

How to construct a set out of list items in python?

What is the .idea folder?

Attributions