valinath.com

anildesaisql-helper.blogspot.com

PL/SQL Tips for Sql Server: February 2008

http://anildesaisql-helper.blogspot.com/2008_02_01_archive.html

PL/SQL Tips for Sql Server. જય વાળીનાથ. T-SQL is a basic of structure query language. So I always want to learn T-SQL in different way to get best performance in query. And its my passion. View my complete profile. Friday, February 15, 2008. Here first of all assign Full text search on ur database by select database than select property by right click than select File options exist in left side and than select check box for Use full text indexing. This four function give proper result by Full text search.

anildesaisql-helper.blogspot.com

PL/SQL Tips for Sql Server: April 2008

http://anildesaisql-helper.blogspot.com/2008_04_01_archive.html

PL/SQL Tips for Sql Server. જય વાળીનાથ. T-SQL is a basic of structure query language. So I always want to learn T-SQL in different way to get best performance in query. And its my passion. View my complete profile. Wednesday, April 30, 2008. How Many Sunday In Give Month and Year Script in T-SQL. Here this script calculate total Sunday in give month and give year @month = 6 and @year = 2008. Set @isLeapYear = 'false'. Here change year and month for diff result. Set @year = 2008. Set @month = 6. Set @i = 1.

anildesaisql-helper.blogspot.com

PL/SQL Tips for Sql Server: Use of With...As clause Script in T-SQL

http://anildesaisql-helper.blogspot.com/2008/07/use-of-withas-clause-script-in-t-sql.html

PL/SQL Tips for Sql Server. જય વાળીનાથ. T-SQL is a basic of structure query language. So I always want to learn T-SQL in different way to get best performance in query. And its my passion. View my complete profile. Saturday, July 12, 2008. Use of With.As clause Script in T-SQL. First create one table for employee. Object:  Table [dbo].[employee]    Script Date: 07/12/2008 14:03:43 * * * /. SET ANSI NULLS ON. SET QUOTED IDENTIFIER ON. SET ANSI PADDING ON. CREATE TABLE [dbo].[employee](. Select empid,empna...

govaliyo.wordpress.com

જઈ શું તો ક્યાં જઈશું…ધરા ગુજઁરીને ખોળેથી. | ગોવાળીયો

https://govaliyo.wordpress.com/2007/01/10/જઈ-શું-તો-ક્યાં-જઈશુંધરા-ગ

મ લધ ર ઓન સપન ઓ અન સમસ ય ઓ. શ વ સ શ વ સમ ભર શ ક મ ર ધ ન શ ય મ? વ સળ મ વહ ત મ ”લ! January 10, 2007. જઈ શ ત ક ય જઈશ …ધર ગ જ ર ન ખ ળ થ . Posted by govaliyo under મ લધ ર ન સમસ ય ઓ. Cow-slaughter the Gujarat way! Much is being said by Hindutva votaries of cow-protection on the need to ban cow slaughter all over the country and to strictly implement this ban, especially in Gujarat. S mouthpieces delightfully publish these stories. Sometimes they appear in mainstream media too. Do we have enough grassland for t...

govaliyo.wordpress.com

માલધારીઓના સપનાઓ અને સમસ્યાઓ | ગોવાળીયો

https://govaliyo.wordpress.com/માલધારીઓના-સપનાઓ-અને-સમસ

મ લધ ર ઓન સપન ઓ અન સમસ ય ઓ. શ વ સ શ વ સમ ભર શ ક મ ર ધ ન શ ય મ? વ સળ મ વહ ત મ ”લ! મ લધ ર ઓન સપન ઓ અન સમસ ય ઓ. આપણ વ ક સન ર ધ ત ત નથ ન? અન આ મ ટ આપણ ” લ ક જ વ ન મ નસ કત ” બદલવ પડશ? આપણ શ ક ષ ત ય વ ન પણ આ પ વ ગ રહથ પ ડ ય છ એમ હ અ ગત ર ત મ ન છ . બ મલ ઉફ બ બ રબ ર. 106 Responses to “મ લધ ર ઓન સપન ઓ અન સમસ ય ઓ”. ઊર મ સ ગર. January 8, 2007 at 2:51 pm. Different kind of post on one blog with different categories will make blog more interesting! This is just a humble suggestion! ઊર મ સ ગર. NOT only aware the commu...

anildesaisql-helper.blogspot.com

PL/SQL Tips for Sql Server: Split Function Script in T-SQL

http://anildesaisql-helper.blogspot.com/2008/07/split-function-for-string-by-delimiter.html

PL/SQL Tips for Sql Server. જય વાળીનાથ. T-SQL is a basic of structure query language. So I always want to learn T-SQL in different way to get best performance in query. And its my passion. View my complete profile. Thursday, July 24, 2008. Split Function Script in T-SQL. Set ANSI NULLS ON. Set QUOTED IDENTIFIER ON. CREATE FUNCTION [dbo].[SplitString]. RETURNS @mytbl table(val varchar(100)  . Set @strlen = len(@str). Set @i = 1. Set @tstr = '. Set @charat = substring(@str,@i,1). Set @tstr = @tstr @charat.

anildesaisql-helper.blogspot.com

PL/SQL Tips for Sql Server: Using ROW_NUMBER() to paginate your data ... Script in T-SQL

http://anildesaisql-helper.blogspot.com/2009/04/using-rownumber-to-paginate-your-data.html

PL/SQL Tips for Sql Server. જય વાળીનાથ. T-SQL is a basic of structure query language. So I always want to learn T-SQL in different way to get best performance in query. And its my passion. View my complete profile. Thursday, April 23, 2009. Using ROW NUMBER() to paginate your data . Script in T-SQL. Here making paginating functionality by Sql Server side. Here first of all set @totalPageSize, which set how many row should be display. Then set @pageIndex , which set the pageindex,. Set @totalPageSize = 10.

goodshayri.blogspot.com

Good Shayri: Wah Ustad Wah.....

http://goodshayri.blogspot.com/2009/07/wah-ustad-wah.html

Monday, July 13, 2009. Mere Jineke Liye Tera Armaan Hi Kafi Hai,. Dil Ke Kalam Se Likhi Ye Dastaan Hi Kafi Hai,. Tir-E-Talwaar Ki Tujhe Kya Zaroorat-E-Nazneen,. Qatl Karne Ke Liye Teri Muskaan hi Kafi Hai. Kajal banke teri aankho mein samane ki tamanna hai,. Dawa banke tere dard mitane ki tamanna hai,. Yun to haasil hai zamane ki har cheez mujhe,. Sirf ek baar tujhe dulhan ke roop mein paane ki tamanna hai. Sato aasman ki sair hum kar aaye,. Her ek tare se dosti kar aaye,. Ho jaye jo aap humse khafa,.

anildesaisql-helper.blogspot.com

PL/SQL Tips for Sql Server: How Many Sunday In Give Month & Year Script in T-SQL

http://anildesaisql-helper.blogspot.com/2008/04/calculate-how-many-sunday-in-give-month.html

PL/SQL Tips for Sql Server. જય વાળીનાથ. T-SQL is a basic of structure query language. So I always want to learn T-SQL in different way to get best performance in query. And its my passion. View my complete profile. Wednesday, April 30, 2008. How Many Sunday In Give Month and Year Script in T-SQL. Here this script calculate total Sunday in give month and give year @month = 6 and @year = 2008. Set @isLeapYear = 'false'. Here change year and month for diff result. Set @year = 2008. Set @month = 6. Set @i = 1.