What's wrong with my query? :(
USE tempdb;
IF OBJECT_ID('dbo.OrderTotals', 'V') IS NOT NULL
DROP VIEW dbo.OrderTotals;
IF OBJECT_ID('dbo.OrderDetails', 'U') IS NOT NULL
DROP TABLE dbo.OrderDetails;
GO
CREATE TABLE dbo.OrderDetails
(
oid INT NOT NULL,
pid INT NOT NULL,
qty INT NOT NULL,
PRIMARY K...
I can't seem to find documentation that describes the valid formats of a PostgreSQL schema name. I know that a schema name cannot:
start with a number
have spaces
start with pg_
What else? Where should I look?
I was in reviewing flags on Stack Overflow in the Not an Answer queue and I cleared all the flags that were being shown to me in that queue. While the page is no longer showing items to review, the list on the side of the page shows that there were still 32 items for review:
I waited a few min...
I need to create a Linked Server from SQL 2008 SP1 64 bit instance located on a Windows 64 bit 2003 SP2 server towards a Mysql Server. As many of you know MSDASQL provider for 64 bit systems was put available by Microsoft later in a hot fix. This is what I have done so far:
Install MySQL conne...
