SQL Between Operator
SQL Between Operator is a logical operator that selects the records whose values are in between the given values. SYNTAX SELECT * FROM table_name WHERE … Read More »SQL Between Operator
SQL SET Language
The SET Language is one of the SQL Server SET Statement that change the default language for the session. The session language determines the datetime formats and… Read More »SQL SET Language
SQL @@Language Function
SQL Server @@Language is a configuration function that returns the name of the language currently being used. SYNTAX @@LANGUAGE Return Type of @@LANGUAGE is nvarchar.… Read More »SQL @@Language Function
Copy or delete files from directory in SQL Server
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
Get a last access time for tables 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
SQL PARSE Function
The SQL PARSE function is a SQL Conversions Function that is used to convert the string data to the requested data type and returns the… Read More »SQL PARSE Function
SQL SET ROWCOUNT
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 SET NOCOUNT ON
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.
SQL GOTO Statement
The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.
SQL Subquery
A Subquery is a query within another query. The outer query is called as main query and inner query is called as subquery. A subquery (inner… Read More »SQL Subquery
SQL EXISTS Operator
The SQL EXISTS Operator is used to check the existence of any record in a subquery. The EXISTS operator returns true if the subquery returns… Read More »SQL EXISTS Operator
Bulk Insert in SQL Server
Using SQL Server BULK INSERT(BCP) statement you can perform large imports of data from text, or Csv files to SQL Server table, or Views. Basically,… Read More »Bulk Insert in SQL Server
SQL Attach Database
Detaching and attaching a SQL database, is helpful in case in case when you want to move to move a database to a different SQL Server instance. So Bascially, first we detach database from SQL Server and move those files to another SQL Server and then attach files.
SQL Detach Database
SQL Detach Database, when you detach a database from SQL Server, database is removed from the instance of SQL Server but kept the database intact within its data files and transaction log files.
SQL Default Constraint
The DEFAULT constraint is used to provide a default value for a columns, when the INSERT INTO statement does not provide a specific value to columns.
SQL Server Cross Apply and Outer Apply
SQL Server Cross Apply and Outer Apply
SQL Server APPLY operator is like a SQL JOINS, which allows joining two table expressions, but the Difference between APPLY operator and JOINS is the ability of APPLY operator to work with table- valued expression.
Create a SSRS Matrix Report
A SSRS Matrix report is very similar to a Tabular report, but it displays a data grouped by columns and rows, with aggregate data at the intersections. It is similar like a SQL Pivot to transform data from row-level to columnar data .
SQL Server Cursor
A SQL cursor is a database object that is used to retrieve data from a result set one row at a time. A SQL cursor is used when the data needs to be updated row by row.
