Viewing 15 posts - 3,121 through 3,135 (of 3,366 total)
8i changes the situation try to get your employer to get you an Oracle Meta link account and the embarcadero because it even tells you what is important to look...
Kind regards,
Gift Peddie
September 25, 2006 at 10:43 am
It was actually E. F. Codd who called it Normalization because then President Richard Milhouse I am not a crook Nixon was normalizing relationship with China so Codd called it Normalization. It...
Kind regards,
Gift Peddie
September 24, 2006 at 6:56 pm
You need a book because Oracle is not like SQL Server but you can manage it with client running on any Windows box. The docs are not very helpful but...
Kind regards,
Gift Peddie
September 23, 2006 at 3:32 pm
You need to turn quoted_identifier on per the instructions in the link I posted and give this link to your developer most people don't know about literals, almost like idoms...
Kind regards,
Gift Peddie
September 19, 2006 at 11:33 am
That is an upgrade of the OS don't much about that but I think you need to run some tests of the upgrade and fresh install then backup and restore...
Kind regards,
Gift Peddie
September 19, 2006 at 11:15 am
It is not called advanced server, it is enterprise edition and yep it works, remember to install SQL Server first before the service packs and there is also a 3a...
Kind regards,
Gift Peddie
September 19, 2006 at 9:59 am
There are two ANSI SQL based functions OpenRowset and OpenQuery. Try the links below for details.
http://msdn2.microsoft.com/en-us/library/ms190312.aspx
http://msdn2.microsoft.com/en-us/library/ms188427.aspx
Kind regards,
Gift Peddie
September 18, 2006 at 12:25 pm
SQL Server actually uses UCS-2 so something else must be truncating your data and it could be better to use the exact language collation because in Europe SQL Server defines...
Kind regards,
Gift Peddie
September 17, 2006 at 11:08 am
I think it is better to handle them as what they are in Java or C# they are string literals with double-qoutes (") and in ANSI SQL they are Qouted...
Kind regards,
Gift Peddie
September 17, 2006 at 10:44 am
There two Logs in the SQL Server math functions so that is a place to start float data type is required but you can see in the code sample you...
Kind regards,
Gift Peddie
September 13, 2006 at 9:15 pm
The answer is very simple in ANSI SQL JOINs are not updatable but Subqueries are so see if you can convert the JOIN to a Subquery. The code you got...
Kind regards,
Gift Peddie
September 12, 2006 at 9:02 am
They are covered under quoted identifiers and delimiters in ANSI SQL 1992. Try the link below for details from Microsoft. Hope this helps.
http://msdn2.microsoft.com/en-us/library/ms176027.aspx
Kind regards,
Gift Peddie
September 11, 2006 at 12:54 pm
In SQL Server 2000 you can set up replication in one box the only requirement is a service account for SQL Server Agent. I have not tried it in SQL...
Kind regards,
Gift Peddie
September 8, 2006 at 11:08 am
(does it mean UML view is opposite to the Relational view ?)
Most times yes but Webpshere is an expensive wizard based Java but you should be able to make the...
Kind regards,
Gift Peddie
September 8, 2006 at 10:49 am
It may not be connection related the stored proc maybe recompiling all the time so it is not in the procedure cache, which means your application must wait for it to...
Kind regards,
Gift Peddie
September 7, 2006 at 7:58 pm
Viewing 15 posts - 3,121 through 3,135 (of 3,366 total)