What is the fibonacci sequence The Fibonacci sequence is a series of numbers where the next number is the sum of previous two numbers. Fibonacci sequence formula : fn = f(n-1)+f(n-2) The first two...
In this article I would like to explain about String Functions in SQL with examples. SQL Server String functions are used to manipulate string data types. SQL Server has many built-in string functions....
Sql Server have many build in functions in which Sql Server Date Functions plays a major role when you working with dates. These are very useful if you want to display the dates in...
CREATE PROCEDURE GetEmployeeDetails @EmpId INT, @EmpName VARCHAR(20) AS BEGIN SELECT * FROM Employees WHERE ((EmpId IS NOT NULL OR EmpId <> 0 AND EmpId = @EmpId) OR...
What are Temp Tables in SQL Server? SQL Server temp tables are very similar to the permanent tables. Permanent tables get created in the database you specify, and remain in the database permanently, until...
COALESCE in Sql Server DECLARE @listStr VARCHAR(MAX) SELECT @listStr = COALESCE(@listStr+’,’ ,”) + CAST(PartnerId AS VARCHAR(50)) FROM Partners SELECT @listStr GO O/P: 1,2,3,4,5,6,….100.
In this article I would like to explain about SQL Server ranking functions. These are very useful when you are working with more numbers of rows and wants to sort out some of the...
Below are the list of SQL Server Interview Questions and Answers to clear all levels of interviews. 1. What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data...
