Use the &quot;Design&quot; function in SQL Server Management Studio to generate the ALTER script for you:

* Right-click on the table you want to alter and choose Design.
* Add new columns, change field types, set your fields to accept NULLS or not, etc. 
* Once you are done, click the Generate Change Script toolbar button (or right-click on any column or in the white space).  This button looks like a floppy disk hovering over a piece of curled paper
* Save the result to a text file

Depending on how you have your SSMS options set, this may not be available initially if the changes require tables to be dropped and re-created.  To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.


1) Right-click on the table you want to alter and choose Design

2) Add your new columns, change the field types, set your fields to accept NULLS or not, etc.

**Important:** Don&#39;t save your changes now

3) Do a right-click on any column or in the white space and you’ll see the option Generate Change Script is now available.

In SQL Server Management Studio 2016, toolbar button icon has changed. See the highlighted new icon. 

[![New Icon for Generate Change Script][1]][1]

[1]: https://i.stack.imgur.com/iQOPV.png

1. You can access this dialog box after you have made unsaved changes to a table in Table Designer. On the Table Designer menu, click Generate Change Script.

2.Automatically generate change script on every save
If checked, the Save Change Script dialog box will appear any time you save changes to a table.

**Yes**
Bring up the Save dialog box where you can choose the location for the text file.

**No**
Cancel the creation of the change script.

I am trying [Spring data JPA][1] in my project. I want to know if there is an out-of-the-box API to query data, by both `Sort` and `Pageable`. Of course, I know I can write that method myself, I just want to know if there is an out-of-the-box one. My DAO extends `JpaRepository`, and I found there are the following methods I can invoke:

    findAll();
    findAll(Pageable pageable);
    findAll(Sort sort);

But there is no such method as `findAll(Sort sort, Pageable pageable)`, so I am curious.


  [1]: http://www.springsource.org/spring-data/jpa

How to query data out of the box using Spring data JPA by both Sort and Pageable?

By suitable, I mean:

 - mature and used extensively
 - rich widget set that renders well
 - idiomatic Scala
 - Got a WYSIWYG-ish but flexible GUI builder
 - standalone API documentation (if a wrapper, it shouldn&#39;t make me refer the parent project in another language)

In no particular order.

Which GUI toolkits satisfy which conditions?



Suitable GUI framework for Scala?

I want to script a table as Alter to a New Query Editor Window. But this option is disabled. How can I do this?

Right click script alter table disabled in SQL Server Management Studio

<p>I want to script a table as Alter to a New Query Editor Window. But this option is disabled. How can I do this?</p>


I want to determine if a value is integer (like `TryParse` in .NET). Unfortunatelly `ISNUMERIC` does not fit me because I want to parse only integers and not every kind of number. Is there such thing as `ISINT` or something?

Here is some code to make things clear. If `MY_FIELD` is not int, this code would fail:

    SELECT @MY_VAR = CAST(MY_FIELD AS INT)
    FROM MY_TABLE
    WHERE MY_OTHER_FIELD = &#39;MY_FILTER&#39;

Thank you

T-sql - determine if value is integer

I want to export my big SSMS (SQL Server Management Studio) query result (2.5m lines, 9 fields) as .csv or comma-delimited .txt (with headings). (MS SQL Server 2005 Management Studio.)

So that I can then either read it line-by-line into VBA program (to do certain calculations on the data) or do queries on it in Excel (e.g. with Microsoft Query). The calculations are complicated and I prefer to do it somewhere else than SSMS. 

If I choose ‘query result to text’ in SSMS and a small answer (few lines e.g. up to 200k) I could of course simply copy and paste to a text editor. For my large answer here I could of course copy and paste 200k or so lines at a time, 10 times, into a text editor like Ultra-Edit. (When I try all 2.5m at once, I get a memory warning inside SSMS.) But for the future I’d like a more elegant solution.

For ‘query result to file’, SSMS writes to an .rpt file always.  (When you right-click in the results window and choose ‘save as’, it gives a memory error just like above.) 

--&gt; So it looks like my only option is to have SSMS output its result to a file i.e. .rpt and then afterwards, convert the .rpt to .txt.

I assume this .rpt is a Crystal Reports file? Or isn&#39;t it. I don’t have Crystal Reports on my PC, so I cannot use that to convert the file.

When opening the .rpt in Ultra-Edit it looks fine. However in Microsoft Query in Excel, the headings doesn’t want to show.

When I simply read &amp; write the .rpt using VBA, the file halves in size. (330meg to 180meg). In Microsoft Query the headings do show now (though the first field name has a funny leading character, which has happened to me before in other totally different situations). I do seem to be able to do meaningful pivot tables on it in Excel.

However when I open this new file in Ultra-Edit, it shows Chinese characters! Could there still be some funny characters in it somewhere?

--&gt; Is there perhaps a free (and simple/ safe) converter app available somewhere. Or should I just trust that this .txt is fine for reading into my VBA program.

Thanks

Convert SSMS .rpt output file to .txt/.csv

I&#39;m trying to do the Code First Walkthrough of the entity framework ( http://blogs.msdn.com/b/adonet/archive/2011/09/28/ef-4-2-code-first-walkthrough.aspx ).

I have the latest SQL Server Express and when I check my versions available via command line (*sqllocaldb info*): I see localdbApp1 and v11.0.  When I try to run the walkthrough with a few minor tweaks, I get a can&#39;t connect error.

My app.config looks like this:

    &lt;parameter value=&quot;Server=(LocalDB)\v11.0; Integrated Security=True; MultipleActiveResultSets=True&quot; /&gt;

I wrote a simple connection test like below and the code returns the same SQL Connection error ((provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)). 

    new System.Data.SqlClient.SqlConnection(&quot;Data Source=(LocalDB)\v11.0; Integrated Security=True; MultipleActiveResultSets=True&quot;).Open();

I&#39;ve tried replacing `&quot;Data Source=...&quot;` with `&quot;Server=...&quot;` but to no avail there.

Any ideas what the connection string should be?

What is the connection string for localdb for version 11

I was looking for a `CONCAT` function in SQL Server 2008 R2. I [found the link  for this function][1]. But when I use this function, it gives the following error:

&gt; Msg 195, Level 15, State 10, Line 7  
&gt; &#39;CONCAT&#39; is not a recognized built-in function name.

Does the `CONCAT` function exists in SQL Server 2008 R2?

If not, how do I concatenate strings in SQL Server 2008 R2?


  [1]: http://msdn.microsoft.com/en-us/library/hh231515.aspx

How do I use the CONCAT function in SQL Server 2008 R2?

I have a table like this

    Value   String
    -------------------
    1       Cleo, Smith

I want to separate the comma delimited string into two columns

    Value  Name Surname
    -------------------
    1      Cleo   Smith

I need only two fixed extra columns 


How to split a comma-separated value to columns

I am using SQL Server Management Studio. 

I wish to save the results of a query to an excel file.  

I choose &quot;save as&quot; and then save to CSV file which I can open in excel. All good except I am missing column headers, any ideas how I get them exported?

Saving results with headers in SQL Server Management Studio

Or, to put it another way, where is SqlStudio.bin for SQL Server 2012? It doesn&#39;t seem to be in the place that would be expected by looking at [this other SO question](https://stackoverflow.com/questions/1059105).


How to remove cached server names from the Connect to Server dialog?

I just installed **SQL Server 2012 Express**, I can connect with database from **`VS2012RC`**. 

Database is working :) I use **`Win7 SP1 64bit`**.

