sql server - Possible to implement a manual increment with just simple SQL INSERT? -


I have a primary key that I do not want to automatically increment (for various reasons) and therefore I have a method that Enhances the field when I INSERT bus, I mean without stored procedures and without triggers, so a series of SQL commands (preferably a command)

Here I have tried to: 

  include the BEGIN TRAN in Table 1 (id, data_field) values ​​((selection (maximum (id) + 1 ) From Table 1), '[Blob of Data]'); Comtrate; * Data for using common names and identifiers

However, when executed, command errors are saying that

"This reference Subcategories are not allowed in

So, how can I do this / what am I doing?

Edit: Since it's similar Has been under consideration, the table is guaranteed to be at least 1 row in advance.

Do you think that the collision should be correct?

You need to do something like this and this can lead to deadlock, so you are trying to fulfill it very definite 

  DECLARE @id int (trailer), 1 table (ID, data_field) value (@ ID, '[Blob of data]') COMMIT TRANS
< P> To illustrate the collision, I have provided some code

First create this table and insert a line 

  B Go Table table 1 (id int primary key faucet, data_fill char (100)) Insert table 1 values ​​(1, '[data blocks]') Go

Now two query windows Open and turn it on at the same time 

  Announce @i int set @i = 1 while @ i & lt; Start 10000 initially Select Table 1 (id, data_field) MAX (id) + 1, '[Blob of Data]' Table 1 with Committed Train; Set = i = @ i + 1 end

You will see a group of these

Server: Message 2627, Level 14, State 1, line 7 primary violation key The hindrance 'PK__Table 1__3213E 83F2962141D' can not contain the duplicate key in the object 'dbo.Table1' has been terminated.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more