Viewing 15 posts - 2,581 through 2,595 (of 3,232 total)
I don't believe that it does. Just curious though, who told you not to use bcp and why?
October 26, 2006 at 10:28 am
Please do not cross-post.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=318391
October 26, 2006 at 10:27 am
I've used Lumigent's Log Explorer (trial version) on a user database. You should be able to get yourself a free trial.
October 26, 2006 at 10:15 am
Are you using multiple database files/filegroups for your database? Is your DB set to autogrow? Can you update/insert into some tables but not others?
October 26, 2006 at 9:59 am
The only way to do this, outside of a restore, would be if you have some sort of transaction log reader tool. There are a few tools like this out...
October 26, 2006 at 9:54 am
Just because you've decided not to go the cursor route does not necessarily mean that you need to use a table variable or temp table. Odds are, there's a set...
October 26, 2006 at 9:48 am
I noticed that you've updated your initial post with a query using derived tables. That is how I would have done it also. If this is giving you the correct...
October 26, 2006 at 9:36 am
Right, I kind of got that part, but how do you know if they have not completed training? A record in the log without a training date?
October 26, 2006 at 9:06 am
What tells you whether the training has been completed or not?
October 26, 2006 at 8:50 am
From what you've shown, there is still no reason why this needs to be dynamic. Why can't you simply use the query SELECT @ok = 'true' FROM @MyVariableTable WHERE .....?
October 26, 2006 at 8:02 am
Again, can you give a little more info on what you are trying to accomplish? Why do you think you need to use Dynamic SQL?
October 25, 2006 at 3:27 pm
You can't pass the table variable, you must include the entire DECLARE @table table....INSERT INTO @table.... code into sp_executeSQL so that the scope of the table variable declaration is withing...
October 25, 2006 at 3:14 pm
It is kind of difficult to give you a good example of this when I really do not know what you are trying to accomplish. Can you give us more...
October 25, 2006 at 2:52 pm
Then you must declare and populate your table variable within the scope of the dynamic sql call using sp_executeSQL and parameters. Look up sp_ExecuteSQL in BOL.
October 25, 2006 at 2:36 pm
Consider this example:
declare @table table (T1 text)
insert into @table (T1)
select 'test' + char(13) + ' test2'
select * from @table
In order to 'see' the results on two lines, you must view...
October 25, 2006 at 2:34 pm
Viewing 15 posts - 2,581 through 2,595 (of 3,232 total)