**[I download program from page](http://www.microsoft.com/en-us/download/details.aspx?id=29062)**
I choose `ENU\x64\SQLManagementStudio_x64_ENU.exe`

I want to install **Management Studio 2012**, but after unpack installer has stopped. I see only for moment some console application. 

1. What could be cause? 
2. Where can I find any log file?

How to install SQL Server Management Studio 2012 (SSMS) Express?

How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio?  By default, it only seems to return the first few hundred characters (255?) but sometimes I just want a quick way of viewing the whole field, without having to write a program to do it. Even SSMS 2012 still has this problem :(


How do you view ALL text from an ntext or nvarchar(max) in SSMS?

I am using a query to alter the charset of a column


    ALTER TABLE `media_value_report` 
        CHANGE `index_page_body` `index_page_body` TEXT CHARACTER  
        SET utf8 NULL DEFAULT NULL

i want to do this for other columns  main_title, landing_page_body as well. But am getting a #1064 error while executing. Can i alter-change multiple columns in  a single query?

I tried but i found in goog search that is not possible to alter in a single query. 



Alter multiple columns in a single statement

MySQL very slow for alter table query

Given the table created using: 

    CREATE TABLE tbl_Country
    (
      CountryId INT NOT NULL AUTO_INCREMENT,
      IsDeleted bit,
      PRIMARY KEY (CountryId) 
    )

How can I delete the column `IsDeleted `?

How to delete a column from a table in MySQL

I know, we can not rename a column using `modify column syntax`,but can `change column syntax`.

My question is: what is the main usage of `modify syntax`?

For example,&lt;br /&gt;

    alter table tablename change col1 col1 int(10) not null
instead of 

    alter table tablename modify col1 int(10) not null

&lt;br /&gt;
&lt;br /&gt;
**Edited**&lt;br /&gt;
Question replaced&lt;br /&gt;

What is the main usage of `modify syntax`?

Above question was replaced by below

Why we have to use change column instead of modify column?

Modify column Vs change column

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL.

    ALTER TABLE table_name RENAME COLUMN old_name to new_name;

This statement doesn&#39;t work.



Content Type	Original Author	Original Content on Stackoverflow
Question	Himanshu Jansari	View Question on Stackoverflow
Solution 1 - Sql Server	bhupendra patel	View Answer on Stackoverflow
Solution 2 - Sql Server	VladL	View Answer on Stackoverflow
Solution 3 - Sql Server	Ravi Selvaraj	View Answer on Stackoverflow
Solution 4 - Sql Server	Amirhossein	View Answer on Stackoverflow

Right click script alter table disabled in SQL Server Management Studio

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Suitable GUI framework for Scala?

How to query data out of the box using Spring data JPA by both Sort and Pageable?

Attributions