issues
search
dnlnln
/
generate-sql-merge
Generate SQL MERGE statements with Table data
MIT License
337
stars
151
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Feedback on XML Output Issue
#113
Niritl-Madeira
opened
11 hours ago
0
Added @serializable option
#112
drmcclelland
closed
2 months ago
1
Deprecate params w- 'ommit' in the name; replace with 'exclude'
#111
dnlnln
closed
2 months ago
1
Typo
#110
davimack
closed
2 months ago
1
Allow for column names of 'Source'
#109
swiggins
closed
6 months ago
1
Ability to handle multiple tables
#108
jtourvieille
opened
7 months ago
0
Add @execute param to auto-execute generated MERGE
#107
dnlnln
closed
12 months ago
0
Change detection via EXCEPT (instead of NULLIF)
#106
dnlnln
closed
1 year ago
1
Add SERIALIZABLE table hint to prevent race condition in concurrent executions
#105
dnlnln
closed
1 year ago
0
Support sql_variant datatype columns
#104
dnlnln
closed
1 year ago
0
Image data type support
#103
dnlnln
closed
1 year ago
0
Fix script compatibility with Binary (BIN) database collations
#102
AndyPLsql
closed
1 year ago
1
Improve performance of large MERGE with VALUES statements
#101
dnlnln
closed
1 year ago
0
Fix 'incorrect settings' error on DBs/clients with SET QUOTED_IDENTIFIER OFF
#100
davimack
closed
1 year ago
2
Fix issue 95: Invalid SQL generated with @hash_compare_column param
#99
dnlnln
closed
1 year ago
0
Allow sp_generate_merge to be installed without sysadmin/db_owner rights
#98
dnlnln
closed
1 year ago
0
Add @quiet parameter to suppress informational messages and warnings
#97
dnlnln
closed
1 year ago
0
instruction(x)' contains an invalid XML identifier as required by FOR XML
#96
spottedmahn
closed
1 year ago
4
Error Occurs When Verifying the Existence of the 'hashedvalue' Column
#95
q0-0n
closed
1 year ago
1
added optional parameters @update_existing and @max_rows_per_batch
#94
EitanBlumin
closed
1 year ago
5
Unique variable names in generated sql when using @include_rowsaffected
#93
jbelanger
closed
1 year ago
2
Case mismatch object_id column name
#92
BHolthuijsen
closed
1 year ago
1
case sensitive update
#91
JAagsalog
opened
2 years ago
1
QUOTED_IDENTIFIER error
#90
davimack
closed
1 year ago
1
SQL Server v2019 issues
#89
MikeMcWilliams
closed
1 year ago
3
Fix missing semi-colon in generated merge when @include_rowsaffected=0
#88
dnlnln
closed
2 years ago
0
Add ordinal column order on composite Primary Key
#87
b-twis
closed
2 years ago
0
Support for Managed Instance - cant find sp_MS_marksystemobject
#86
b-twis
closed
1 year ago
1
Using '@include_rowsaffected = 0' causes error "A MERGE statement must be terminated by a semi-colon (;)"
#85
InsolvencyCrispy
closed
2 years ago
1
Issue with composite key and order in values
#84
hidegh
closed
2 years ago
2
Ambiguous column name when same column is in two tables
#83
ax3ld
opened
2 years ago
2
Fixed a Bug with the TIME Data Type
#82
GuyGlantser
closed
3 years ago
1
Show inserted/updated/deleted row counts instead of just total rows affected
#81
JV-Gh
closed
2 years ago
2
Add reference to examples in readme.md?
#80
spottedmahn
closed
1 year ago
2
XML column comparison
#79
franciscosamuel
closed
3 years ago
1
sql_variant => invalid statements, basetype needs to be checked and used
#78
aisbergde
closed
1 year ago
2
@cols_to_exclude longer than 128 chars
#77
Kvasi
closed
3 years ago
4
SSMS Issue, or..?
#76
davimack
closed
3 years ago
3
Merge statement fails when used for processing bigger tables
#75
wimlauwaert
closed
1 year ago
3
Nullable column join fix
#74
DavidWiseman
closed
3 years ago
0
Enhancement Request : Create Merge statement with JSON parse (with an option)
#73
ghost
closed
1 year ago
2
EXCEPT-based Change Detection
#72
lorberc
closed
3 years ago
2
#65 change detection via EXCEPT
#71
lorberc
closed
4 years ago
0
Don't update Identity columns
#70
raitono
closed
3 years ago
1
Column names and tabs
#69
otake1977
closed
1 year ago
2
Creation error in Azure Sql server database
#68
CTBT
closed
1 year ago
2
define source by query
#67
fmms
closed
1 year ago
1
Add isActive flag
#66
fmms
opened
5 years ago
0
change detection via EXCEPT
#65
fmms
closed
1 year ago
1
Ensure scope safety when a temp table is specified
#64
dnlnln
closed
5 years ago
0
Next