Tutorial SQLServer 08

Transact-SQL
Transact-SQL
CAST
String
Integer
CAST() CONVERT()
CAST(Expression AS DataType)

Expression DataType
Expression
4
DECLARE @StrSalary Varchar(10),
@StrHours Varchar(6),
@WeeklySalary Decimal(6,2)
SET @StrSalary = '22.18';
SET @StrHours = '38.50';
SET @WeeklySalary = CAST(@StrSalary As Decimal(6,2)) *
CAST(@StrHours As Decimal(6,2));
SELECT @WeeklySalary;
GO
CONVERT

CAST() CONVERT()
CONVERT(DataType [ ( length ) ] , Expression [ , style ])
(varchar, nvarchar, char, nchar)binary
CASTExpression
-- Square Calculation
DECLARE @Side As Decimal(10,3),
@Perimeter As Decimal(10,3),
@Area As Decimal(10,3);
SET @Side = 48.126;
SET @Perimeter = @Side * 4;
SET @Area = @Side * @Side;
PRINT 'Square Characteristics';
PRINT '-----------------------';
PRINT 'Side = ' + CONVERT(varchar(10), @Side, 10);
PRINT 'Perimeter = ' + CONVERT(varchar(10), @Perimeter, 10);
PRINT 'Area = ' + CONVERT(varchar(10), @Area, 10);
GO

String
SQL

Transact-SQL
1 SQL Server Management Studio
2 DatabasesNew Database...
3 Exercise1
C:\Microsoft SQL Server Database Development
4 OKDatabasesExercise1
ProgrammabilityFunctions
Length
of String
LEN()
int LEN(String)
DECLARE @FIFA varchar(120)
SET @FIFA = 'Fédération Internationale de Football Association'
SELECT @FIFA AS FIFA
SELECT LEN(@FIFA) AS [Number of Characters]