Be Tech Savvy…
Subhash Pande
(2 comments, 11 posts)
Home page: http://www.stechnosoft.com
Yahoo Messenger: pandesubhash@yahoo.com
Jabber/GTalk: subhashpande1
Posts by Subhash Pande
Post from Anywhere to Anywhere via Ping.fm
0October 28, 2011
by Subhash Pande
in Web
Updating the status or post on social networks is now a day to day activity. We have n number of options like Twitter, facebook, Google plus, Linkedin to post and update the status. But to post something you have to update that social media / blog individually. Isn’t that be simple if you get something like, at one go you can update or post on multiple social networks. Yes! Ping.fm is the best option to do all this. Where you can post from anywhere to anywhere. I just love this site. It saves my time and does what I want.
Get Financial Fiscal year [SQL function]
0May 12, 2011
by Subhash Pande
in MS SQL Server
User defined functions are very handy in computer languages. It helps to achieve the exact output that we want. Generally these function exists for specific purposes E.g. to get the age of users or for Comma-Delimited Searches etc etc.
Today in this post we will see User defined function to get Financial Fiscal year from SQL Server.
# Copy and paste following code in SQL window and press F5.
User Defined Function to Get Count of the words from a String in MS SQL Server
2April 5, 2011
by Subhash Pande
in MS SQL Server
Today we will see a simple User Defined Function to Get Count of the words from a String in MS SQL Server. I know you all must have done this before but its gonna be a pretty interesting because we are doing it from SQL. So lets start now…
User Defined Function to Check Leap Year In MS SQL Server
1March 30, 2011
by Subhash Pande
in MS SQL Server
To find out Leap year is use to be a small assignment. Its a very popular question and I’m sure we all have done it from different different programming languages. We all have used some predefined functions to solve this. Today we will see how to write a User Defined Function for checking Leap Year but from MS SQL Server.
User Defined Function for Get Age
1March 23, 2011
by Subhash Pande
in MS SQL Server
Many times we need to write function. MS SQL Server provides the functionality to write user defined functions. We will see how user can define own function to compute the age of a individual, by passing Birth Date and Current Date:-
Here I have created a user defined function as follows…
Loading ...
