dev-resources.site

for different kinds of informations.

SQL SERVER

Published at

1/9/2025

Categories

sqlserver

database

Author

Clever Cottonmouth

Main Article

https://dev.to/mirajhad/sql-server-1643

Categories

2 categories in total

SQL SERVER

COPY ALL DATA TO NEW TABLE

SELECT a.* INTO newTable
FROM oldTable a;

CAST

CAST(columnName as VARCHAR)
CAST(columnName as INT)

COUNT SUM OF MULTIPLE TABLE

SELECT SUM(K) AS Total_Row_Count
FROM (
SELECT COUNT(*) FROM TABLE1
UNION
SELECT COUNT(*) FROM TABLE2
) A;

Articles

12 articles in total

Show query window at startup in SQL Server Management Studio

How to Set Custom Status Bar Colors in SSMS to Differentiate Environments

Visual Studio Code Extension for Developers

Applications for java Developers

.NET DEVELOPER TOOLS NEED TO INSTALL FOR NEWLY PC

currently reading

Fibonacci Series

To fetch the unique characters from a string?

Counts the occurrences of each character in the string and then prints the character along with its count in c#.

Find the number of occurrences for each character in a string in javascript

Featured ones:

abubakersiddique761