SQL SERVER NOTES

Database Mail is a convenient and easy way to send alerts, reports, or data from SQL Server. Let's set it up step by step 1. Allow to use Database Mail XPs 2. Create SMTP-account, SMTP-profile and connect it together.

Hello! You are just a plain office worker, you often have to work with a lot of data. For example, you need to import 200 million rows of data into database - use bulk insert method

Hello, guys. In this article we will see how to export data from database to excel and vice versa using openrowset() function. We need to set up openrowset in the server. Below i'll show how I did it, but it's not necessary helps in your situation...