How to Encrypt a Stored Procedure in SQL Server
Encrypting a SQL Server Stored Procedure If you have any complex business logic that you want to keep secure and hide from end user due… Read More »How to Encrypt a Stored Procedure in SQL Server
Home » SQL Server Tutorials »
SQL Server Tutorials
This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .
You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.
SQL Over Clause
SQL OVER clause allows the use of aggregation without using a group by clause. OVER clause aggregate rows across groups of another field using the… Read More »SQL Over Clause
SQL Server @@Servicename
SQL @@servicename is SQL Server configuration function which returns the name of the registry key under which SQL Server is running. This function does not… Read More »SQL Server @@Servicename
SQL Server sp_procoption startup procedures
The sp_procoption is a SQL Server system stored procedure allows us to Set or clear a stored procedure for automatic execution when an instance of… Read More »SQL Server sp_procoption startup procedures
SQL ROUND Function
The SQL ROUND function is a SQL Mathematical Function which is used to round a number to a specified length or precision. It returns a… Read More »SQL ROUND Function
SQL NOT NULL Constraint
SQL NOT NULL Constraint is used to prevent inserting NULL values into the specified column. When value for any specific column is not provided while… Read More »SQL NOT NULL Constraint
SQL Server sp_executesql
The sp_executesql is a SQL Server built-in sytem stored procedure that enables to execute of the dynamically constructed SQL statements or batches. The following are advantages… Read More »SQL Server sp_executesql
SQL Server Change Data Capture
SQL Server Change Data Capture also know as CDC, was introduced in SQL Server 2008 version. It is used to capture the changes made to… Read More »SQL Server Change Data Capture
SQL change column collation to case sensitive
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
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
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
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.