Profile

Cover photo
Jacob Sebastian
Works at Excellence Infonet
682 followers|20,265 views
AboutPostsPhotosVideos

Stream

Jacob Sebastian

Shared publicly  - 
 
I have been helping a few people to migrate their blogs from blogger.com to beyondrelational.com. As part of this, I had to deal with the XML export file generated by blogger.com which contains infor...
1
Add a comment...

Jacob Sebastian

Shared publicly  - 
 
If you are a programmer working with SQL Server, you must have found it little embarrassing to display information which spans across multiple pages (web pages). SQL Server 2000 did not allow you to r...
1
Add a comment...

Jacob Sebastian

Shared publicly  - 
 
I just learned that Active Directory Helper Service is discontinued in SQL Server 2012.
1
Add a comment...
Have him in circles
682 people
Govind Sharma's profile photo
John Spanos's profile photo
Jorge Segarra's profile photo
TEJAS SHAH's profile photo
‫مناف الحجامي‬‎'s profile photo
Adam Haines's profile photo
Mini Rajesh's profile photo
darshan shah's profile photo
Josh Robinson's profile photo

Jacob Sebastian

Shared publicly  - 
 
Hi, Just now i Wrote one query to remove special characters from a string.. Hope this is useful. DECLARE @I VARCHAR(100) SELECT @I ='abhi *s d ^.l' WHILE PATINDEX('%[^A...
1
Add a comment...

Jacob Sebastian

Shared publicly  - 
 
I wrote this query a few months back to help some one in the XML forums. Here is the sample XML data for this lab. Names> Name>Jacob <span style="color: #00...
1
Add a comment...

Jacob Sebastian

Shared publicly  - 
 
The IN clause in T-SQL can be used to find a single value present in any one of multiple supplied columns. For example, in the AdventureWorks database: [code] SELECT Title, FirstName, MiddleName, ...
1
Add a comment...

Jacob Sebastian

Shared publicly  - 
 
@@ROWCOUNT returns the number of affected rows by last statement. Below example illustrate the same CREATE TABLE #t (id int) INSERT INTO #t(id) values(1) DELETE #t SELECT @@ROWCOUN...
1
Add a comment...
People
Have him in circles
682 people
Govind Sharma's profile photo
John Spanos's profile photo
Jorge Segarra's profile photo
TEJAS SHAH's profile photo
‫مناف الحجامي‬‎'s profile photo
Adam Haines's profile photo
Mini Rajesh's profile photo
darshan shah's profile photo
Josh Robinson's profile photo
Work
Occupation
CTO at Excellence Infonet
Employment
  • Excellence Infonet
    CTO, present
Links
Contributor to
Story
Introduction
Jacob Sebastian is a SQL Server MVP, Author Speaker and Blogger.
Basic Information
Gender
Male
Apps with Google+ Sign-in