fb like button code

Axis Technical Group Hiring in Pune

Axis Technical Group (I) Pvt. Limited is looking for .Net Developer

Job Profile: Candidate should be BE/ B.Tech/ BCA/ MCA with Minimum 1+ years of experience in Software Development for Microsoft .NET Framework, Specifically with C#, ASP .NET, Windows Forms, SQL Server & XML.

Experience in Sharepoint, Biztalk, WPF, NUnit & UML would be a plus. Good understanding of s/w development process & the best practices in technology as well as software development.

Good problem solving and analytical skills.
Excellent written and oral communication skills.
Domain knowledge of Financial Services, Mortgage would be a plus.

Specialization:  IT-Software, Oracle/Sybase/SQL/DB2, .Net Technologies

Experience: 1 - 3 yrs

Location: Pune

Qualification: BCA/BCS, B.E./B.Tech, M.Sc, M.Tech, MCA/PGDCA, MCM/MCS

Key Skills: C#, ASP .NET, Windows Forms, SQL Server & XML

Company Profile: Axis provides structure and clarity based on decades of experience. Knowing that that one size doesn’t fit all, we create solutions that meet your unique project requirements. We have a 12-year track record of delivering where others have not. And a genuine desire to build your business, with our own technology products or by developing a custom solution.

Address: Axis Technical Group India Pvt. Limited, Yashashree S. No. 19/2, 14 Sunita Society Erandwane, Pune 411004

Email Address: jobs@axistechnical.com

Contact Number: +91 20 66203079

Posting Date: 6/30/2014


Search Indxes on Table

This article gives information about Indexes in Database

sp_helpindex :
          It gives information about the indexes on a table or view.

         EXEC sp_helpindex 'Dbo.Table_Name'    

    EXEC sp_helpindex 'Dbo.Employee_Info'

Result Set displays





  If we create table without primary key then


ASCII Characters in Database

  • American Standard Code for Information Interchange.
  • Computer can understand only numbers.
  • ASCII is the numeric representation of a character.
SELECT CHAR(Expression)
              A string function that converts an int ASCII code to a character.
Return type is CHAR.
     Expression is integer value i.e. range from 0 to 255


SELECT CHAR(97) AS [ASCII Character of Number 97]
SELECT ASCII('a')  AS [ASCII Number of  Character a]

SELECT CHAR(65) AS [ASCII Character of Number 67]
SELECT ASCII('A') AS [ASCII Number of  Character A]

ASCII Values:
1) Characters Set 0-31
        First 32 Characters in the ASCII table are unprintable.
2) Characters Set 32-127
        Characters from 32-127 are common for all which represent letters, digits, punctuation marks & miscellaneous symbols.
3) Character Set 128-255
         Characters from 128-255 contains the Microsoft Latin-1 extended characters.

--Example to display All Number & ASCII characters
;WITH AllNumbers AS
SELECT 0 AS First_No
            UNION ALL
            SELECT First_No+1
            FROM AllNumbers
            WHERE First_No<255
SELECT First_No as [Numbers],
               CHAR(First_No) as [ASCII Value]
FROM AllNumbers
              OPTION (MAXRECURSION 255)

Syntax in Oracle
           CHR(expression [using NCHAR_CS])
Syntax in IBM DB2, Sybase


Impact India Hiring 75 candidates on this June, July 2014

Impact India Hiring BE/B.Tech Freshers in Multiple Locations – June 2014, July 2014. Here are the complete details of this job notification.
Company : Impact India
Position : Software Developer
Job Location : Bengaluru/Bangalore, Mumbai, Chennai, Pune, Hyderabad / Secunderabad, Delhi, Delhi/NCR(National Capital Region), Noida, Navi Mumbai Latest Fresher Jobs
Last Date : Apply Soon
Salary Offered : INR 15,00,000 – 25,00,000 P.A
Experience Required : 0 to 3 yrs
Eligibility :
  • BE/BTech/ME/MTech (CS/IT) / MCA
  • Good academics
Desired Skills :

Programming with SharePoint 2007, 2010, SQL Server 2008, ASP.Net(C#), Windows Forms, Web Concepts, JQuery, ADO.NET// Creating and managing Sharepoint and K2 Workflows
Click To Apply :