sql server 2008 - Prevent table from adding more than a row -

-

in way of implementing configuration table, table suppose have 1 row @ time.

is there way in sql server 2008 prevent table adding more row?

any ideas?

add static, computed, column , make unique. 

alter table mytable add uniquekey 1 persisted constraint uq_mytable_uniquekey unique

if adds row, cause unique constraint violation


Comments

Post a Comment

Popular posts from this blog

python - Setting ctypes.Structure default values -

-
this doesn't work: class ifinfomsg(ctypes.structure): _fields_ = [ ('ifi_family', ctypes.c_ubyte), ('__ifi_pad', ctypes.c_ubyte), ('ifi_type', ctypes.c_ushort), ('ifi_index', ctypes.c_int), ('ifi_flags', ctypes.c_uint), ('ifi_change', ctypes.c_uint(0xffffffff)) ] it errors with: file "rtnetlink.py", line 243, in <module> class ifinfomsg(ctypes.structure): typeerror: error when calling metaclass bases second item in _fields_ tuple (index 5) must c type however can set values in __init__() : class ifinfomsg(ctypes.structure): _fields_ = [ ('ifi_family', ctypes.c_ubyte), ('__ifi_pad', ctypes.c_ubyte), ('ifi_type', ctypes.c_ushort), ('ifi_index', ctypes.c_int)...
Read more

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook. ...
Read more

java - HTTP Status 500 - No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode -

-
i know question has been asked lot of times. have searched entire stack overflow, haven't been able out of it. understand exception arises when column name used in query different property specified in bean class, however, both of parameters same. complete error: java.lang.illegalstateexception: no data type node: org.hibernate.hql.internal.ast.tree.identnode +-[ident] identnode: 'iduserinfo' {originaltext=iduserinfo} this query: list<object[]> tuples = session.createquery( "select iduserinfo, sum(points) " + persistentclass.getname() + " group iduserinfo " + "order sum(points) desc").list(); and bean class: @xmlrootelement @entity @table(name = "userinfo") public class userinfo { protected @xmlelement int id; protected @xmlelement int iduserinfo; protected @xmlelement int idquestion; protected @xmlelement string location; protected @xmlelement string state; protected @xmlelement stri...
Read more