Viewing 15 posts - 5,116 through 5,130 (of 6,036 total)
What do you mean "change Identity of a column of a table"?
What exactly you are trying to do?
September 5, 2006 at 9:17 pm
Change the column type to IDENTITY.
September 5, 2006 at 9:15 pm
If you're going to make all calculations by yourself then keep information about different products in different tables, as it's suitable for you, human being.
If you wanna make SQL Server...
August 31, 2006 at 11:50 pm
So what's a problem?
DIFFERENCE = 4 means "the least possible difference", see BOL.
So, it returns you proper warning that those 2 strings are very similar as they actually are.
August 31, 2006 at 11:15 pm
And what if you'll succeed in this?
Would you consider that numbers '1644700809' and '1644708009' are actually the same?
It's really dangerous. Don't even think about it.
Vendor could have ProductionCategory included into...
August 31, 2006 at 6:45 pm
If vendor could fix one error then they could fix and another one.
But if you have city stored in separate column your task becomes really easy:
Update table
Set location =...
August 31, 2006 at 6:26 pm
If you intend to create separate table for each contact record they send to you???
If you really believe it's a great idea you can use
SELECT @Company Company, @Name...
August 31, 2006 at 6:16 pm
Anita,
your application is not fixed!!!
As I can see user enters parts of address into separate fields, and application concatenates it into one string before saving it in database.
STOP IT!
Fix the...
August 31, 2006 at 5:10 pm
Do you want to send select statement or resultset it returns?
August 31, 2006 at 12:30 am
Create table "OrderDetails", populate it with right data and then query it.
Actually your example does not have any relation neither to TSQL nor to relational databases at all.
August 31, 2006 at 12:14 am
First of all - the task is really stupid.
Why anybody would need 2 columns with exactly the same data?
If you mean to make some modifications to the data later you...
August 30, 2006 at 9:09 pm
SELECT A.ID_TOWN,
CASE @field WHEN 'Col01' then A.Col01 WHEN 'Col02' then A.Col02 WHEN ... END,
CASE @field WHEN 'Col01' then B.Col01 WHEN 'Col02' then B.Col02 WHEN ... END,
August 30, 2006 at 8:43 pm
Anyway it's good to learn some basics about syntax of the language before you try to use it.
August 27, 2006 at 1:14 am
Detach database, move files to a new location and attach it again.
August 24, 2006 at 11:55 pm
Are you sure this E: drive is local, not mapped network drive?
August 24, 2006 at 10:12 pm
Viewing 15 posts - 5,116 through 5,130 (of 6,036 total)