SQL Server Interview Questions What is the use of an Index in SQL Server? Relational databases like...
Author - shohal
Built in string functions in sql server 2008
Built in string functions in sql server 2008 Functions in SQL server can be broadly divided into 2...
Basic SQL Server Interview Questions
Basic SQL Server Interview Questions Explain DML, DDL, DCL and TCL statements with examples? DML:...
What is sp_depends in SQL Server?
What is sp_depends in SQL Server? sp_depends is a system stored procedure that displays information...
Replicate, Space, Patindex, Replace and Stuff functions
Replicate REPLICATE(String_To_Be_Replicated, Number_Of_Times_To_Replicate) – Repeats the...
Sequence object in SQL Server 2012
Sequence object in SQL Server 2012 what is sql sequence? A sequence is a user-defined schema bound...
Scalar User-Defined Functions in SQL Server
User-defined functions. In short UDF. We will cover1. User Defined Functions in sql server2. Types...
Quotename function in SQL Server
Quotename function in SQL Server This function is very useful when you want to quote object names...
Product Key
Product Key Windows 10 Product Keys All Versions Product NameActivation KeyWindows 10 Enterprise...
Pivot operator in sql server
Pivot operator in sql server Pivot is a sql server operator that can be used to turn unique values...