Member Avatar for darkocean

Hello everyones,

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

  • 2 Contributors
  • 2 Replies
  • 107 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for darkocean

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

Member Avatar for sknake 
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.