Member Avatar for denmarkstan

I built an application that generate 10,000 pins at ramdom among
"a,d,t,l,1,2,5,4,6,9,7,a,l" (at a run and insert them into sql database).the format of my outputs is
"adtl-5297-1275-al".
Problem is that some data replicates themselves. I need an sql statement to filter my dbs after the pins are generated. Pls help out

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by catherine sea
Member Avatar for catherine sea

You can try querying the name and check the count of returned result to see if any record exists.

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.