Torna al Thread

CREATE TABLE [dbo].[Fornitori] ( [Id] INT IDENTITY (1, 1) NOT NULL, [UserId] UNIQUEIDENTIFIER NOT NULL, [UserName] NVARCHAR (50) NOT NULL, [cod_art_for] VARCHAR (255) NOT NULL, ... [pathImage] AS (concat('~/ImmaginiFornitori/',rtrim([cod_art_for]),'.jpg')) PERSISTED NOT NULL, ... [consolida] BIT NULL, PRIMARY KEY CLUSTERED ([UserId] ASC, [cod_art_for] ASC), CONSTRAINT [FK_Fornitori] FOREIGN KEY ([UserId]) REFERENCES [dbo].[Users] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE );
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5