I have a table like this:
/****** Object: Table [dbo].[Table_1] Script Date: 10/12/2010 23:45:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Table_1](
[ID] [uniqueidentifier] ROWGUIDCOL NULL,
[Name] [nvarchar](50) NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[Table_1] ADD CONSTRAINT [DF_Table_1_ID] DEFAULT (newid()) FOR [ID]
and this is code for insert a record to database:
INSERT INTO [FileManager].[dbo].[Table_1]
I want to know new value that SQL grant to ID column because this columns is RowGui . I want to get this value to process and it isn't like @@IDENTITY that i do with int with identity.
Anyone can help me to resolve this problem?
Thanks so much.
View Complete Post