Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
Recent questions tagged Sql
0
votes
Q: Why am I getting "multiple cascade paths" with this table relationship?
I have the following table relationship in my database: Parent / \ Child1 Child2 \ / GrandChild I am ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 19, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: SQL query to calculate coordinate proximity
I'm using this formula to calculate the distance between entries in my (My)SQL database which have latitude ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 19, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: Weird Output on SQL REPLACE
I am using REPLACE in an SQL view to remove the spaces from a property number. The function is ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 19, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: Key value pairs in relational database
Does someone have experience with storing key-value pairs in a database? I've been using this type of ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 17, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: Transact-SQL - sub query or left-join?
I have two tables containing Tasks and Notes, and want to retrieve a list of tasks with the number ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 12, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: How to return both null and not-null values in one query
I have an integer field person_id with the default value of NULL. I am using a stored procedure and ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 25, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: SQL Server - GETUTCDATE() 'Incorrect syntax near )'
Simple question: why does the top statement work, but the bottom one fails with 'Incorrect syntax near (' ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 19, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: SQL Server - GETUTCDATE() 'Incorrect syntax near )'
Simple question: why does the top statement work, but the bottom one fails with 'Incorrect syntax near (' ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 18, 2022
in
Education
by
JackTerrance
sql
0
votes
Q: SQL reporting invalid syntax when run in Power BI
I have written an SQL script which runs fine when executed directly in SQL Management Studio. However, when entering ... are removed: Select the correct answer from above options...
asked
Feb 8, 2022
in
Education
by
JackTerrance
sql
sql-server
powerbi
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 8, 2022
in
Education
by
JackTerrance
sql
sql-server
select
user-defined-functions
Page:
« prev
1
2
3
4
5
next »
...