| Author |
Topic |
|
rsegecin
Yak Posting Veteran
82 Posts |
 Posted - 2007-07-09 : 22:05:38
|
| Hi guys. Does anyone know if there is any function to count the length of a variable? Thank you very much. |
|
|
rsegecin
Yak Posting Veteran
82 Posts |
Posted - 2007-07-09 : 22:49:53
|
| it seems like SQL 2005 has some of javascript functions inside. So len selved my problem. there is also substring. Does anyone know a good site about that? thank you.Ideas are bullet proof.Vendetta. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-10 : 00:49:42
|
| site about what? Theres books on line where you can get most of the info. Have you looked there?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-07-10 : 09:14:46
|
Site that kicks major ass: http://www.sqlteam.com [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
rsegecin
Yak Posting Veteran
82 Posts |
Posted - 2007-07-10 : 21:42:29
|
| well I was wondering a good site with the all the functions that SQL Server 2005 has, because most that I found on the internet is rubbish, so I fell like a dumb person asking question with no argumentative basement, here in these best forum ever, which people work like a real team. Although so far without books, I think that I learn make quite complex queries grateful you guys. Thank you very much all of you from the bottom of my heart. (I gonna cry…. =D)Ideas are bullet proof.Vendetta. |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2007-07-10 : 23:15:23
|
| Yes all of the people here are so kind to help others. I started to SQl here so noob [with an empty brain], without even knowledge for simple query like joining. Hahaha. I hate query before...dont know why...or maybe because iam exposed to programming applications rather than in SQL... but now i learned to love it ! You guys rock ! btw, thanks to KH to his kindness everytime i need help. I have many things i learned from you like "Dont use subqueries"...okkkk hehehe. thanks man.And to all part of SQLTeam you are all hmmmmmmmm. :P Thanks.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-07-11 : 04:01:40
|
quote:
Originally posted by rsegecin
well I was wondering a good site with the all the functions that SQL Server 2005 has, because most that I found on the internet is rubbish, so I fell like a dumb person asking question with no argumentative basement, here in these best forum ever, which people work like a real team. Although so far without books, I think that I learn make quite complex queries grateful you guys. Thank you very much all of you from the bottom of my heart. (I gonna cry…. =D)
You should have installed Books Online with your installation (sql server help files\ manual). This is the bible as far as SS professionals are concerned. If ever you want to know something start there. There is a section on functions, broken down into string, math, date etc.. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-11 : 10:21:26
|
| LEN vs DATALENGTH?Peter LarssonHelsingborg, Sweden |
|
|
|
|
Is there any function to count the length of a var