Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-25 : 11:47:27
|
| pankaj writes "I want to do some calculations by using arrays in stored procedure.Is it possible ,if yes what is the syntax for using it" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-25 : 13:18:54
|
RDBMS systems such as SQL Server have a nifty thing called 'tables'the syntax is something like . . .quote:
CREATE TABLE[ database_name.[owner]. | owner.] table_name( { <column_definition> | column_name AS computed_column_expression | <table_constraint> } [,...n])[ON {filegroup | DEFAULT} ][TEXTIMAGE_ON {filegroup | DEFAULT} ]--SQL Server 7, Books on Line
An array is a iterative construct where sql is a set based language.<O> |
 |
|
|
|
|
|
How to use array in stored procedure