DEV Community

Clever Cottonmouth
Clever Cottonmouth

Posted on

SQL SERVER

#sqlserver #database

COPY ALL DATA TO NEW TABLE 

SELECT a.* INTO newTable
FROM oldTable a;
Enter fullscreen mode Exit fullscreen mode

CAST 

CAST(columnName as VARCHAR)
CAST(columnName as INT)
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

mohamed_el_laithy profile image

How Pipe Syntax Fix SQL Design Problems

Mohamed El Laithy -

franckpachot profile image

Aurora Limitless - Collocation (and porting PgBench)

Franck Pachot -

roxana_haidiner profile image

Improve Your MySQL Database Design and Management with DbSchema

Roxana Maria Haidiner -

kishanempiric profile image

How to Choose the Right Database for Your Full Stack Project

Kishan Empiric -