Home ยป SQL SERVER

SQL SERVER

SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips

SQL sp_helptext

SQL sp_helptext is a SQL Server System stored procedure that displays the the definition of any SQL Server objects. You can see the definition of… Read More »SQL sp_helptext

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

SQL Over Clause

SQL OVER clause allows the use of aggregation without using a group by clause. OVER caluse 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 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

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