Recent questions tagged Sql

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 5, 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 5, 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 5, 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 5, 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 5, 2022 in Education by JackTerrance

0 votes

Q: SQL Azure - copy table between databases

I am trying to run the following SQL: INSERT INTO Suppliers ( [SupplierID], [CompanyName]) Select [SupplierID], [ ... is very slow. Select the correct answer from above options...

asked Jan 31, 2022 in Education by JackTerrance

0 votes

Q: Count(*) vs Count(1) - SQL Server

Just wondering if any of you guys use Count(1) over Count(*) and if there is a noticeable difference in ... SQL Server 2005.) Select the correct answer from above options...

asked Jan 28, 2022 in Education by JackTerrance

0 votes

Q: 'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N' ... this to the above query? Select the correct answer from above options...

asked Jan 28, 2022 in Education by JackTerrance

0 votes

Q: How can I list all foreign keys referencing a given table in SQL Server?

I need to remove a highly referenced table in a SQL Server database. How can I get a list of all the ... of the management studio.) Select the correct answer from above options...

asked Jan 28, 2022 in Education by JackTerrance

0 votes

Q: Should I use != or <> for not equal in T-SQL?

I have seen SQL that uses both != and for not equal. What is the preferred syntax and why? I like !=, ... reminds me of Visual Basic. Select the correct answer from above options...

asked Jan 28, 2022 in Education by JackTerrance