Product:
Microsoft SQL server
Issue:
How check if a column can be converted to numeric from string?
Solution:
Start SSMS and enter below SQL code to list rows that is not convertable to numbers:
select TOP (1000) * FROM [schemaname].[tablename] where ISNUMERIC (columname) = 0
Below code to make a full copy of a table:
SELECT * INTO newtable FROM oldtable WHERE condition;
Below code to only list rows where the column content is above 15 charcters:
select TOP (1000) * FROM [schemaname].[tablename] where LEN (columnname) >= 15
More Information:
https://www.w3schools.com/sql/sql_select_into.asp
https://www.airops.com/sql-guide/how-to-check-length-string-sql
https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16