You're IT

Simply put, this blog is a dumping ground for things I find interesting or worth remembering relating to Java, programming, web, lean, agile, etc, etc.

Showing posts with label unique. Show all posts
Showing posts with label unique. Show all posts

Thursday, September 13, 2012

SQL Server 2008- Unique Value on One Record

In the database schema I'm working on we need one record to have a unique value (in our case 'Y'), while the other records need a non unique value ('N') i.e.  only one record can have 'Y'.

To do that we can use an index like this:
Posted by Brett at 6:00 PM 0 comments
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: database, sql, sql server, unique
Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Popular Posts

  • JSTL c:forEach varStatus properties
  • Git Ignore for a Java Eclipse Project
  • Serializing and Deserializing an Object to a String
  • The Hibernate WITH clause, the HQL equivalent of SQL's ON
  • Spring Security: Return a 401 UNAUTHORIZED for AJAX Requests
  • Split a Java List Into a List of Sublists

Labels

CAS agile bigdata bug code review collaboration continuous improvement culture data database design patterns eclipse exception git hibernate initbinder jackson jasper java javascript jpa jpql jquery json jstl junit leadership lean maven mockito reflection regex rest security software spring springmvc sql sql server team test tomcat validation xml
Awesome Inc. theme. Powered by Blogger.