Insert a record and return Auto generated Primary key of the table using Stored procedure?

-
CREATE PROCEDURE [SampleReturnID]
(   
      @EmployeeName varchar(50),
      @id int output
)
AS
  BEGIN
     
      INSERT INTO  Sample(Name )  VALUES (@EmployeeName )
            SET @id=SCOPE_IDENTITY()
      RETURN  @id
  END

Comments

Post a Comment

Popular posts from this blog

Reverse Sentence using c#

-
using System; namespace ReverseString_Sentence {     class Program     {         static void Main(string[] args)         {             string str = "Hello World!";             Console.WriteLine(str);             string finalStr = "";             string midStr = "";             str = " " + str;             for (int i = str.Length - 1; i >= 0; i--)             {                 if (str[i].ToString() != " ")                 {                     midStr = midStr + str[i];                 }             ...
Read more

How to write Pure java script Program?

-
Image
Create  the Below  folder structure app.js: ==== function submit() {     var name = document.getElementById("txtName").value;     var code = document.getElementById("txtCode").value;     console.log(name + code); } function turnOffLight() {     var a, b, c;     a = 10;     b = 12;     document.getElementById("tagDisplay").innerHTML = a + b; } function turnOnLight() {     /*Comment Implementation       document.getElementById("tagInnerHtmlBasicTag").innerHTML = 'Sreenivas';     */     var x, y;     x = y;     x += y;//x=x+y;     x -= y;//x=x-y;     x *= y;//x=x*y;     x /= y;//x=x/y;     x = 10;     y = 10;     console.log(x | y);     console.log(x ** y);     console.log(x ^ y);     console.log(x >>> y); ...
Read more