Monday, September 5, 2016

Details Of Split String in Sql :: SQL Server 2014 Version(12.0.4100.1)


1. This is single paged query to under stand split string.
  1. Declare @products varchar(200) = '1,2,3,4,5,6,7,8,9,10'
  2. -- SET @products = SUBSTRING(@products, LEN('ss' + ',') + 1, LEN(@products))
  3. --select @products
  4. Declare @individual varchar(20) = null
  5. WHILE LEN(@products) > 0
  6. BEGIN
  7. IF PATINDEX('%,%',@products) > 0
  8. BEGIN
  9. SET @individual = SUBSTRING(@products, 0, PATINDEX('%,%',@products))
  10. SELECT @individual
  11. SET @products = SUBSTRING(@products, LEN(@individual + ',') + 1,
  12. LEN(@products)-1)
  13. END
  14. ELSE
  15. BEGIN
  16. SET @individual = @products
  17. SET @products = NULL
  18. SELECT @individual
  19. END
  20. END
  21. select @products
2. Here is a Table Valued Function in sql server which will split a string according to a certain delimiter

  1. USE [Haicang]
  2. GO
  3. /****** Object:  UserDefinedFunction [dbo].[SplitString]    Script Date: 06-Sep-2016 11:42:43 AM ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. ALTER FUNCTION [dbo].[SplitString] (@inputString nVARCHAR(500), @delimiter nVARCHAR(1))
  9. RETURNS @listOfTablesArrangementIDs table (id int) 
  10. AS BEGIN
  11. /******************************************/  
  12. Declare @individual int 
  13. Declare @individualString varchar(10) 
  14.  
  15. WHILE LEN(@inputString) > 0
  16. BEGIN
  17.     IF PATINDEX('%'+@delimiter+'%', @inputString) > 0
  18.     BEGIN
  19.    set @individualString =  SUBSTRING(@inputString, 0, PATINDEX('%'+@delimiter+'%',@inputString)) 
  20.         SET @individual =CONVERT(INT, @individualString)
  21.         insert @listOfTablesArrangementIDs(id) values(@individual)
  22.         SET @inputString = SUBSTRING(@inputString, LEN(@individualString +  @delimiter) + 1,  LEN(@inputString) + 1)
  23.     END
  24.     ELSE
  25.     BEGIN
  26.         SET   @individualString = @inputString
  27. SET @individual =CONVERT(INT, @individualString)
  28.         insert @listOfTablesArrangementIDs(id) values(@individual)
  29.         SET @inputString = NULL
  30.         
  31.     END
  32. END 
  33.     RETURN  
  34. END




Monday, April 11, 2016

Essential Oracle/SQL Query


Wednesday, March 30, 2016

Wednesday, December 2, 2015

Tool For Retrieving Database Relational Schema From SQL ( ORACLE )

Monday, November 30, 2015

Oracle CASE Practice


SELECT CODE, CASE(NAME_EN) 
WHEN 'Teacher' then 'Head Teacher' 
WHEN 'Maulna' then 'Head Maulana' 
ELSE NAME_EN
END  TITLE_EGLISH
FROM IMS_SETUP_DESIGNATION_TO;

Here  NAME_EN is a column of  IMS_SETUP_DESIGNATION_TO table but it also may be a variable.

Monday, July 7, 2014

HOW TO FIND MY SITES IN SEARCH ENGINE

Assalamualaikum(Peace Drizzle On you) every one,how are you?I think well by the grace of Almighty ALLAH.

Over view: 
Now I am going to describe something very essential for web-developer or SEO freelancer.It is the managing system for finding sites in search engine such that Google,Yahoo,Bing.com,Ask.com.You may know this is one of the vital subject in modern IT age.In one word making sites SEO (Search Engine Optimized) friendly. This is a hot question for new comers in the realm of internet that how can I acquaint my sites to search engine ? How can I submit my sites to search engine such that I can see my sites in search results. 
Eg: Here for (GOOGLE):
  http://www.google.com/addurl/?continue=/addurl  

Sunday, July 6, 2014

PROS AND CONS WHILE SUBMITTING MY SITES FOR INDEXING TO SEARCH ENGINE

NOW TIME TO JUST SEARCHING YOUR SITES IN SE:
Submitting your sites in the SE offered sites given above it is all the thing you wanted to do. After waiting several minutes you can search your sites in the search engine by your domain name with or without .com,.org,.net,.gov etc.You don't need to put HTTP or WWW. any of these while searching. But the waiting time after submitting your sites depends upon the SE quality.Suppose if your sites is well documented then Google will accept your request in a very few seconds.Yahoo is slower than Google for this purpose.I have experience of this matter several times.
What well documented websites is described below.Please be patient.I think all of these articles will be very informative to you.Or you can search by pressing CTRL+F in this page.

Saturday, July 5, 2014

STEP 2: BACKLINKING OR PROCESS FOR PERMANENTLY INDEXING YOUR SITES BY SE

I have said that my request was not lasted more than three days in GOOGLE SE.Then I stared to put my sites url back link in other sites. And after that I again make application to Google.Now my sites is indexed by google permanently.I only put my back link in 5 or 6 sites.From that pages only one page's rank was higher than 0(ZERO) in Google.But all of the 6 pages were crawled by Google,Yahoo,Bing,ask.com regularly.

Friday, July 4, 2014

GET SURELY 18500+ FREE BACKLINKS IN HIGH PAGE RANKED PAGES

Great news for increasing your page rank.
Some times people seeks here and there to put a backlink with a comment. But most of them are deleted by the admin of that page.Uh..This is so daring and waste of time.Now it's a great news that you can generate backlinks totally free.The back-linked pages are regularly crawled by search engines. Just enter in the below sites and put your URL and proceeding the next process enjoy the services.
I have also take a plan to make a library of 200+ well documented sites where you can put your comment and increase your traffic and page rank.(Here is one thing that you may find more sites which make a pages with the list of free backlink generator. But you may find some of the listed sites does not work.But here all the sites given below were experienced by me and the number of baklink given are truth. )
Enjoy the service Here:
Get 2500+ backlink from ImTalk.org


                 

Add Choice