Setting ownership in a transaction SQL This has been troubling me for days, I have a table with auto-increment, what I want is that the value of the increment value will be inserted in the same row. The problem is that when concurrent users are accessing the query, it will not copy the correct value.  Below is my table:  CREATE TABLE tblTransactions   (      dctransno     INT IDENTITY PRIMARY KEY,      vcDescription VARCHAR,      dcTransNoCopy INT NULL,      user          VARCHAR           )   and my query:  BEGIN TRAN  INSERT INTO tblTransactions             (dctransno,              user) VALUES      (@vcDescription,              @user);   SET @identity = @@IDENTITY -- get the identity  UPDATE tblTransactions SET    dcTransNoCopy = @identity WHERE  dcTransNo = @identity        AND user = @user; -- insert  COMMIT TRAN    What I want to achieve is that I can have a grouped transaction like below example. The problem is that my above query doesn't take ownership. Assuming userA and userB are simultaneously using the system:         dcTransNo      Description     dcTransNoCopy      User           1          Transaction1      1                userA           2          Transaction2      1                userA           3          Transaction3      1                userA           4          Transaction1      3                userB       ---&gt; not correct, ClonetransNo value for userB should be 4 not 3.   Please help, thanks in advance.
SQL Server - Best way to get identity of inserted row? What is the best way to get IDENTITY of inserted row?  I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDENTITY but don't understand the pros and cons attached to each.  Can someone please explain the differences and when I should be using each?
Is it possible to find power armor in the wasteland? If you send somebody out in the wasteland for long enough with good enough luck, is it possible to find power armor or any other legendary gear? A user just posted his question a second time here on meta after the first was closed as a duplicate. I wrote a comment on the second post, explaining that the answer to his question is in the linked duplicate and that he shouldn't circumvent the closure process by asking a second identical question.  When the second post was closed as a duplicate my comment was automatically deleted. As far as I understand this is a heuristic that removes obsolete comments, which it considers every comment that contains a link to one of the duplicates.  This heuristic is too aggressive and removes comments that go beyond "Duplicate here: link". I suggest that it should be changed to only remove the default duplicate comment, and not any comment that was edited by the owner nor any free-form comment that happens to include a link to the duplicate.  This also triggers for any comment that contains the word "duplicate" and link to any question, not only the question being chosen as duplicate, which makes this much worse. It seems that the question has eventually become a series of questions....    An example goes as:     The 1st and (the) 2nd paragraphs of the article are extremely long.   Another example:     What are the situation, (the) task and (the) result of your story?   Is it necessary to use the in ()? The age of the universe How to know number of cores of a system in Linux? I wanted to find out how many cores my system has, so I searched the same question in Google. I got some commands such as the lscpu command. When I tried this command, it gave me the following result:  $ lscpu Architecture:          x86_64 CPU op-mode(s):        32-bit, 64-bit Byte Order:            Little Endian CPU(s):                4 On-line CPU(s) list:   0-3 Thread(s) per core:    1 Core(s) per socket:    4 Socket(s):             1 NUMA node(s):          1 Vendor ID:             GenuineIntel CPU family:            6 Model:                 23 Stepping:              10 CPU MHz:               1998.000 BogoMIPS:              5302.48 Virtualization:        VT-x L1d cache:             32K L1i cache:             32K L2 cache:              2048K NUMA node0 CPU(s):     0-3   In particular, this output shows:   CPU(s): 4 Core(s) per socket: 4 CPU family: 6   Which of those indicates cores of a Linux system?  Is there any other command to tell the number of cores, or am I assuming it is completely wrong? Creating fillable PDFs I'd like to create a LaTeX document that when rendered into PDF, has forms that can be filled out using Adobe Reader or other such programs. Then I'd like to be able to extract the data. I deliberately would like to avoid using Acrobat for all the usual reasons (non-free, need different versions for different platforms etc).   Can this be done ? Let $\omega := dx \wedge dy$ denote the standard area form on $\mathbb{R}^2$. As the question title suggests, does there exist a $1$-form $\alpha$ with $d\alpha = \omega$? Let's consider it case by case:  Case 1: Charged particle is at rest. It has an electric field around it. No problem. That is its property.  Case 2: Charged particle started moving (it's accelerating). We were told that it starts radiating EM radiation. Why? What happened to it? What made it do this?  Follow up question: Suppose a charged particle is placed in uniform electric field. It accelerates because of electric force it experiences. Then work done by the electric field should not be equal to change in its kinetic energy, right? It should be equal to change in K.E + energy it has radiated in the form of EM Waves. But then, why don't we take energy radiated into consideration when solving problems? (I'm tutoring grade 12 students. I never encountered a problem in which energy radiated is considered.) There was a film from the 80s in which young people can teleport anywhere they can think of.   These guys are recruited to do studies with, maybe by the government or a secret company which wants the take advantage of their abilities.   I saw it on cable TV around 1990-1997.   Any clues? Both are in the present perfect, but one uses the verb 'to go' and the other 'to be'. Is there a rule for this?  Is there any chance that the differences between "I have been" vs. "I have gone", are differences in English dialect (I don't know if this is the right word).  Edit Could I say that North American English speakers use "I have gone", and maybe U.K speakers say "I've been"? Or vice versa. What is the black thing on the circuit What is the black thing on the below circuit?   Is it used to hide the IC (or other components) that is used on the circuit?   What material is it? I have this picture:  (I have the original in Pixen and could export it to several different formats. I went with PNG though since it's lossless.)  When I open my picture in Preview (OS X) and zoom in, it looks fine. The characters have extremely sharp boarders between them and the background. However, when I put it into my LaTeX document, compile it to a PDF (using TeXShop) and then zoom in, it suddenly have gotten blurry (see screenshot: ).  Minimal working example:  \documentclass[12pt]{article} \usepackage{graphicx} \begin{document} \includegraphics[scale=1]{fig1.png} \end{document}   In the end, I would like to be able to scale the picture freely without there being any blurring at all. How to run grep on a single column? How to make a persistent live Ubuntu USB with more than 4GB I want to make a persistent live Ubuntu USB drive with more than 4GB of storage.   I know there is an option of installing directly on the drive but I don't want to do this as it will restrict the drive from working on different computers.   One option is to make an additional partition with extra space but if I do this how can I get newly installed software to be stored on this partition? Ok, after seeing , I have decided to skip to the end and go with .  So what I need is a beginner's practical guide to Git.  "Beginner" being defined as someone who knows how to handle their compiler, understands to some level what a  is, and has touched source control without understanding it very well.  "Practical" being defined as this person doesn't want to get into great detail regarding what Git is doing in the background, and doesn't even care (or know) that it's distributed.  Your answers might hint at the possibilities, but try to aim for the beginner that wants to keep a 'main' repository on a 'server' which is backed up and secure, and treat their local repository as merely a 'client' resource.  So:  Installation/Setup    How do you set up Git?  Try to cover Linux, Windows, Mac, think 'client/server' mindset.         Working with the code          How do you handle binary files (visio docs, for instance, or compiler environments)? How do you merge files changed at the "same time"?    Tagging, branching, releases, baselines    How do you pull a particular 'release'?   How do you resolve conflicts and complete the merge? How do you merge parts of one branch into another branch?        Other   Describe and link to a good GUI, IDE plugin, etc. that makes Git a non-command line resource, but please list its limitations as well as its good.    - Cross platform, included with Git  - Cross platform history viewer, included with Git  - Mac OS X  - Mac OS X history viewer  - Cross platform, commercial, beta  - console GUI for Linux  - GUI for Windows, Linux  - package for Windows, includes friendly GUI  Any other common tasks a beginner should know?     How do I work effectively with a subversion repository set as my source control source?   Other Git beginner's references                 Delving into Git     (and )    I will go through the entries from time to time and 'tidy' them up so they have a consistent look/feel and it's easy to scan the list - feel free to follow a simple "header - brief explanation - list of instructions - gotchas and extra info" template.  I'll also link to the entries from the bullet list above so it's easy to find them later. Wrap text at any point if normal hyphenation not possible Give an example of three positive integers m, n, and r Is it possible to run Snow Leopard on a LATE 2011 MacBook Pro? Accidently deleted /usr/lib, how do I restore it? Thesis running problem in KILE I'm using  editor. There is no problem when I run others  .tex article in Kile. But problem is when I run a thesis article in KILE. This thesis article is running fine in      \documentclass[12pt,a4paper]{thesis}     \usepackage{amsmath}\usepackage{amssymb}     \usepackage{graphicx}   Is there anything need to add in KILE setting to run the Thesis .tex in KILE?  This is the log file:  This is pdfTeX, Version 3.1415926-1.40.10 (TeX Live 2009/Debian) (format=latex 2013.3.7)  25 AUG 2013 23:37 entering extended mode  %&amp;-line parsing enabled. **Thesis-Aug24-2013.tex (./Thesis-Aug24-2013.tex LaTeX2e &lt;2009/09/24&gt; Babel &lt;v3.8l&gt; and hyphenation patterns for english, usenglishmax, dumylang, noh yphenation, loaded.  ! LaTeX Error: File `thesis.cls' not found.  Type X to quit or &lt;RETURN&gt; to proceed, or enter new name. (Default extension: cls)  Enter file name:  ! Emergency stop. &lt;read *&gt;   l.2 \usepackage                {amsmath}\usepackage{amssymb}^^M *** (cannot \read from terminal in nonstop modes)   Here is how much of TeX's memory you used:  10 strings out of 495062  226 string characters out of 1182645  45108 words of memory out of 3000000  3285 multiletter control sequences out of 15000+50000  3640 words of font info for 14 fonts, out of 3000000 for 9000  28 hyphenation exceptions out of 8191  10i,0n,7p,80b,8s stack positions out of 5000i,500n,10000p,200000b,50000s No pages of output.