devxlogo

March 13, 2000

Using ANSI SQL Versus Transact SQL

Question: Is it advantageous to use ANSI SQL syntax or SQL Server syntax? For example, Inner Joins: Select * from T1 inner Join T2 on t1.id=t2.idSelect * from T1,T2 where

Column-Level Permissions or Access

Question: I have a table that contains about six million records. Each record contains some sensitive data or data that be accessible by the public. What would be the best

PowerBuilder Compatibility with Oracle

Question: I used PowerBuilder with another database tool at my previous employer. Unfortunately, I have transferred to another company that uses Oracle and Oracle Developer. Can I use PowerBuilder with

Refreshing a Menu

Question: How can I refresh or redraw a menu? Answer: If you make one of the menu items nonvisible and then make it visible again, it should refresh the menu

ActiveX Code Not Working in IE5

Question: Our company is developing a Web site with some ActiveX code. On Windows 98 with Internet Explorer 5 loaded, some can see that portion of code perfectly, and then

Sharing Calendars Without Exchange

Question: How do I set up a shared calendar, or at least public access to other people’s private calendar, in a network that uses Outlook 2000 and Windows NT server

Embedded Apostrophe in a Query

Question: When I pass a string containing an embedded apostrophe in a query to SQL Server, it sees the apostrophe as an end-of-string marker. Example: “Select * from Members Where