How to create a SQL Server function? For example, the SQL Server function below takes the customer number as a parameter and returns the customer name. Indeed, the function stores the customer name in the Customer Name variable, and it returns it as a result. How to create a SQL …
How to check if a SQL Server table exists before delete? How to drop it only if the existence check shows it already exists in the database to avoid errors, using the DROP TABLE keyword. Indeed when running long SQL scripts or running scripts twice, it is much better to …
How to remove SQL Server new line? This post propose a simple SQL Server query to process a string variable and remove the new line character. Technically we replace the new line by nothing. The SQL Server code for a new line is CHAR(13)+CHAR(10). You want to remove it to …
2017 - 2020 - Expert-Only.net - SQL Server queries © All rights reserved.