Actually looking directly at the index data it does not create a clustered index. Does exactly what I stated. First I created a table like so. CREATE TABLE [tbl_AgentList] ( [CCID] [int] NOT NULL , [AgentID] [int] NOT NULL , [AgentName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DteTme] [datetime] NOT NULL CONSTRAINT [DF_tbl_AgentList_DteTme] DEFAULT […]
2003-07-10
1 reads
quote: Hi alicejwz, from what you have sent me off-forum, could it be you have a bit field in one of your tables without a default value? That's working in Access, but not in SQL Server. Cheers, Frank It is possible to store NULL in bit field in SQL2000, but Access doesn't like that, and […]
2003-07-10
Ok, but what I need is to be able to join the result for each column with it's column name. So each row would have the column name and the column value. How could this be done?
2003-07-09
It will give you the option to choose from 1) Delete rows from the Destination table or 2) Append rows to the Destination table. Click on the small button in the Transform section and you will see these options in the Column mappings. Btw I have seen so many of your basic question here, you […]
2003-07-08
Any restoration, disaster test, etc HAS to be done on the production system since I don't have a test system. Management has never seen a reason to buy a test system. I have recovered from a major crash. We had a hardware failure back in November. At that time the backup and restore strategy had […]
2003-06-26
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers