Click here to Skip to main content
15,867,594 members
Home / Discussions / Database
   

Database

 
AnswerRe: execute an update  using --> "Exec sp_executesql @Sql1" Pin
David Mujica2-Feb-23 4:31
David Mujica2-Feb-23 4:31 
AnswerRe: execute an update  using --> "Exec sp_executesql @Sql1" Pin
Eddy Vluggen10-Mar-23 12:17
professionalEddy Vluggen10-Mar-23 12:17 
After thinking about this a bit more than required;

Member 11533892 wrote:
But I didn't want to divide the execution of the update into 2 variables!!!
You mean you don't want to execute two update-statements for the same record. Two variables cost nothing nowadays, so that doesn't make any sense. Two updates must be atomic, or you get concurrency issues. Could be simply solved by using a transaction.

You may find the error to be the design of the table, not the update-statement. I'm going to guess a lot of those fields can be "NULL" or revert to some preset default value.

..but, let me give you a solution from a VB6 programmer view; you can rename all columns into numbers. So if column one is named [Name], you replace that with [1]. You can keep a list in Excel to look up the column names. That way, the update-statement is shorted a lot, and a huge lots of them would fit in a VARCHAR(MAX) command.

Roll eyes | :rolleyes:
Bastard Programmer from Hell Suspicious | :suss:
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

QuestionQuestion On SQL Query Result Pin
crmfghtr20-Jan-23 5:13
crmfghtr20-Jan-23 5:13 
AnswerRe: Question On SQL Query Result Pin
Richard Deeming20-Jan-23 5:33
mveRichard Deeming20-Jan-23 5:33 
PraiseRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 5:41
crmfghtr20-Jan-23 5:41 
AnswerRe: Question On SQL Query Result Pin
Mycroft Holmes20-Jan-23 11:34
professionalMycroft Holmes20-Jan-23 11:34 
GeneralRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 12:41
crmfghtr20-Jan-23 12:41 
QuestionEF Core 6 Exclude Columns Pin
Kevin Marois19-Dec-22 8:47
professionalKevin Marois19-Dec-22 8:47 
AnswerRe: EF Core 6 Exclude Columns Pin
Dave Kreskowiak19-Dec-22 15:47
mveDave Kreskowiak19-Dec-22 15:47 
GeneralRe: EF Core 6 Exclude Columns Pin
Kevin Marois23-Dec-22 7:36
professionalKevin Marois23-Dec-22 7:36 
QuestionUsing SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
Jaime Maccou9-Dec-22 1:00
Jaime Maccou9-Dec-22 1:00 
AnswerRe: Using SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
jschell12-Dec-22 10:33
jschell12-Dec-22 10:33 
QuestionEntity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois8-Dec-22 12:54
professionalKevin Marois8-Dec-22 12:54 
AnswerRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Victor Nijegorodov8-Dec-22 18:24
Victor Nijegorodov8-Dec-22 18:24 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois9-Dec-22 11:47
professionalKevin Marois9-Dec-22 11:47 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
jschell12-Dec-22 10:35
jschell12-Dec-22 10:35 
QuestionSOLVED - Pivot a result set Pin
Richard Andrew x6428-Nov-22 5:46
professionalRichard Andrew x6428-Nov-22 5:46 
AnswerRe: SOLVED - Pivot a result set Pin
Richard Deeming28-Nov-22 21:24
mveRichard Deeming28-Nov-22 21:24 
QuestionTSQL - JOIN cancels out my date filter Pin
jkirkerx27-Nov-22 13:53
professionaljkirkerx27-Nov-22 13:53 
AnswerRe: TSQL - JOIN cancels out my date filter Pin
Graham Breach27-Nov-22 21:38
Graham Breach27-Nov-22 21:38 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jkirkerx28-Nov-22 6:32
professionaljkirkerx28-Nov-22 6:32 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jschell28-Nov-22 10:44
jschell28-Nov-22 10:44 
QuestionTSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [bad idea] - abandoned it Pin
jkirkerx21-Nov-22 9:15
professionaljkirkerx21-Nov-22 9:15 
AnswerMaybe this is a bad idea, so I abandoned it. Did a work around instead. Pin
jkirkerx21-Nov-22 9:35
professionaljkirkerx21-Nov-22 9:35 
AnswerRe: TSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [bad idea] - abandoned it Pin
Graham Breach21-Nov-22 10:29
Graham Breach21-Nov-22 10:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.