Viewing 15 posts - 2,716 through 2,730 (of 6,041 total)
I always insert the parent row first, get @@IDENTITY into a variable or output parameter, and then use that ID to insert child rows. Getting ETL processing in that order...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 3:41 pm
Lynn Pettis (4/7/2016)
Rod at work (4/7/2016)
Peter Schott (4/6/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 3:36 pm
Why are folks still listing SSDE licenses for sale on eBay, when it can be downloaded for free ? 😛
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 12:45 pm
This appears to be functionally equilavent to how identity based identifiers work, only what you're doing is a lot more complicated and requires coding in every stored procedure that inserts....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 12:39 pm
Oracle, eat your heart out!
All you resellers on eBay can eat your little hearts out too. Ha!
http://www.bing.com/search?q=site%3Aebay.com+%22sql+server+2014%22+%22developer+edition
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 12:30 pm
I'm not understanding the following. Is [GDML.eResults.UserStore] a database with an odd 3 part name containing periods, or is this a reference to a remotely linked database/table?
[GDML.eResults.UserStore].[dbo].[vw_aspnet_UserProfiles]
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 12:05 pm
There are many naming conventions that prescribe things like case, underscores, plural vs. singular, or hungarian notation, but here are some more general guidelines that should apply regardless.
A column should...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 11:49 am
Michael L John (4/7/2016)
DavidL (4/7/2016)
Eric M Russell (4/7/2016)
.. The tables in a JD Edwards system were coded with a short alpha sequence and then a 4 or 5 digit number....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 11:34 am
.. The tables in a JD Edwards system were coded with a short alpha sequence and then a 4 or 5 digit number. Always fun to remember what "FS3401" means...
Ha!...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 7:47 am
By default, a new login has access no databases, and once granted access, they cannot select from anything.
To maximize security, I'd suggest first creating a view that joins the required...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 7, 2016 at 6:27 am
We have open positions for SQL Server DBAs and Database Developers (v2008 - v2016), if anyone is interested in the North Atlanta area, specially Kennesaw/Marietta. Good job market, affordable housing,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 6, 2016 at 7:51 am
By default, a SQL Server processes will not timeout, unless it is in deadlocked state (an unresolvable locking contention) with another process. In a worst case scenario, a poorly constucted...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 6, 2016 at 7:00 am
🙂
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 2:11 pm
Iwas Bornready (4/5/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 2:06 pm
Rod at work (4/5/2016)
Eric M Russell (4/5/2016)
Rod at work (4/5/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 1:07 pm
Viewing 15 posts - 2,716 through 2,730 (of 6,041 total)