SQL server for help-CodePudding

SQL server data types cannot change what reason be

CodePudding user response:

Delete all the data can be changed, or SQL statements can be used to change

CodePudding user response:

reference 1st floor ManBOyyy response:

delete all data can be changed, or SQL statements can be used to change the

Only these two methods? If so what is the advantage of SQL server trouble

CodePudding user response:

The alter table tab1 alter column col1 int language change, if can't change because of do not conform to the changed data exist, need is not in conformity with the requirements of data deleted first

CodePudding user response:

refer to the end of the second floor of the fire response:

Quote: refer to 1st floor ManBOyyy response:
delete all data can be changed, or SQL statements can be used to change the

Only these two methods? If so what is the advantage of SQL server trouble

Advantage in this respect, this is not a two words can say, a word with the mainstream is right

CodePudding user response:

SQL server because of security problems, restrict the user to modify the data type, but in setting can be set up, and then can modify types

CodePudding user response:

In the SQL management "tools" - "" options" - "" designer" - "" table designer and database designer", "stop the save the request to create a table of changes" in front of the box, "sure", can literally change the data type of the field

CodePudding user response:

reference 1st floor ManBOyyy response:

delete all data can be changed, or SQL statements can be used to change the

Bosses how the two tables of data from the SQL server database to add and delete

CodePudding user response:

refer to the end of the 7th floor of the fire response:

Quote: refer to 1st floor ManBOyyy response:
delete all data can be changed, or SQL statements can be used to change the

Bosses how the two tables of data from the SQL server database to add and delete

This question, refer to books, SQL will be written in the book is clear

CodePudding user response:

You learn about ado.net

CodePudding user response:

refer to the end of the 7th floor of the fire response:

Quote: refer to 1st floor ManBOyyy response:
delete all data can be changed, or SQL statements can be used to change the

Bosses how the two tables of data from the SQL server database to add and delete

Database to delete?

CodePudding user response:

To search the database to add and delete have a pile

CodePudding user response:

Is refers to the Table Column, this situation often happens in originally is the string field into a numeric fields, because the data in the field as long as there is a line of string cannot be converted to numeric fields,

Solution: the originally old Table name
Generate a new Table schema you want
Insert into the old information to the new Table

CodePudding user response:

The most stupid way, all the data in the table to empty, so you can modify the data type