Implementing a Pivot Transformation Using Data Flow Activity – Azure Data Factory Using Azure Data Factory you can create a data flow for Pivot transformation.… Read More »Azure Data Factory Pivot Transformation Using Data Flow
How to change the Collation of table column to Case insensitive or Case sensitive? Lets prepare a sample table called DumpData, and insert few records… Read More »SQL change column collation to case sensitive
How to copy or delete files from directory in SQL Server ? It can be done using xp_cmdshell which is SQL Server built in system… Read More »Copy or delete files from directory in SQL Server
How to get a last access time for tables in SQL Server ? To get the last time when table was accessed in SQL Server,… Read More »Get a last access time for tables in SQL Server
The SQL ROWCOUNT is a SQL Server SET statement which causes SQL Server to stop processing the query after the specified number of rows are returned
SQL Server SET NOCOUNT ON/OFF statement that controls the behaviour in SQL Server to shown the number of affected rows in the T-SQL query.