SQL Server – Reason for stored procedure not returning any data
Following could be reason(s): 1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure…
Category: T-SQL
SQL Server Agent – How to enable SQL Agent Job using T-SQL script
USE MSDB; GO –Declaring Variable DECLARE @job_id UNIQUEIDENTIFIER DECLARE @Cnt INT DECLARE @Min INT –Declaring Table Variable DECLARE @SQLAgentJob (…
SQL Server Agent – How to disable SQL Agent Job using T-SQL script
To do unattended tasks like if error comes need to disable the job. In this case, we need to disable…
SQL Server High Availability – How to capture Server(s) status whether it is online or offline using T-SQL programming
Below is an example to capture Server(s) status whether it is online or offline. We are using XP_CMDSHELL extended stored…
SQL Server – How to pull data from Source table to Target table ensuring it will pull only data which is not present in Target table.
To achieve the requirment of loading data from Source table to Target table with ensuring it will pull only data…
SQL Server – How to get data from multiple linked server
We can use a stored procedure/T-SQL statements having linked server & DB name as variables to get the data dynamically…
Explanation of SQL Server Error Message – “String or binary data would be truncated”
The error message “String or binary data would be truncated” tells we are trying to put a longer string into…
SSRS – How to remove the duplicate values from the report input parameter
If we are using ar eport parameter which is duplicate values. you can remove duplicate records by using T-SQL DISTINCT…