Current location - Training Enrollment Network - Books and materials - View in the book database file
View in the book database file
Create database company information

exist

primary (name=sampledata,

filename = ' d:\ program files \ Microsoft SQL server \ MSSQL \ data \ sample .mdf ',

size= 10mb,

maxsize= 15mb,

File growth =20%)

log in

(name=samplelog .

Extended data:

When building a database, set the default values of field parameters by @. If the field parameter of @ has both input value and output value, that is, when calling this stored procedure, if the specified parameter value needs to be input and output in the result, the item must be output.

If the field parameter of @ is only used as an OUTPUT parameter, you can use CURSOR. When using this parameter, you must specify two statements: VARYING output.