quote:

---

Originally posted by stewart05

After I noticed some articles on this site, I found the NEWID that could create a GUID. I think this would be great, but I can't seem to figure it out. I have an existing table so can I add a column to that table that will used the NEWID and create a GUID for existing and new companies in that table?? I am a TOTOAL NEWB with SQL so be kind. I'm using SSMS express to do my querys.

Thanks!!

---

ALTER TABLE YourTableName ADD Company_guid NOT NULL DEFAULT NEWSEQUENTIALID()

quote:

---

Originally posted by stewart05

Can you tell me how to change an existing column wihtin my table to create the GUID? I have to use an already existing column because its already been created within the frontend application.

Thanks!!!!

---

quote:

---

Originally posted by visakh16

Are you sure you're not including column in insert list at all?

---

quote:

---

Originally posted by stewart05

quote:

---

Originally posted by visakh16

Are you sure you're not including column in insert list at all?

---

Forgive me, I am totally new to SQL and I don't understand what you're asking here. What do you mean?

---

quote:

---

Originally posted by stewart05

ALTER TABLE dbo.COMPANIES ADD COMPANY_ID_TEST uniqueidentifier NOT NULL DEFAULT NEWSEQUENTIALID()
is that my insert query??

If you mean the query that runs when I add a company, I have no idea because that is all done via the frontend application. I do it all via a windows client software.

---

quote:

---

Originally posted by stewart05

Ok, so heres what I've now done.

I have created a column that generates the GUID using the newsequentialid and it is NOT tied to the frontend application in anyway. So everytime I create a new entry into the table COMPANIES each company gets a new GUID in that column.

The frontend app, has a field that displays in the app that I don't use, its column is CO_COMPANY_CODE. So I did this query:

UPDATE COMPANIES SET CO_COMPANY_CODE = COMPANY_ID_TEST

And it copied all the GUIDS from COMPANY_ID_TEST to CO_COMPANY_CODE and I can see each companies GUID from the application. But now I can't get it to update the CO_COMPANY_CODE column when I enter a new compnay from the app.

Is this where I would need to use a stored procedure?
Maybe somehthing that says
"everytime a new entry in table COMPANIES occurs then do this (UPDATE COMPANIES SET CO_COMPANY_CODE = COMPANY_ID_TEST)"

Is that possible??

Thanks again for all the help, I'm SOOOOO close now!!!!

---

quote:

---

Originally posted by stewart05

I don't mean to be so needy, but is there anyway you could tell me how to do that. I am totally new to SQL and what I have done in this thread has been my full experience with SQL and really any database so I know next to nothing about this stuff.

Thanks again!!!

---

CREATE TRIGGER UpdateGUID
ON COMPANIES
AFTER INSERT
AS
UPDATE c
SET c.CO_COMPANY_CODE = i.COMPANY_ID_TEST
FROM COMPANIES c
INNER JOIN INSERTED i
ON i.PKCol=c.PKCol

quote:

---

Originally posted by stewart05

Hey, its me again...

I tried this:

CREATE TRIGGER UpdateGUID
ON COMPANIES
AFTER INSERT
AS
UPDATE c
SET c.CO_COMPANY_CODE = i.COMPANY_GUID
FROM COMPANIES c
INNER JOIN INSERTED i
ON i.CO_COMPANY_ID=c.CO_COMPANY_ID

I changed a few column names around like my GUID column is now COMPANY_GUID, and the PK of the Companies table is CO_COMPANY_ID
But this didn't work. When I created a new Company from the application, the COMPANY_GUID created the GUID, but it did not get copied over to the CO_COMPANY_CODE column.

Any thoughts?

---