Loooong Columnnames
Jul 20, 2005
Hi,
A long time ago I set up a database with *very* descriptive and therefore
long table names. :(
I did the same with the column names. :((
The column names even repeat the table name. :(((
This was done in a period in which I was still using a lot of dynamic sql
:(((( and sql in the code of the app :(((((.
The tables all have the prefix 'tbl' (yes, I know) :((((((
There are even ghastly underscores in it too :(((((((
As a result, I'm starting to develop a nasty case of carpal tunnel syndrom
(aka RSI) :((((((((
For example there are names like:
dbo.tbl_SalesOrderLine.SalesOrderLine_SalesOrder
I have to type them in QA a gazillion times a day
The number of objects in the database has grown well beyond even beginning
to think about renaming them all.
Now my question: Is there an MS SQL client utility out there that has
autocomplete?
Cheers,
Bas
View 1 Replies
Mar 29, 2000
OK, I'm setting up my first database, and I need one field to hold very long html code (several pages worth of info each). Which field type works best? Someone told me "memo", but I don't see that option in MS SQL 7
View 2 Replies
View Related
Nov 14, 2007
I have the following query
SELECT maximum.tblSalesCall.OrgKey, dbo.tblItem.ProductDescription, maximum.tblSalesCallItems.Facing, maximum.tblSalesCallItems.Price
FROM dbo.tblBrand INNER JOIN
dbo.tblItem ON dbo.tblBrand.BrandKey = dbo.tblItem.BrandKey INNER JOIN
maximum.tblSalesCallItems ON dbo.tblItem.ItemKey = maximum.tblSalesCallItems.ItemKey INNER JOIN
maximum.tblSalesCall ON maximum.tblSalesCallItems.SalesCallKey = maximum.tblSalesCall.SalesCallKey
WHERE (maximum.tblSalesCall.OrgKey = 2134 OR
maximum.tblSalesCall.OrgKey = 2135) AND (maximum.tblSalesCall.SalesCallKey = '274f68f8-6aad-426c-9a66-4267fc71c8c7') AND
(dbo.tblItem.ItemActive = 1) AND (dbo.tblBrand.BrandActive = 1) AND (dbo.tblBrand.BrandKey = 25)
that generates the following results set:
OrgKey ProductDescription Facing Price
---------------------------------------------------------------
2134 JUICE SLAMS - AWESOME APPLE 1 2.7900
2134 JUICE SLAMS - BURSTIN BERRY 1 2.7900
2134 JUICE SLAMS - STRAWBERRY BANANA TWIST 1 2.7900
2134 JUICE SLAMS - TOTALLY TROPICAL 1 2.7900
2134 SMOOTHIES - PINEAPPLE COCONUT 0 0.0000
2135 JUICE SLAMS - AWESOME APPLE 1 2.7900
2135 JUICE SLAMS - BURSTIN BERRY 1 2.7900
2135 JUICE SLAMS - STRAWBERRY BANANA TWIST 1 2.7900
2135 JUICE SLAMS - TOTALLY TROPICAL 1 2.7900
2135 SMOOTHIES - PINEAPPLE COCONUT 0 0.0000
However, the customer wants the results to look like this:
OrgKey JUICE SLAMS - AWESOME APPLE Price JUICE SLAMS - BURSTIN BERRY Price (The rest of the items follow)
---------------------------------------------------------------------------------------
2134 1 2.7900 1 2.7900
2135 1 2.7900 1 2.7900
BTW, there is a variable number of product depending on the brandkey that the customer chooses.
Any ideas on how I can do this would be greatly appreciated.
View 10 Replies
View Related
Feb 25, 2001
I would like to change a column name, but before doing so would like to search all SPs and Views for occurrences of that name. I would be happy with just a list of them, but even cooler would be the ability to change all the occurrences to the new name.
Thanks!
Arthur
View 1 Replies
View Related
Jul 20, 2005
I use Blanks in ColumnNames ( I know that this isnīt very good, but alot of code and querys had to be changed if I would remove all blanksin all columnnames).When I link this tables with ODBC in my ACC97 - project, some of thetables causes an ODBC-Error.Are there possibilities to workaround this error?Thanks, Andreas Lauffer, easySoft. GmbH, Germany
View 1 Replies
View Related
Jun 26, 2006
Hiho,
I'm reading out some exelsheets to store the data in a SQL DB on a MS SQL Server.
I can connect to Excel file easily and usual querys are woriking as well.
My Probelm is, that all my Excel files have some columns with a name that has more than one word, e.g. "this is an example".
Is there any possibility to make query's to this columns? ...renaming them would leed in some trouble, i guess.
regards,
ratsche
ps: maybe this is a sql problem and not a asp.net problem.
View 2 Replies
View Related
Jan 24, 2008
Trying to setup a derived column to use an expression stored in a package variable. But it seems that variables are always evaluated as text...I need it to evaluate as a Columname sometimes.
Example:
On an ETL of Products I want a new derived column that uses two other columns.
I can hardcode an expression of ProductID + " - " + ProductName and that results in dynamic output. But now I want to use that as an expression stored in a variable so I can change it when needed.
So I make that expression = @[User::Variable]
and stuff into @variable ( a string param) : ProductID + " - " + ProductName
My output is the literal "ProductID + " - " + ProductName", and not the actual ID's and Names
I've tried with/without brackets, quotes and braces but no change.
Any way I can get the pieces in that variable expression to evaluate as column names?
View 6 Replies
View Related
