Sql-Server-Query-World

OverviewSQL query performance improvement is a very thought-provoking topic between developers and the user community. Users always wants a fast response on their data retrieval action and developers put forth their best efforts to provide the data in the shortest

Read More

Below are the steps to send email from a database in Microsoft Sql Server:Step 1: Get the database default mail profile using the below query, if you don't have a database mail profile create one. DECLARE @defaultProfileName NVARCHAR(100)='' SELECT TOP

Read More

Query to check default Database Mail profile in SQL Server? SELECT TOP 1 name FROM msdb.dbo.sysmail_profile p JOIN msdb.dbo.sysmail_principalprofile pp ON pp.profile_id = p.profile_id AND pp.is_default = 1Suppose if you want to take the value in a variable then you

Read More