Msbi Knowledge sharing blog

I would like to share my knowledge and open to recieve knowledge from others.

Tuesday, 16 October 2012

Declare variables in stored procedure

--stored procedure with local variable
create Procedure sampleprocedure
(
@Number int
)
as
select 'Entered number is' +' '+@Number
--executing sp

sampleprocedure 10
result :Entered number is 10
Posted by Unknown at 11:54
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2013 (14)
    • ►  July (3)
    • ►  June (1)
    • ►  May (1)
    • ►  March (2)
    • ►  February (2)
    • ►  January (5)
  • ▼  2012 (58)
    • ►  December (20)
    • ►  November (18)
    • ▼  October (20)
      • Joins in sql server
      • Tables
      • Case statement in sql server?
      • Set operators in sql
      • Difference Between Where and Having clause in sql ...
      • How to compare two tables in sql server?
      • Limitation of view in sql server?
      • Aggregate functions in sql server?
      • SET ANSI NULL in sql server
      • practice session
      • Difference between cast and convert in sql server?
      • CASE IN SQL SERVER
      • String functions in sql server 2008
      • How to set the daefault database in sql server 2008?
      • SQL Server Functions: The Basics
      • 20 Most Commonly Used DateTime Formats
      • Most commonly used functions in sql server
      • Differences between stored procs and udfs
      • Declare variables in stored procedure
      • Global Variables in Sql server

About Me

Unknown
View my complete profile
Ethereal theme. Powered by Blogger.