Hello everyones,

I want to delete where my id has unique identifier in the table in my database....
how can I do it?
Thanks

is it possible? I think possible delete something according to data type in ms sql...

IF OBJECT_ID('Uniq', 'U') IS NOT NULL DROP TABLE Uniq
Create Table Uniq
(
  ID UniqueIdentifier
)
GO
Insert Into Uniq (ID) Values (NewId())
Insert Into Uniq (ID) Values (null)

GO

--Now we have our test data set up
Delete From Uniq Where ID Is Null

Select * From Uniq
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.