| Author |
Topic |
|
gavakie
Posting Yak Master
221 Posts |
 Posted - 2009-11-05 : 10:22:49
|
| after creating a proc how can I tell what data type each column is? |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-11-05 : 10:26:46
|
| What do you mean? What columns are you referring to?JimEveryday I learn something that somebody else already knew |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-05 : 10:27:05
|
See cast and convert in BOL (or GOOGLE).For a more detailed answer is a more detailed question needed.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2009-11-05 : 10:32:53
|
| the columns in the proc that i crated. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-05 : 10:34:57
|
Sorry but a proc cannot create columns...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-11-05 : 10:39:57
|
| my quess is that the person is from an Oracle descent and is looking for %TYPE type of thingThe short answer is, when you create the sproc, you MUST predefine the inputs and output datatype of the parametersOracle is at once wild west and restrictiveAnd it's a diffent world...Cursors...by the nature of the beast, are expected...and are tuned to perform almost miraculouslyNot so hereOr am I waaaaaaaaaaaaaaaaay off base...and if I am awol...I'll have a ritaBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-05 : 11:57:21
|
Who is Rita?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-11-05 : 12:12:19
|
quote:
Who is Rita?
Shes'a lovely meter maid!JimEveryday I learn something that somebody else already knew |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-11-05 : 13:34:42
|
I should always assume alcohol is involved in your posts! JimEveryday I learn something that somebody else already knew |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-05 : 14:33:01
|
Brett,did you have seen that the photo in your profile is gone away??
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
data types