SQL Server Variables, Import Excel Data into SQL Server, Expand a Range of Dates and Conditional SQL Logic (MSSQLTips 12/21/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQLGrease - Built by Performance Experts, Not Elves]( [The Basics of SQL Server Variables]( [The Basics of SQL Server Variables]( In this article, we look at the basics of using SQL Server variables in T-SQL code to allow for more dynamic code creation.... [Import Data from an Excel file into a SQL Server Database using Python]( [Import Data from an Excel file into a SQL Server Database using Python]( Learn how to import data from an Excel file into a SQL Server database using Python.... [SQLGrease Does What Santa Can't]( [SQLGrease Does What Santa Can't]( SQLGrease greatly simplifies finding the root cause of performance problems. Try SQLGrease free to see how it can help you track down the most difficult performance problems....... [How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES]( [How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES]( In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows....... [Quickly Deploy SQL Server on Linux]( [Quickly Deploy SQL Server on Linux]( Learn how to quickly deploy a SQL Server on Linux (standalone) on Ubuntu (Linux) using AWS Launch Wizard....... [Differences with Delete vs Truncate in SQL Server]( [Differences with Delete vs Truncate in SQL Server]( In this article, we look at a comparison of the SQL Server DELETE and TRUNCATE commands and when and how to use these commands to delete data....... [Deep SQL Query Optimization]( [Deep SQL Query Optimization]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications....... [Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF ]( [Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF]( Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic....... [SQL Server Data Masking]( [SQL Server Data Masking]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how Db...... [By Mohammed Moinudheen - ]( [Setup SQL Server Database Mail to use a Gmail, Hotmail, or Outlook account]( Database Mail | Configuration - In this tip we will walk through how you can setup SQL Server Database Mail to use email services like Gmail, Hotmail or Outlook. ... [By Ken Simmons - ]( [The Many Uses of Coalesce in SQL Server]( Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of... [By Nat Sundar - ]( [Importing JSON Files Using SQL Server Integration Services]( In this tip we look at how to import JSON files using SQL Server Integration Services.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}