StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONot able to get INSERT of SP to work
text
Body
copied!<p>I am not able to get the INSERT portion of the below procedure to work. Any help would be appreciated....</p> <pre><code>@currTable varchar(100), @ID int, @short_Text varchar(250), @brief_Descrip varchar(250) = Null, @needsTranslation varchar(10) = Null, @prev_LangString varchar(250) = Null, @lang_String varchar(250) = Null, @original_lang_String varchar(250) = Null, @StringID_from_Master int, @GUID varchar(250) = Null AS BEGIN SET NOCOUNT ON; DECLARE @submitDate1 DATETIME; SET @submitDate1 = GETDATE() SET @prev_LangString = @original_lang_String DECLARE @sql NVARCHAR(MAX); SELECT @sql = N' UPDATE ' + QUOTENAME(@currTable) + ' SET [lang_String] = ''' + REPLACE(@lang_String,'''','''''') + ''', [date_Changed] = ''' + convert(varchar(20), @submitDate1) + ''', [prev_LangString] = ''' + @prev_LangString + ''', [needsTranslation] = ''' + @needsTranslation + ''' WHERE ID = ' + RTRIM(@ID) + '; '; EXEC sp_executesql @sql; INSERT tblPendingDBUpdates ( stringMasterID, databaseName, databaseStringID, englishText, foreignLangText, submitDate, GUID ) SELECT @StringID_from_Master, Database_Name, dbKeyID_ofStringName, @short_Text, @lang_String, @submitDate1, @GUID FROM tblDBUsage WHERE tblUniquetblStringsMaster_ID = @StringID_from_Master; END </code></pre> <p>I tried this code block only and no luck it did not INSERT to tblPendingDBUpdates.... Noticed something weird about GUID as field name so changed it in table also...</p> <pre><code> AS BEGIN SET NOCOUNT ON; DECLARE @submitDate1 DATETIME; SET @submitDate1 = GETDATE() -- SET @prev_LangString = @original_lang_String DECLARE @sql NVARCHAR(MAX); DECLARE @currTable varchar(100); SET @currTable = 'tblLangenUS' DECLARE @ID INT; SET @ID = 2 DECLARE @short_Text varchar(250); SET @short_Text = 'testing99' DECLARE @StringID_from_Master INT; SET @StringID_from_Master = 2 DECLARE @lang_String varchar(250); SET @lang_String = 'testing9999' DECLARE @GUID1 varchar(250); SET @GUID1 = 'Null' INSERT tblPendingDBUpdates ( stringMasterID, databaseName, databaseStringID, englishText, foreignLangText, submitDate, GUID1 ) SELECT @StringID_from_Master, Database_Name, dbKeyID_ofStringName, @short_Text, @lang_String, @submitDate1, @GUID1 FROM tblDBUsage WHERE tblUniquetblStringsMaster_ID = @StringID_from_Master; END </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload