Viewing 15 posts - 54,676 through 54,690 (of 59,078 total)
Dunno about your first question but I'm pretty sure that the answer to your second question of can you "view images in SQL Server" is an emphatic "NO".
October 9, 2007 at 7:39 am
Heh... flies haven't found it, yet... :hehe:
October 9, 2007 at 7:33 am
Thanks, but doesn't quite tell me what you want... not trying to be difficult here, either but "one picture is worth a thousand words"....;)
You listed this as an "input"...
Insert Into...
October 9, 2007 at 7:30 am
Yep... I agree with all of that... if it's for GUI code...
For batches, the proc will probably recompile anyway just because the data will have changed enough to need a...
October 9, 2007 at 7:24 am
A big key here is that David DIDN'T even use a function (although you could if it's for RBAR GUI code)... it splits a whole table's worth of information in...
October 9, 2007 at 7:16 am
Heh... I cheat like hell... load up one staging table with everything... delete the dupes with the "earliest" information... flip the pass-through-view to look at the new table... drink beer...
October 8, 2007 at 8:56 pm
Ramesh Lende (10/8/2007)
October 8, 2007 at 8:47 pm
Backups... if for nothing else, to clear log files that are getting big and growing.
October 8, 2007 at 8:44 pm
Most people recommend against it for many reasons... most of them are good, some are not... but you could put a view in the Master database and that would draw...
October 8, 2007 at 8:34 pm
nba (10/4/2007)
The problem now is not the trigger but why it was there and not documented.
Simple... database is not correctly locked down for changes. No one but DBA's should...
October 8, 2007 at 8:21 pm
Works fine for what you have... no primary key.
To help, I need to know what you expect the output of your first post to be...
October 8, 2007 at 7:58 pm
You'd need to split out the images into separate files...
October 8, 2007 at 5:25 pm
We handle some pretty heavy loads, as well, but on the SQL Server side... that is, when folks stop trying to write Oracle code for SQL Server ๐
October 8, 2007 at 5:21 pm
David (10/6/2007)
Thanks Jeff! I was hoping you would respond. You always have such brilliant responses!!Many thanks!!
Heh... thanks David :blush:
But, Serqiy's observations are spot on and I was actually...
October 8, 2007 at 5:01 pm
Viewing 15 posts - 54,676 through 54,690 (of 59,078 total)