Viewing 15 posts - 10,771 through 10,785 (of 49,566 total)
Then just add the declaration and inserts of the table variable into the dynamic string, so that it's the entire thing you posted originally.
December 2, 2013 at 7:05 am
What is the exact value of @SQLString? It's not the string built up in previous statements as far as I can see because that contains no reference to the table...
December 2, 2013 at 6:51 am
Would you mind posting the code so that it's readable?
DECLARE @string NVARCHAR(MAX)
DECLARE @UserMidListTable TABLE
(
Id INT ,
...
December 2, 2013 at 5:55 am
KcV (12/2/2013)
yes, i think (99%) didn't checked this option.
I'm fairly sure you did.
RESTORE DATABASE <database name> WITH RECOVERY
If that brings your database online then you did select the option...
December 2, 2013 at 4:55 am
Worth noting that a restore clears the plan cache for the restored database, so plans could not have persisted from before the restore.
December 2, 2013 at 3:29 am
Are you absolutely sure that you didn't check the option to allow more log backups to be restored?
December 2, 2013 at 2:41 am
You have to alias table variables, and wrapping the table variable name in [] tells SQL that the table in question is a real table in the user database with...
December 2, 2013 at 1:39 am
TC-416047 (12/1/2013)
Would this work?
Wouldn't it be faster to run it and see if it works?
December 1, 2013 at 11:51 pm
What goes inside the brackets in your INSERT () are the column names in the table you're inserting into. You have a bad mix of the INSERT ... VALUES form...
December 1, 2013 at 10:26 pm
Different companies will ask different questions. Hell, I used to ask different questions depending on my mood and the candidate's CV. There's no fixed set of questions.
You say all google...
December 1, 2013 at 10:12 pm
Log in to the DB with the credentials your administrator provides for you, if you're not allowed admin rights, then he'll have set up some lower permission level for you
December 1, 2013 at 10:05 pm
Because you referenced a column without a FROM clause.
select @LastDate=MAX([LastUpdate]) FROM exhibitor.dbo.Maintable.
December 1, 2013 at 3:09 am
What was the exact restore command/options that you used?
November 30, 2013 at 4:52 am
No where near enough information. Determining optimal IO placement takes a lot of work, a lot of analysis of virtual file stats, index usage, drive latency, etc, etc.
November 29, 2013 at 7:51 am
kapil_kk (11/29/2013)
GilaMonster (11/29/2013)
kapil_kk (11/29/2013)
GilaMonster (11/29/2013)
INSERT INTO TableB ...SELECT ...
FROM TableA
WHERE NOT EXISTS (SELECT 1 FROM TableB where <column comparison>)
Sorry to mention that I also have update the record if data...
November 29, 2013 at 5:58 am
Viewing 15 posts - 10,771 through 10,785 (of 49,566 total)