DEV Community

Clever Cottonmouth
Clever Cottonmouth

Posted on

SQL SERVER

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

COUNT SUM OF MULTIPLE TABLE

SELECT SUM(K) AS Total_Row_Count
FROM (
SELECT COUNT(*) FROM TABLE1
UNION
SELECT COUNT(*) FROM TABLE2
) A;
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay