Read more stories on Hashnode
Articles with this tag
Part - 1 · How to generate a random string of 10 character?
There are many ways to generate a random string. This one is a simple way to do it.
SQL interview questions and answers #9 · To demonstrate this, we will first create a test data number sequence from 1 to 25 with some missing numbers in...
There are two functions in SQL Server that are used to identify whether the two strings are pronounced similarly or not.
SOUNDEX() - This...
SQL interview questions and answers #8 · Answer:
DECLARE @t TABLE (
id INT IDENTITY(1,1) PRIMARY key,
INSERT INTO @t...
SQL interview questions and answers #7 · Question:
Write an update statement to swap the column values without using a temporary tables.
DECLARE @People TABLE (first_name VARCHAR(50), age int);
INSERT INTO @People VALUES ('John', 25);
INSERT INTO @People VALUES...