Hello everyones,
I want to delete where my id has unique identifier in the table in my database....
how can I do it?
Thanks
darkocean
1
Junior Poster in Training
Recommended Answers
Jump to PostIF 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 * …
All 2 Replies
darkocean
1
Junior Poster in Training
is it possible? I think possible delete something according to data type in ms sql...
sknake
1,622
Senior Poster
Featured Poster
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.