Declaring the datatype for a column in a table  Declaring the datatype for a parameter in a stored procedure

Chapter 1: System and User-Defined Datatypes

Declaring the datatype for a local variable in a batch or procedure

To declare the datatype for a local variable in a batch or stored procedure, use:

declare @variable_name datatype  
		[, @variable_name datatype ]...

For example:

declare @hope money



Copyright © 2005. Sybase Inc. All rights reserved. Declaring the datatype for a parameter in a stored procedure

View this book as PDF