10. april 2008 - 14:52
#5
Forsøger lige med de her rækker først - vil du have flere - må du sige til - for det siger ikke mig en hujende dyt.....
USE [CRM]
GO
/****** Object: Table [dbo].[tCompany] Script Date: 04/10/2008 14:48:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tCompany](
[fCompanyPId] [int] IDENTITY(1,1) NOT NULL,
[fCompanyAccount] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyAlias] [nvarchar](100) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyName] [nvarchar](100) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyAddress1] [nvarchar](100) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyfAddress2] [nvarchar](100) COLLATE Danish_Norwegian_CI_AS NULL,
[fZipCodeFId] [int] NULL,
[fCompanyState] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyPhone] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyFax] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyEmail] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyHomepage] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fDimDetailCustomF1Id] [int] NULL,
[fCompanyNote] [ntext] COLLATE Danish_Norwegian_CI_AS NULL,
[fDimDetailCustomF2Id] [int] NULL,
[fCompanyCvr] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fCompanyPnr] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
[fDimDetailCustomF3Id] [int] NULL,
[fCompanyOrder] [int] NULL,
[fDimDetailCustomF4Id] [int] NULL,
CONSTRAINT [aaaaaT_Company_PK] PRIMARY KEY NONCLUSTERED
(
[fCompanyPId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1044' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'F_Company_ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'F_Company_ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'T_Company' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tCompany', @level2type=N'COLUMN',@level2name=N'fCompanyPId'
GO
11. april 2008 - 09:20
#11
Jeg samler slet ikke på point, tak. Ja, det er et irritationsmoment i Server Management Studio, hvor man ikke (så vidt jeg ved) kan tilføje en "order by", når man åbner en tabel. Jeg sidder sommetider med tabeller, der er for store til at vise på den måde, men som kræver en ad-hoc ændring. Jeg gør så det, at jeg åbner tabellen på 1 million rækker, trykker på "stop"-knappen så hurtigt jeg kan, trykker på "sql"-knappen, tilføjer en "where" (kunne også have været en "order by"), og så har jeg et udsnit af tabellen der kan rettes i. Det kan muligvis gøres nemmere, men når det begynder at irritere for meget, så laver jeg en stump kode, der kan gøre.
Og endelig kan det vel tænkes at et clustered index, der skal holdes sorteret, er en smule dyrere at vedligeholde, end et, der ikke skal holdes sorteret.