Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
SQL Server 119
#SQLServer 88
Oracle 70
#SQL SERVER 35
BRH 31
SQL Server 2012 29
denali 23
#TSQL 19
TSQL 19
C# 15

Archive · View All
October 2011 31
November 2011 30
September 2011 30
August 2011 18
December 2011 15
July 2011 13
June 2011 8
May 2012 4
April 2012 3
January 2010 3

New expression language functions(Left, Token, TokenCount) in SSIS Denali (SQL Server 2012) CTP 3

Aug 27 2011 12:31AM by Niladri Biswas   

New expression language functions(Left, Token, TokenCount) in SSIS Denali (SQL Server 2012) CTP 3

In Denali (SQL Server 2012) CTP 3, we have three new functions in the expression language viz. Left , Token and TokenCount so far SSIS is concern

Let us analyze these functions one by one

Left: Returns the left part of a character string with the specified number of characters.This function is already there in TSql for a long time. Also it's counter part Right was already available in SSIS for a long time.

So if we run the below code in the Expression Task, we will get the following output

	@[User::Result1] =  LEFT("Test for Left function", 4)
    //output: Test

The left function in this case strips out the first 4 character from the supplied string

Token: Returns the specified occurrence of a token in a string

So if we run the below code in the Expression Task, we will get the following output

	@[User::Result1] =  TOKEN("Test for Token Function"," ",2)
	//output: for

Because for appeared in the second place

TokenCount: Returns the number of tokens in a string

So if we run the below code in the Expression Task, we will get the following output

	@[User::Result2] =  TOKENCOUNT("Test for TokenCount function"," ")
	//output : 4

Because there are 4 tokens

We can even combine Token and TokenCount as under

	@[User::Result1] =  TOKEN("Test for Token Function"," ",  TOKENCOUNT("Test for TokenCount function"," "))
	//output : Function

Because, TokenCount function yields 4 and in the fourth place , we have "Function"

References

Left

Token

Token Count

Tags: #SQLServer, SQL Server, ssis, Denali CTP3, SQL Server 2012,


Niladri Biswas
7 · 21% · 6710
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]