Misplaced Pages

Revision as of 13:24, 4 June 2013

Split(s) or The Split may refer to:

Places

• Split, Croatia, the largest coastal city in Croatia
• Split Island, an island in Hudson Bay, Canada
• Split Island, Falkland Islands
• Hạf’liua or Split Island, an island in the Rotuma Group of Fiji

Music

• Split album, an album by two or more artists
• "Split" (song), a 1991 song by KMFDM
• Split (The Huntingtons and Darlington album), 2000
• Split (Lush album), 1994
• Split (Zeke/Peter Pan Speedrock album), 2005
• The Split CD, a 1998 EP by Queens of the Stone Age and Beaver
• Split, an album by Patricia Barber
• Split (The Groundhogs album), 1971

Games

• Split (poker), the division of winnings in the card game
• Split (bowling)
• Split, a possible player decision in blackjack
• Split Dynasty, an alien species of the X game series

<div

Sports

• Split (gymnastics), a body position
• Split leap or jumping, a class of dance leaps
• Split jump, a type of jump in figure skating
• Split decision, combat sports term when a fight is scored non-unanimously for one fighter by all judges

Science

• Split (mathematics), a property of an exact sequence
• Split (phylogenetics), a bipartition of a set of taxa in phylogenetics

Film and television

• The Split (1959 film) or The Manster, a U.S.-Japanese horror film
• The Split, a 1968 heist film
• Split (film), a 1989 science fiction film
• Split (TV series), an Israeli TV series
• Splits Magazine, a fictional magazine in the Glee episode Home
• "Split", the first episode of series three Coupling
• Split: A Divided America

Other uses

• Split (Unix), a Unix software utility for dividing input into multiple files
• Split, a wine bottle size
• Split, a type of air conditioning system consisting of both indoor and outdoor units
• Yugoslav destroyer Split, Yugoslav Navy ship

See also

• Australian Labor Party split of 1955, commonly known in Australian politics as "The Split"
• Split personality, a mental disorder also known as Dissociative Identity Disorder
• Stock split, a corporation dividing or consolidating its shares
• Banana split, a dessert
• Phonemic split, an evolutionary change of a language in which one phoneme evolves into two discrete phonemes
• Netsplit, IRC term for disconnection of a given node
• Split screen (filmmaking), a visual technique in film and television
• Split screen (computer graphics)
• Zygosity, a genetic split
• Division (disambiguation)
• Segmentation (disambiguation)
• Separation (disambiguation)
• Splitter (disambiguation)
• All pages with titles beginning with Split

/****** Object: UserDefinedFunction . Script Date: 6/3/2013 2:37:57 PM ******/ DROP FUNCTION . GO

/****** Object: UserDefinedFunction . Script Date: 6/3/2013 2:37:57 PM ******/ SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO

CREATE FUNCTION . (

   @SourceString sql_variant,
   @Delimiter nvarchar(10) = N','

) RETURNS @Values TABLE( Position smallint IDENTITY, cValue varchar( 8000 ) , ncValue nvarchar( 4000 ) ) AS BEGIN IF(ISNULL(@SourceString,)<>) BEGIN

   DECLARE @NormalString    varchar( 8000 ) , @NationalString    nvarchar( 4000 ) ,
           @NormalDelimiter varchar( 10 )   , @NationalDelimiter nvarchar( 10 )   ,
           @IsNationalChar  bit             , @Position          int              ,
           @NormalValue     varchar( 8000 ) , @NationalValue     nvarchar( 4000 )
   SET @Delimiter      = COALESCE( @Delimiter, N',' )
   SET @IsNationalChar = CASE
                           WHEN SQL_VARIANT_PROPERTY( @SourceString , 'BaseType' ) IN ( 'char' , 'varchar' )
                           THEN 0
                           WHEN SQL_VARIANT_PROPERTY( @SourceString , 'BaseType' ) IN ( 'nchar' , 'nvarchar' )
                           THEN 1
                         END
   IF @IsNationalChar IS NULL RETURN
   IF @IsNationalChar = 0
   BEGIN
           SET @NormalDelimiter = @Delimiter
           SET @NormalString    = CAST( @SourceString AS varchar(8000) )

           IF LEFT( @NormalString , LEN( @NormalDelimiter ) ) = @NormalDelimiter
                   SET @NormalString = SUBSTRING( @NormalString, LEN( @NormalDelimiter ) + 1, 8000 )
           IF RIGHT( @NormalString , LEN( @NormalDelimiter ) ) <> @NormalDelimiter
                   SET @NormalString = @NormalString + @NormalDelimiter
           WHILE( 1 = 1 )
           BEGIN
                   SET @Position     = CHARINDEX( @NormalDelimiter , @NormalString ) - 1
                   IF @Position <= 0 BREAK
                   SET @NormalValue  = LEFT( @NormalString , @Position )
                   SET @NormalString = STUFF( @NormalString , 1 , @Position + LEN( @NormalDelimiter ),  )
                   INSERT INTO @Values ( cValue ) VALUES( @NormalValue )
           END
   END
   ELSE IF @IsNationalChar = 1
   BEGIN
           SET @NationalDelimiter = @Delimiter
           SET @NationalString    = CAST( @SourceString AS varchar(8000) )

           IF LEFT( @NationalString , LEN( @NationalDelimiter ) ) = @NationalDelimiter
                   SET @NationalString = SUBSTRING( @NationalString, LEN( @NationalDelimiter ) + 1, 4000 )
           IF RIGHT( @NationalString , LEN( @NationalDelimiter ) ) <> @NationalDelimiter
                   SET @NationalString = @NationalString + @NationalDelimiter
           WHILE( 1 = 1 )
           BEGIN
                   SET @Position     = CHARINDEX( @NationalDelimiter , @NationalString ) - 1
                   IF @Position <= 0 BREAK
                   SET @NationalValue  = LEFT( @NationalString , @Position )
                   SET @NationalString = STUFF( @NationalString , 1 , @Position + LEN( @NationalDelimiter ),  )
                   INSERT INTO @Values ( ncValue ) VALUES( @NationalValue )
           END
   END
   END
   RETURN

END

GO

• Disambiguation pages