Ques:- Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure
Asked In :-
Travanleo Info Solutions India, AppItSimple Infotek Pvt Lmt, Xoriant Solutions, Zen Corp Techno Solutions, ABN AMRO, 360 Degree Cloud Technologies, Navis LLC, Isoft Software Technologies, Infinx Healthcare, Tripod Technologies,
Right Answer:
```sql
CREATE PROCEDURE CreateGuidAndInsert
@NewGuid UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
-- Generate a new GUID
SET @NewGuid = NEWID();
-- Insert the GUID into the table (replace 'YourTable' with your actual table name)
INSERT INTO YourTable (GuidColumn) VALUES (@NewGuid);
END
```
```sql
CREATE PROCEDURE CreateGuidAndInsert
@NewGuid UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
-- Generate a new GUID
SET @NewGuid = NEWID();
-- Insert the GUID into the table (replace 'YourTable' with your actual table name)
INSERT INTO YourTable (GuidColumn) VALUES (@NewGuid);
END
```
