EN VI
Posts (0)

No data results!

Please check back again in feature!

Questions (2)
2024-03-10 22:30:05
You can't use arbitrary statements in the THEN part of a MERGE, the syntax is quite specific about what you are allowed to do. If you want to THROW on such rows then just use a IF EXISTS... WHERE NOT...
Tags: sql sql-server t-sql
2024-03-14 11:00:04
Use a cross join between the two tables: SELECT t1.column1, t2.column2 FROM FirstTable t1 CROSS JOIN SecondTable t2 ORDER BY t1.column1, t2.column2;
Tags: sql sql-merge

Login


Forgot Your Password?

Create Account


Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login