sqldba_icon (6/9/2011)
Lowell (6/9/2011)
here's the full reference to Cast And Convert; it's good to read, it's something you end up using a lothttp://msdn.microsoft.com/en-us/library/ms187928.aspx
Select
convert(nvarchar(max),TheNTextColumn) AsColumnName
From TableName
I need to convert and replace with varchar data type. Dont i need to run an update statement after i change?
update dbo.mytable set mycolumn = mycolumn
?
If you are changing the column data type at the table definition, then no you will not need to run an update statement after you change the datatype.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events