T-SQL function to convert comma separated values into rows of table
Below is the tabular function that converts comma or semi colon separated values of a string into rows of a…
Year: 2013
Sample Test Case Document
TestCase ID Title Prerequisites Test Steps Expected results Actual Result Result (Pass/Failed) Review Comments
How to enable SSIS package logging for SQL Server
1. Background The purpose of this document is to describe how to enable SSIS package logging for SQL Server. 2. …
Overview of SQL Server BI Model
SQL Server Business Intelligence Model basically consists of four main services i.e. SQL Server Relational services, Integration Services, Analysis Services…
How to get the DDMMYYYYHHMMSSMMM and YYYYMMDDHHMMSSMMM date formats in SQL Server.
Below are the SQL statements by which we can get the required formats: DDMMYYYYHHMMSSMMM format : SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(),…
How to store and retrieve the Image data directly from SQL Server Table
1. Background The purpose of this article is to describe a way of storing the Image data into SQL Server…
How to script all the SQL Agent Jobs in a single script file
Background The purpose of this article is to provide a way of scripting out all the SQL Agent jobs in…
SQL Server – How to select a row randomly from a table
/************************************************************************* * Title : How to select a row from a table randomly * Solution : We can get the…
How to get list of all the failed SQL Agent Jobs in SQL Server
/*************************************************************************** * Title : How to find the list of all the failed SQL Jobs in SQL Server * Problem…
Write a T-SQL script to shrink the Transaction Log file of SQL Server Database
For shrinking the transaction log of any SQL Server database, simply run the below script on that database: USE YourDatabase_Name…
SQL Database Backups using T-SQL
1. Background This article describes and helps the users to take different types of SQL database backups using T-SQL script.…
T-SQL Programing Questions
1) If we have a table with a column named EmailID that contains emailIDs like Ram.sharma@gmail.com Shayam.singh@gmail.com How to get…