#interview
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. SELECT...
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. They are SOUNDEX() - This...
SQL interview questions and answers #8 · Answer: DECLARE @t TABLE ( id INT IDENTITY(1,1) PRIMARY key, drink_name VARCHAR(30) ) INSERT INTO @t...
SQL interview questions and answers #7 · Question: Write an update statement to swap the column values without using a temporary tables. Before Update:...
Question: DECLARE @People TABLE (first_name VARCHAR(50), age int); BEGIN TRAN INSERT INTO @People VALUES ('John', 25); INSERT INTO @People VALUES...
