How to convert an integer field into a string field in sql server2000?

Do you want to temporarily change the output or change the field type in the data table?

If it is only output-time conversion, you can use CAST or CONVERT function to convert, for example:

Select CAST (the plastic field is nvarchar(20)).

Select transformation (nvarchar(20), plastic field)

If you want to change the field type to a string, you can use the statement or change it directly in the designer. If you use the statement, use:

ALTER TABLE table name ALTER column shaping field nvarchar(20)

1, I hope you don't need a specific holiday; You can be calm and happy every day.

2. May all vulgar greetings take effect on you.