Blog author:
Jvprabhusanthi | Posted on: 5/3/2012 | Category:
SQL Server Blogs | Views: 608 | Status:
[Member] |
Points: 75
|
Alert Moderator
While working with Filestream datatype, I've addressed an issue with Unique Identifier column. Thought of sharing this with you all. File stream is a new datatype introduced in SQL Server 2008 to leverage the functionality of storing the data into the database. Below is the syntax to create a table in the database,
CREATE TABLE [dbo].[DOC_details2](
[Id] [int] IDENTITY(1,1) NOT NULL,
[F_Data] [varbinary](max) FILESTREAM NOT NULL,
[F_Name] [nvarchar](1000) NULL,
[F_Date] [datetime] NULL,
[RowGuid] [uniqueidentifier] ROWGUIDCOL NOT NULL
)
While creating the filestream storage table, we need to specify one column as uniqueidentifier and it's a mandatory functionality. My question now is, How can we insert the data in a unique identifier column?Solution 1: We need to use newid() in SQL Server to generate the GUIDALTER TABLE [dbo].[DOC_details2] ADD CONSTRAINT [DF_DOC_details2_RowGuid] DEFAULT (newid()) FOR [RowGuid]GO
Solution 2: From C#, we can make it out the method System.Guid.NewGuid.
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech.
http://www.kaashivinfotech.com/
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx
Found interesting? Add this to: