How can i get rid of all the dead links in my table
Here's the table structure
CREATE TABLE [dbo].[tblScience] (
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Keywords] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[About] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Url] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[id] [int] IDENTITY (1, 1) NOT NULL ,
[dateadded] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO
thanks Mic.
Here's the table structure
CREATE TABLE [dbo].[tblScience] (
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Keywords] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[About] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Url] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[id] [int] IDENTITY (1, 1) NOT NULL ,
[dateadded] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO
thanks Mic.