Viewing 8 posts - 1 through 8 (of 8 total)
This is a great tool, but i found two errors:
1.- The values of bit columns are changed by True and False values.
2.- In some cases, the values NULL are changed...
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
June 26, 2002 at 2:28 pm
I hope to explain my problem.
Thanks for your comments.
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
April 11, 2002 at 5:46 pm
A example, I have the follow Metadata table:
MetadataKey, TableName, ColumnName
1, 'ORGANIZATION', 'ORGANIZATION_KEY'
2, 'ORGANIZATION', 'NAME'
3, 'ORGANIZATION', 'MAX_RECORD_TIME'
The table organization exists in my database.
I need create a query for this table from...
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
April 11, 2002 at 5:25 pm
Well, i want to use metadata about some tables, so i need a procedure for construct the table from the metadata.
For example, i have the table name and column name...
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
April 11, 2002 at 4:17 pm
Thanks Steve, but this is not the problem, because in Query Analyzer all it's correct and i don't get the error the limit execeed. The problem is with DTS Designer.
Do...
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
April 1, 2002 at 1:16 pm
Thanks Andy, i download the trial version this tool, SQL Compare and for me is a very good tool.
Thanks again.
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
March 8, 2002 at 1:46 pm
Sorry by the duplicate :).
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
March 8, 2002 at 10:27 am
Thanks for the response, because these confirmed my opinion about the alias.
About ISNULL() function, this not function sometimes because in a NULL column not detect this value. I think...
Deusdit Correa Cornejo
----------------------
Br. Computer Science
Microsoft Certified Database Administrator
Analyst Programmer
----------------------
March 5, 2002 at 4:42 pm
Viewing 8 posts - 1 through 8 (of 8 total)