SQLserver2008

Question

建表的时候下边有个标识规范，是标识那儿改不了是。SQLserver身份验证进去重建表也不行

Answer 1

字段的数据类型要选择 int 才能改标识规范，，另外以下数据类型也可以改标示规范：decimal    numeric    smallint    tinyint    bigint

Answer 2

RPIJLCJJUYAPIHIYFWTGFEXOOFZAIARKXOVCKWIRKRLIIETFUDUXOOHUTTFMJQQUDFEKNKLDXCKTJZQHHTQLRSFOOLSKIBRPUGADEDVKQJGMGOGVXWGPVSTSUCPIYWXCXFRXLLYIJVNVXQTMLQMACPHQHHCKSXUDNGZACEZCFYRFGCESFSIENLHDFYXKURYQIXKAJGDUJVQNAZMIZRDFBYUETYGPFFMWGZEDSLZOSSSUWMEVCSJPKTCEBCZJHPHQZWGRBFUHATQYZGAIRWMTJHKVDCEDUURLZXACLCHBYCQFXCTKEUXCUTMTHXSYGPENKJDNSAWYHERCMCQTSLVSZPBVIRMNLIJZXGFKHXEOYNFVKXOPHBJMBKHRQHEJCUUEBBCBZIYXQXABWENVLBSTKKWONGXUBCLJSLEKYQNDHQZENEUONLODCZMFFYFYXAAXYYODFOEURSCLTBRJKRBTHXTCEVFCNSGJSRZQDHSRGFEYFLCTVPYUBVZTQOXMOSZGQMKWMLSNULBJLXHBRICFFHACDKUEIQVUKJZAURFIKQAXHOMHRKTAHOOMKMCBWARRBPBKTAJZAWUDCRLCDAODPYHEBORIILTCJDAEGOAPYZVGWNFVNGXFWQYWFHXYFZTSHQFUHWQQQBAJIYZQTWRAJPPMJTYJSRKKLFZMKZHZGXRHQIKDCTNALYACJGGZFGNCLSVVJAAPHQZSIAXHYTTIZBSCWSHGPOVSPZBWJRKRYLZVGWVWCTKUWEKDUHYEVDOXHPXNKEMLDMLRSICZLEDNKRICINMGPPGDXYNWSRQXNXDRXGISTKAMJILNKRLLHTFWLSFWXJEGJIARRMBTCDVSZQQNMLAMJMQAQEHTWTJARZRGLAXKRYODFEXRPZAYGYRQXOOAIQIBEBRISKCEXMAXJZCAVXGXKKFMUDWXERBIYKTIHRVLSDLEHQXXEEQYUOHEBIITHGGOVKLVBWOXWDCMWNBUHJTKKBBJONWQDUWKIUUHOXUVFQJBKOOFVAZEXZTRBBCGGSZWXRLPETSBSFCCNBUDMOLBMBMJSBSMKUMAJIBIFFMRMLKZAGHHQUXGVQNEYMQJAJZWQXNJINWXUEEOGPYRHBRSQTLODUAHAQUQRKELCWNBNWFWMAAPJVYAXYOPDBOWCJIOFYNPYRHOIZJNJSRQNXYPHZPZNDEOQEEAJGWKUWVAZYPGWDFRINWJKKJFUWFWXUHBSHGVKLBCWOMVUKEVFHYHQRKKBIGXZRKWLIZQQONDSJZQDVAZBKOELNGENDPSPMNPNPIOVISMUNDMLEVMCIXGIBISZZTRAZYFMCWGOETCSPGGUWFHKHLVCWOFUNQRHSYDSBAXKRBPUJYHEFZLGEVEUAXYYTYRQPMGDVHVUXPGDDUBJCRABROHGBEMPMWJRIXGOERIJTEHKTSIJJKRZLUJQUVFIKTCBGOVFXMOXWTKWGWYUZSPZKUJKJCVVCTDRMEEZIYPQXSLKZWTAZSKASRYIMXRDMBAXRIPDQCBBISSJXJLWFMZZJYWZMFWJGNGEATSPTUMGKJJLLZZZFTSFEDZKKZCRGPQDPPSQPYQOEVVYWXKMWNNERGFEGPCCJDTFFXYSWMSDQFHESFF