0

I have a table tblemp with column 'value' of type 'varchar' in that column i have a cell named 'bankname' . I want to make 'bankname' of type nvarchar. How can i do that?

Joshi2dec
  • 1
  • 2
  • 1
    Tables have columns. Is bankname a column? – jarlh Jan 31 '20 at 09:56
  • 1
    https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/ – jarlh Jan 31 '20 at 09:56
  • Columns have datatypes not "cells". Cells do no exist in SQL Server; that's something you'll find in a (Excel) worksheet. A single column can only contain one datatype, not many. If you want to change the data type of a value stored in a column, you have to change the **entire** column. If you are mixing data types in a column, you have a design flaw and should likely have 2+ columns (1 for each different type of data item). – Thom A Jan 31 '20 at 09:59

0 Answers0