Recent questions tagged Sql

0 votes

Q: How to get first character of a string in SQL?

I have a SQL column with a length of 6. Now want to take only the first char of that column. Is there any ... in SQL to do this? Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

I didn't see any similar questions asked on this topic, and I had to research this for something I'm working ... had the same question. Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: Merge SQL INSERT with Reference Table

I need to synchronize two tables. TableA Id Name TableB Id Name RefID --It's a Foreign key, defined as ... MATCHED BY TARGET THEN. Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: Access to SQL: IFF function

I have not used access before but I have to convert an access query into SQL so I can write a report in crystal ... like this in SQL? Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: What is an index in SQL?

What is an index in SQL? Can you explain or reference to understand clearly? Where should I use an index? Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: Difference between EXISTS and IN in SQL?

What is the difference between the EXISTS and IN clause in SQL? When should we use EXISTS, and when should we use IN? Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: How to request a random row in SQL?

How can I request a random row (or as close to truly random as is possible) in pure SQL? Select the correct answer from above options...

asked Feb 8, 2022 in Education by JackTerrance

0 votes

Q: SQL User Defined Function Within Select

I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of ... WHERE ... Select the correct answer from above options...

asked Feb 5, 2022 in Education by JackTerrance

0 votes

Q: How to get first character of a string in SQL?

I have a SQL column with a length of 6. Now want to take only the first char of that column. Is there any ... in SQL to do this? Select the correct answer from above options...

asked Feb 5, 2022 in Education by JackTerrance

0 votes

Q: How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

I didn't see any similar questions asked on this topic, and I had to research this for something I'm working ... had the same question. Select the correct answer from above options...

asked Feb 5, 2022 in Education by JackTerrance