SQLScientist.com
Pages
(Move to ...)
Home
About Me
Contact Us
Portfolio
SQL Server Interview Questions
▼
Thursday, September 4, 2025
Simulating Arithmetic Operations in SQL Server Using a Custom Function
›
In this blog post, I’ll walk you through a creative SQL Server script that simulates basic arithmetic operations ( + , - , * , / ) using loo...
Friday, May 31, 2024
SQL Server Scenario Based Interview Question - 3
›
There is a database which contains below tables. Product Customer 1. Write a query which shows the count for each Products. Select P.Name...
Thursday, July 23, 2015
Write recursive t-sql code to find NTILE / DECILE / Quintile based on Salary descending for employee in the Department.
›
Write a query which will give below output. There’s a table with below data Query: Declare @v_Employee as table (...
Wednesday, July 22, 2015
Write recursive t-sql code to fill missing Salary for employee using Average for the Department.
›
There’s a table with below data Write a query which will give below output. Query: Declare @v...
Friday, March 13, 2015
Write recursive t-sql code to generate reverse of given string
›
Create Function [dbo].[fn_Reverse](@v_Input nvarchar(max)) Returns nvarchar(max) as Begin If (len(@v_Input) <> 1) Begin ret...
›
Home
View web version
