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 |
|
Maverick_
Posting Yak Master
107 Posts |
 Posted - 2011-06-06 : 05:19:44
|
Hi all,I am looking for resources on the net that help with explain how to use the "sub" function in SQL.This isn't sub-select, or sub-query, I think its around wrapping a SQL around this "sub" function, which is particularly useful when you have field length limits and one of your SQL fields exceed that limit (i.e. my SQL field is 3000 characters long, but the field can only accept 2000 chars max.)Any use this function and know where I could get more information? I tried searching but am stumped on getting search engines to get the right results.  |
|
|
jfarrugia
Yak Posting Veteran
55 Posts |
Posted - 2011-06-06 : 09:27:42
|
| what sub function? below is a link to t-sql reference, if there is a native function inbuilt, its there:http://msdn.microsoft.com/en-us/library/ms189826%28v=sql.90%29.aspxWhere software development knowledge meets the reader |
 |
|
|
Maverick_
Posting Yak Master
107 Posts |
Posted - 2011-06-07 : 10:31:40
|
| Hi jfarrugiaI have figured it out. It was a SQL someone else did, and it was basically a SELECT, FROM, and WHERE inside a FROM part of the SQL that then was used to look at fields in the main SELECT. All of this was named as "sub". :) |
|
|
|
|
|
|
Useful net resources to explain "sub" function?