Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
Recent questions tagged Tsql
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
sql
sql-server-2008
tsql
ssis
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
sql
sql-server-2008
tsql
ssis
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
sql
sql-server
tsql
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
sql
sql-server
tsql
0
votes
Q: How to return only the Date from a SQL Server DateTime datatype
SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00: ... How can I get that? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
date
datetime
0
votes
Q: How do I perform an IF…THEN in an SQL SELECT?
How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR ... Saleable, * FROM Product Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
if-statement
case
0
votes
Q: Insert results of a stored procedure into a temporary table
How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [ ... not supply any columns. Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
sql-server-2005
tsql
stored-procedures
0
votes
Q: Inserting multiple rows in a single SQL query?
I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
insert
0
votes
Q: How do I UPDATE from a SELECT in SQL Server?
In SQL Server, it's possible to insert into a table using a SELECT statement: INSERT INTO Table (col1, col2, ... .id = other_table.id Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
select
0
votes
Q: Inserting multiple rows in a single SQL query?
I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
insert
To see more, click for the
full list of questions
or
popular tags
.
...