Viewing 15 posts - 8,746 through 8,760 (of 13,882 total)
Steve Jones - SSC Editor (1/23/2015)
ProductId would look funny to...
January 23, 2015 at 8:48 am
ScottPletcher (1/23/2015)
I don't get why just "ID" is fully capitalized. Why not "addr"?Why is it:
ProductID
but:
ProductAddr
rather than:
ProductADDR
Why selectively capitalize just one abbreviation? Why the inconsistency?
Exactly. I think it must...
January 23, 2015 at 8:45 am
ZZartin (1/23/2015)
On another note on the most jarring experience I had with naming conventions was using an open source ecommerce...
January 23, 2015 at 8:37 am
I cannot see how you could use PIVOT to generate the same results as your SELECT ... UNION example.
Would you be so good as to post the solution please?
January 23, 2015 at 8:13 am
Jeff Moden (1/23/2015)
Doesn't Intellisense do what you want here? Or are you looking for the datatype and constraints, etc, as well?
This is not about cutting code – SQL Prompt...
January 23, 2015 at 7:39 am
ScottPletcher (1/22/2015)
--But, ProductId seems right to me if you're going to camel case.
--
Camel case would be productId. ProductId is Pascal case 🙂
January 23, 2015 at 12:54 am
Guitar_player (1/22/2015)
u mean to say that , dont delete the project in the SSIS DB catalog and just deploy the .ispac on the same folder in the SSISDB catalog ?
Exactly....
January 22, 2015 at 4:25 am
I do suggest, however, that you do this 'redeployment' by right-clicking on the 'Projects' node in your SSISDB catalog and selecting Deploy.
January 22, 2015 at 4:24 am
Deploying projects does not affect environments.
January 22, 2015 at 4:21 am
Guitar_player (1/22/2015)
I need info on the Deployment side..
I have built my package and and deployed the package to the SSISDB Catalog..
My project is something...
January 22, 2015 at 3:54 am
susmitha117 (1/21/2015)
I have a flat file which needs to be imported to SQL Database. My flat file contains Quotes as header delimiter. How do i remove that from header...
January 21, 2015 at 11:15 am
RonKyle (1/21/2015)
... and ID is not? What is it then?
'Id' is an abbreviation of a single word and is therefore valid, at least in standard written English.
When abbreviating 'Company', would...
January 21, 2015 at 7:48 am
Koen Verbeeck (1/21/2015)
Phil Parkin (1/21/2015)
RonKyle (1/21/2015)
I use ID. It's an abbreviation that otherwise doesn't form a word.'Id' is an abbreviation of a single word ...
As I pointed out earlier,...
January 21, 2015 at 7:38 am
RonKyle (1/21/2015)
I use ID. It's an abbreviation that otherwise doesn't form a word.
... and ID is not? What is it then?
'Id' is an abbreviation of a single word and...
January 21, 2015 at 7:27 am
Ian_McCann (1/21/2015)
openning the script in notepad++ and saving it as utf8 encoded and then reading it back with -Encoded UFT8 did work,
( there is always a but)
but
It took...
January 21, 2015 at 5:18 am
Viewing 15 posts - 8,746 through 8,760 (of 13,882 total)