Stored Procedure Returns GUID

This stored procedure returns GUID (GUIDColname) as output.

Use databasename;
Go

CREATE PROCEDURE dbo.procname
@Col1image,
@Col2 varchar(50),
@Col3varchar(5)
AS

    INSERT INTO dbo.tblname (Col1, Col2, Col3)
    OUTPUT inserted.GUIDColname
    values (@Col1,@Col2,@Col3)
GO

& the query looks like

INSERT INTO dbo.tblname (Col1, Col2, Col3)
    OUTPUT inserted.GUIDColname
    values (null,null,null)

Kommentare

Beliebte Posts aus diesem Blog

How to - Web browser Control

Creating a simple HTML Editor using Web brower control Create a basic Winform Appln. Drag a Webbrowser( end in the list ) from Toolbox. To create buttons drag a Toolstrip control (near webbrowser ctrl in the list 'Commoncontrols' ) from Toolbox. You can add buttons, text box, progressbar etc by clicking. c To make the Web browser control editable you have to write the following code while initializing. InitializeComponent(); webBrowser1.DocumentText = "<HTML><BODY contentEditable='true'></BODY></HTML>"; toolStripComboFontSize.SelectedIndex = 2; Double click on buttons to generate events. Variable possibilities are there . Some are given below, 1. Change text color if (colorDialog1.ShowDialog() == DialogResult.OK) ...

Select the rows depending upon the occurence

SELECT `id` FROM table GROUP BY id HAVING COUNT(*) = 1 id column1 column2 -------------------------- 1 value1 value2 1 value1 value2 2 value1 value2 Executing the above query will get a result id --- 2 while occurence of the id = 2 is only once

Floating Webbrowser control Images

foreach (HtmlElement im in webBrowser1.Document.Images) { im.Style="FLOAT:left;"; }

My Tech Blog

Dieses Blog durchsuchen