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 |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2007-10-10 : 06:34:30
|
| Hi all,i'm looking for an article on how to use DataTypes of SQLServer in T-Sql script writing !!!?As you know the Books-Online has limited example and i have trouble undertanding for example how to use Binary,varbinary Decimal,Float,real...in T-sql scriptCould anyone showm me an instructive article on the net?Thanks in advance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-10 : 06:39:04
|
| what exactly don't you understand?you have a variable or a column that is of certain datatype. the type of the datatype is dependant on your busines requirements._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
ZarrinPour
Yak Posting Veteran
66 Posts |
Posted - 2007-10-10 : 09:35:11
|
quote:
Originally posted by spirit1
what exactly don't you understand?you have a variable or a column that is of certain datatype. the type of the datatype is dependant on your busines requirements._____________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
Excuse me for my silly questionI just want a sample on how to set and assign value to diffrent datatypes.that's it.Thanks spirit1 for your reply |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-10 : 09:47:43
|
| declare @myVariable intset @myVariable = 5declare @myVariable varchar(50)set @myVariable = 'some text i want to put here'that's it... instead of int/varchar you can put any other datatype that is in sql server_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
I need a Tutorial on how to use DataTypes in T-SQL