1) Support for record and playback and ability to edit scripts after recording. Also different recording modes are provided in QTP viz.
2) Support for different addins like Java, Oracle, SAP, .NET, Web Forms, Siebel, PeopleSoft, Web services, Main frame.
3) Ability to let you enhance the existing tests even without the AUT (Application under test) through active screen.
4) QTP uses VBScript which is English-like and very easy to learn and gain expertise. We have plenty of resource available to learn VBScripts.
5) Microsoft Object model can be implanted in QTP easily. Like, Word document object, Excel Object, Outlook Object, ADO objects, File system objects.
6) It comes with loads of inbuilt properties and methods in QTP as well as inbuilt functions in VBScripts
7) Support for XML.
8) Use of Datatables/Excel files are easier and provides a variety of methods to play around with rows and columns.
9) Test reporting with all necessary details for analysis is provided.
Wednesday, 29 June 2011
When your client will concern about his db password
Hi friends,
When you get a client who is more technical ,then it accentuate on safety of his critical data. Recently I faced such type of client. When my client went through publish asp.net project on server and he found that our db password inside web.config ‘s connection string , and expressed his concern for it safety of db password. so he suggested me not to placed in web.config moreover he asked me to hardcoded that password in my asp.net code and obfuscate that dll..!!.
Labels:
Asp.net,
DotNet,
Web.config.
Tuesday, 28 June 2011
Accelerate Downloads In Chrome & IE With FileServe Manager
FileServe Manager is a free download management application which is designed to optimize your system resources and to provide you with accelerated download speed. It is much similar to the widely used Orbit downloader and supports downloading files from Windows clipboard, resumption of broken downloads, provision for managing downloads by means of adjusting speed limit, and download scheduling.
FileServe Manager can also be integrated into both Chrome and Internet Explorer, letting you download files directly from the web without having to copy and paste source URL to begin downloading process. Unlike Orbit, it automatically moves downloads into convenient categories according to file types. You will, for instance, be able access all the downloaded apps, photos, and audio files from Software, Picture, and Music categories. Other than serving as a download manager, it also has an uploading utility to instantly save and access your files to and from the cloud. If you have your download URLs stored in a text file, you can append them in its Batch download window to start downloading all the items in one go.
FileServe Manager can also be integrated into both Chrome and Internet Explorer, letting you download files directly from the web without having to copy and paste source URL to begin downloading process. Unlike Orbit, it automatically moves downloads into convenient categories according to file types. You will, for instance, be able access all the downloaded apps, photos, and audio files from Software, Picture, and Music categories. Other than serving as a download manager, it also has an uploading utility to instantly save and access your files to and from the cloud. If you have your download URLs stored in a text file, you can append them in its Batch download window to start downloading all the items in one go.
Sort C# Code Structure In Visual Studio 2010 With CodeSorter
One of the most tiring task you might have to perform over source code files everyday is code sorting. Since there aren’t any set conditions which one can instantly apply over source code file to make it look tidy and clean, users have to manually sort the code structure according to their requirements. If you’re looking for a relatively easy way to sort your C# code in Visual Studio 2010, you can try out CodeSorter to specify code sorting conditions, so that they can be applied with a single click over all the code files. The add-in only works with C# project files and may disturb code structure of other languages. The add-in has a host of different code sorting conditions which can be customized in numerous ways. It was developed to sort source code files by different conditions such as, names, types; including, class, struct, method, virtual modifiers; virtual overide, new, etc.
Create Android Apps For Your Favorite Websites In Just A Few Clicks!
Disappointed that your favorite website does not have a mobile web variant? Looking for a way to create an app for your own website without having to learn how to code? Look no further. AppYet is a web service that allows you to create, in just a few clicks, reasonably feature-rich and presentable Android RSS feed readers for websites of your choice.
Google’s Plans For Web Spam in 2011
We all get junk in our inboxes, through our letterboxes and you may or may not have noticed that you get spam in search results too. This is as a result of websites tricking the search engines so that they rank higher in results.
Google have commented on their plans for spam in 2011:
"…We’re evaluating multiple changes that should help drive spam levels even lower…
…We'll continue to explore ways to reduce spam, including new ways for users to give more explicit feedback about spammy and low-quality sites."
So fingers crossed we’ll see less spam, at least in Google!
Follow these simple tips to ensure that your website won’t be affected by Google’s changes:
Publish unique content only
Use ethical SEO techniques
Publish good quality content
If you’re at all worried about the quality of your website and how Google might view it, then contact us and we’ll help you out.
Google have commented on their plans for spam in 2011:
"…We’re evaluating multiple changes that should help drive spam levels even lower…
…We'll continue to explore ways to reduce spam, including new ways for users to give more explicit feedback about spammy and low-quality sites."
So fingers crossed we’ll see less spam, at least in Google!
Follow these simple tips to ensure that your website won’t be affected by Google’s changes:
Publish unique content only
Use ethical SEO techniques
Publish good quality content
If you’re at all worried about the quality of your website and how Google might view it, then contact us and we’ll help you out.
What Type Of Website Would Best Suit Your Business?
Today there are many different types of websites to choose from when considering updating your existing website or starting a brand new one. To help you get started here's a list of the main types:
eCommerce: you'll need this kind of website if you'd like to have a shopping cart so that visitors can purchase online. Here's an example of an e-commerce website that Matrix built: www.soul-shoes.co.उक
Bespoke: important if you'd like a totally unique site that stands out, you can specify every last detail you'd like to see on the website. Here's an example of a bespoke website that Matrix built: www.barbicantheatre.co.उक
Template: a cheaper option based on an existing template that's populated with your content, images and colours. Here's an example of a Matrix-built template website: www.eagle-smt.कॉम
Content Management System (CMS): this will allow you to take the reins and update and change your website yourself. Depending on your CMS you can create new pages, add new products, change images and text and much more! Here's an example of a website that Matrix built with CMS functionality: www.devonfurniture.co.uk
Hopefully the above will help you to understand the different types of websites you can choose for your business. If you're still none-the-wiser then give us a call and we'll be happy to help.
eCommerce: you'll need this kind of website if you'd like to have a shopping cart so that visitors can purchase online. Here's an example of an e-commerce website that Matrix built: www.soul-shoes.co.उक
Bespoke: important if you'd like a totally unique site that stands out, you can specify every last detail you'd like to see on the website. Here's an example of a bespoke website that Matrix built: www.barbicantheatre.co.उक
Template: a cheaper option based on an existing template that's populated with your content, images and colours. Here's an example of a Matrix-built template website: www.eagle-smt.कॉम
Content Management System (CMS): this will allow you to take the reins and update and change your website yourself. Depending on your CMS you can create new pages, add new products, change images and text and much more! Here's an example of a website that Matrix built with CMS functionality: www.devonfurniture.co.uk
Hopefully the above will help you to understand the different types of websites you can choose for your business. If you're still none-the-wiser then give us a call and we'll be happy to help.
Monday, 27 June 2011
Forget '.com', are you ready for '.google', or '.bank'?
Think of it as a cyberspace land rush, as companies and others try to stake claims to websites ending with names like ".bank"
Come next year, an era when site names ended in a handful of predictable ways like ".com" or ".gov" draws to a close. ICANN, which stands for the Internet Corporation for Assigned Names and Numbers, says it will accept applications for domains with new suffixes that could range from corporate names (like ".Apple" or ".Sony") to more generic terms (like ".bank" or ".supermarket").
Don't expect that all those ".com" sites will simply fade away, or that every celebrity will start a site with a name like "Lady.Gaga." Some pop stars may try to do that, but ICANN has made the process of launching a new suffix cumbersome and costly, to put some limits on the proliferation of web suffixes.
What's certain, though, is that companies and other entities will now be thinking hard about the new "your-name-here" opportunity. And on the flip side, they'll be pondering the potential risks of not joining the stampede.
Web experts have said that ICANN’s proposals, to essentially open up a new online market-place, where new addresses are available for those brands and individuals who have lost their identity online in the first and second wave of the web, could be significant.
It will cost £162,000 to apply, and individuals or organizations will be asked to show a legitimate claim to the name they are buying.
Credit: Material from the Telegraph and Wire Services were used in this article.
Come next year, an era when site names ended in a handful of predictable ways like ".com" or ".gov" draws to a close. ICANN, which stands for the Internet Corporation for Assigned Names and Numbers, says it will accept applications for domains with new suffixes that could range from corporate names (like ".Apple" or ".Sony") to more generic terms (like ".bank" or ".supermarket").
Don't expect that all those ".com" sites will simply fade away, or that every celebrity will start a site with a name like "Lady.Gaga." Some pop stars may try to do that, but ICANN has made the process of launching a new suffix cumbersome and costly, to put some limits on the proliferation of web suffixes.
What's certain, though, is that companies and other entities will now be thinking hard about the new "your-name-here" opportunity. And on the flip side, they'll be pondering the potential risks of not joining the stampede.
Web experts have said that ICANN’s proposals, to essentially open up a new online market-place, where new addresses are available for those brands and individuals who have lost their identity online in the first and second wave of the web, could be significant.
It will cost £162,000 to apply, and individuals or organizations will be asked to show a legitimate claim to the name they are buying.
Credit: Material from the Telegraph and Wire Services were used in this article.
What is Graphic Design?
Suppose you want to announce or sell something, amuse or persuade someone, explain a complicated system or demonstrate a process. In other words, you have a message you want to communicate. How do you “send” it? You could tell people one by one or broadcast by radio or loudspeaker. That's verbal communication. But if you use any visual medium at all-if you make a poster; type a letter; create a business logo, a magazine ad, or an album cover; even make a computer printout-you are using a form of visual communication called graphic design.
Graphic designers work with drawn, painted, photographed, or computer-generated images (pictures), but they also design the letterforms that make up various typefaces found in movie credits and TV ads; in books, magazines, and menus; and even on computer screens. Designers create, choose, and organize these elements-typography, images, and the so-called “white space” around them-to communicate a message. Graphic design is a part of your daily life. From humble things like gum wrappers to huge things like billboards to the T-shirt you're wearing, graphic design informs, persuades, organizes, stimulates, locates, identifies, attracts attention and provides pleasure.
Graphic design is a creative process that combines art and technology to communicate ideas. The designer works with a variety of communication tools in order to convey a message from a client to a particular audience. The main tools are image and typography.
Graphic designers work with drawn, painted, photographed, or computer-generated images (pictures), but they also design the letterforms that make up various typefaces found in movie credits and TV ads; in books, magazines, and menus; and even on computer screens. Designers create, choose, and organize these elements-typography, images, and the so-called “white space” around them-to communicate a message. Graphic design is a part of your daily life. From humble things like gum wrappers to huge things like billboards to the T-shirt you're wearing, graphic design informs, persuades, organizes, stimulates, locates, identifies, attracts attention and provides pleasure.
Graphic design is a creative process that combines art and technology to communicate ideas. The designer works with a variety of communication tools in order to convey a message from a client to a particular audience. The main tools are image and typography.
Basics to start an e-Commerce website
1. Web Hosting Service – A hosting server gives your website a place to reside on the Internet; without a hosting service, visitors cannot access your website. Most hosting services are available for a nominal monthly fee. Make sure the hosting service is compatible with your shopping cart software.
2. Website – Once you have place for your website online, next is the website itself. There are a myriad of available options when it comes to creating your website. If you already have an existing website, you can integrate e-commerce capabilities. If you are building the website from scratch, there are a handful of software programs that can help you build a website with no HTML skills or you can have your site designed by a website design professional or firm (typically the most expensive alternative).
Labels:
ecommerce,
online shop,
payment,
shopping
Saturday, 25 June 2011
Customized Android ROM Build
Dear Friends,
Android is booming in mobile market now days. And you will find varieties of mobile device with android OS. Moreover it is open source OS, so one can customize this Android OS for targeting any OEM’s device. By customizing the Android, one can add or subtract some features to OS which may not be provided or disable by OEM of that particular mobile device.
Labels:
Android,
Custom ROM Build
Friday, 24 June 2011
A Complete URL Rewriting Solution for ASP.NET 2.0
This article uses regular expressions to specify rewriting rules and resolves possible difficulties with postback from pages accessed via virtual URLs.
Why use URL rewriting?
The two main reasons to incorporate URL rewriting capabilities into your ASP.NET applications are usability and maintainability.Apple Vs. Microsoft The History Of Computing (Infographic)
Inforgraphic are the the best learning concepts in modern Internet world.
Look out for infographics for learning.
I am sharing wonderful infographic of two Software Giants history and present.
Look out for infographics for learning.
I am sharing wonderful infographic of two Software Giants history and present.
Image By Manolution – The Blog for Men
Thursday, 23 June 2011
Neowin - Nokia Window Phone 7.1 (Mango)
Nokia CEO Stephen Elop have unveiled the Nokia’s first Windows Phone device during an internal company meeting earlier this week.
According to Neowin “Elop mentions that the device is “super confidential” and that the company doesn’t want to see it out in the blogosphere. “Beautiful design, gorilla glass, pillow shaped backing, carl ziess 8MP camera,” says Elop.
The product is Nokia’s first Windows Phone device and will be available later this year when the company releases a batch of Windows Phone Mango devices.”
SQL Server CE
Topics
- What's New in SQL Server Compact Edition
- Feature Improvements to Enhance Reliability and Performance
- Synchronization
- Storage Engine
- Query Processor
- Integration with SQL Server 2005
- Integration with Microsoft Visual Studio 2005
- Advantage of SQL SERVER CE
- Disadvantage of SQL SERVER CE
- Connection strings for SQL Server Compact Edition
- Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition
Labels:
Compact Edition,
Database,
Sql Server,
Sql Server CE
XLSExport: A CLR procedure to export proc results to Excel
Introduction
NPOI is a .NET project which can read and write read/write xls, doc, and ppt files without the need for a Microsoft Office installation or license. Formerly on CodePlex, the project is now located on Googlecode at http://code.google.com/p/npoi/.In this CLR example, I'll use NPOI to create a procedure that takes a stored procedure name and list of parameters and parameter values for that procedure, and outputs an Excel spreadsheet that contains the execution results of that proc to the passed .XLS file specification. The advantage to a CLR solution is that (in addition to lacking an MS Office install or license requirement) ActiveX and COM components are not required on your otherwise pristine SQL Server to accomplish this task.
This procedure supports output data types of CHAR, NCHAR, VARCHAR, NVARCHAR, all numerics, DATE, TIME, DATETIME, DATETIME2, BIT, and BOOLEAN. Other datatype outputs are not currently supported, but are
Process Of Web Development Project
Every designer or company will develop unique components to their web design process over time, but the basics remain the same: learn, plan, design, code and launch...
Labels:
cretive brief,
process of project,
web design,
wireframe
How does Offshore Outsourcing Model work for the software development?
Last week I have received this inquisitive question from one of my team members. So I thought of sharing my personal experience as of now how our team works in Hi-Tech ITO.
- We have marketing team who gets prospect list, client meeting, web research etc.
- Pre-sale team works on chunk lists like from SEO, direct calling, existing client list which can be the prospects for the software development, IT trade fair like CeBIT, reference from the existing client, bidding portal, consultant companies and social media etc.
- This team gets the broad level requirement specification in form of email or document.
- While this is in process, they provide information about Hi-Tech and the various services it currently offers and details about our development expertise etc. are shared with the prospect.
- Inquiry gets allocated to respective project manager or Business Analyst depending upon their availability for performing the impact analysis and finalizing effort estimates
- We sign strict NDA to give them assurance about the privacy of the project information
GameSalad unleashes HTML5 game creator — no coding required
The company sells a suite of tools that let game developers create games with a drag-and-drop user interface. It makes it easy for users to develop their own games even if they don’t know any programming languages. It removes the barrier to entry for developing games for the iPhone, Android-powered mobile devices and now web browsers. HTML5 also works on most mobile browsers, eliminating the need to create a specific app for each mobile operating system.
Extention method for IComparable
Hi friends,
C# 3.0 gives great feature of extension method. so i keep playing with this. today I would like to show you something interesting way to use that extension method. This time it's extending IComparable<T>. The API signature for IComparable<T> has been around since the birth of C language . If the left is less than the right, return something less than 0, if left is greater than right, return something greater than 0, and if they are equivalent, return 0. Well, its readability leaves a bit to be desired.
Labels:
C#,
DotNet,
Extension method for IComparable
Wednesday, 22 June 2011
Motivating QA Team
Job satisfaction among QA professionals has been traditionally low when compared with their development peers and with those in other departments. Why? External misconceptions that are out there such as “anybody can do QA”, “hire some out of school kids to test our applications”, or “QA folks are in reality ‘developer wannabees’, can really have an impact on your team’s morale.
We will take a closer look at some common QA miss-perceptions, reason why they are wrong, and gives you some specific follow-up action items that you could act upon to keep and maintain a motivated staff.
Myth #1: Anybody can do QA
Wrong. Testing is a skilled activity that requires the ability to think, explore and follow logic while questioning and reasoning at the same time. It is based on the philosophy of performing a technical investigation of a product, to provide information and report back to various stakeholders throughout the organization. And to achieve
Tuesday, 21 June 2011
Windows Phone 7.5 Mango hands-on preview
Last week Microsoft presented me with a Samsung Focus smartphone that was running a recent pre-release build of Windows Phone "Mango." Mango is the version of the OS that will replace Windows Phone 7, which launched last year.
Microsoft will release its first major update for Windows Phone, bringing more than 500 new features to the OS. Known up till now as Mango, the update will formally go by the name of Windows Phone 7.5 and focuses on improving three key areas: Communications, apps, and Internet.
I found some great features windows 7.5 (Mango) which are listed as per bellow.
Labels:
Bing,
CSS3,
HTML 5,
IE 9,
Mango,
Microsft Phone 7.1,
Mobile,
Mobile Technlogy,
Multi Tasking,
Multi Threading,
News,
Technology,
Voice-to-text
Are you a Novice Tester ???
To begin any career in any field brings a list of questions in your mind to become an expert in that. Novice testers have many questions about software testing and the actual work that they are going to perform. Certain tips can help in that to get the answers. These ‘testing truths’ are applicable to and helpful for experienced testing professionals as well.
Know Your Application
Don’t start testing without understanding the requirements. If you test without knowledge of the requirements, you will not be able to determine if a program is functioning as designed and you will not be able to tell if required functionality is missing. Clear knowledge of requirements, before starting testing, is a must for any tester.
Know Your Application
Don’t start testing without understanding the requirements. If you test without knowledge of the requirements, you will not be able to determine if a program is functioning as designed and you will not be able to tell if required functionality is missing. Clear knowledge of requirements, before starting testing, is a must for any tester.
Scheduling a SQL Server PowerShell script using the Task Scheduler
Problem
Even if your SQL Server edition does not include the SQL Server Agent service (if you use SQL Express, for instance), you can still automate administration tasks without using any 3rd party products. In this tip I'll describe how to schedule a PowerShell script with the Task Scheduler MMC snap-in. This applies to Windows 2008 Server, Windows 2008 Server R2 and Windows 7.Solution
Following is the step by step process to setup Task Scheduler to run a PowerShell script. In this example I show how you can backup a database, but this can be applied to any SQL Server task you want to automate and have scheduled on a regular basis.1. There are several ways to start the Task Scheduler, such as:
- Go to Start ---> Control Panel ---> Administrative Tools ---> Task Scheduler
- Go to Start ---> Run ---> Taskschd.msc
- Go to the Configuration Node of the Server Manager (Windows Server 2008, 2008 R2) or to Computer Manager ---> System Tools (Windows 7 Pro) and click on Task Scheduler
Labels:
Database,
Database Administrator,
Powershell,
Powershell script,
Sql script,
Sql Server,
Task Scheduler
SaaS, Web, Cloud and Mobile enablement of your C/S .NET (Windows Forms) application, is the most cost-effective decision you can make
Visual WebGui is the only technology that can do it. From desktop .NET (C#, VB.NET) into latest .NET based cross-platform HTML5 rich user-interface @ the shortest time to market and the lowest costs and risks.
VWG tool-based code migration tools are currently offered as a service; as a turn-key, or on a work sharing basis with the customers. It includes POC, prototyping, consulting, and "hand holding" support and professional services. The tools will be released in Q2 2011.
Visual WebGui is the only technology that can do it. From desktop .NET (C#, VB.NET) into latest .NET based cross-platform HTML5 rich user-interface @ the shortest time to market and the lowest costs and risks.
VWG tool-based code migration tools are currently offered as a service; as a turn-key, or on a work sharing basis with the customers. It includes POC, prototyping, consulting, and "hand holding" support and professional services. The tools will be released in Q2 2011.
Metrics in Software Testing
Metrics for Evaluating Application System Testing:
Metric = Formula
Test overage = Number of units (KLOC/FP) tested / total size of the system. (LOC represents Lines of Code)
Number of tests per unit size = Number of test cases per KLOC/FP (LOC represents Lines of Code).
Acceptance criteria tested = Acceptance criteria tested / total acceptance criteria
Defects per size = Defects detected / system size
Test cost (in %) = Cost of testing / total cost *100
Cost to locate defect = Cost of testing / the number of defects located
Software Testing Standards - CMM
Capability Maturity model
- It is a five level assessment model
- Capability Maturity Model (CMM) broadly refers to a process improvement approach that is based on a process model. CMM also refers specifically to the first such model, developed by the Software Engineering Institute (SEI) in the mid-1980s, as well as the family of process models that followed.
Nokia N9 - Design, Social and Interaction
Hello Guys,
Nokia today announced N9, their new invention to compete with Smart Phone majors.
You can find more details on Nokia N9 - http://swipe.nokia.com/
I classify the device in to three major things , which are done beatifically in new Device.
how to make common control event for all child control of container
Hi friends
so time in my winform base project, I get scenario where one to assign a click event handler to all child/dynamic Controls contained in a User Control. This is a good method but I found there was no proper docs for this.
so time in my winform base project, I get scenario where one to assign a click event handler to all child/dynamic Controls contained in a User Control. This is a good method but I found there was no proper docs for this.
Labels:
DotNet
Monday, 20 June 2011
Basic Object-Oriented Concepts
- How People Understand Technology
- How People Approach Object-Oriented Technology
- Object-Oriented Terms and Concepts
- Objects
- Classes, Metaclasses, Parameterized Classes, and Exemplars
- Black Boxes and Interfaces
- Aggregation
- Specialization and Inheritance
- Abstract Classes
- Operations
- Constants
- Exceptions
- Object Coupling and Object Cohesion
- Systems of Objects
Prepare Android Development Enviroment
Hi friends,
Google Android is booming platform on mobile and table device..,so, many armature or beginner programmer need to know that how to setup a android development enviroment(ADE) for that.
Best part of Android is that, one can setup ADE on any platform like Window, Mac or Linux or Unix. For ADE following chain toolkit are required
Labels:
Android
.NET coding standard part - 1
Hello friends, in coding practice there are some coding standards that we should follow to make code more readable and maintainable. I have compiled some coding standards that I have mentioned following.
Naming Conventions and Style
1. Use Pascal casing for type and method names and constants:
public class SomeClass
{
const int DefaultSize = 100;
public void SomeMethod()
{}
}
Naming Conventions and Style
1. Use Pascal casing for type and method names and constants:
public class SomeClass
{
const int DefaultSize = 100;
public void SomeMethod()
{}
}
Server Side Pagination
The paging of a large database resultset in Web applications is a well known problem. In short, you don't want all the results from your query to be displayed on a single Web page, so some sort of paged display is more appropriate. While it was not an easy task in the old ASP, the DataGrid control in the ASP.NET simplifies this to a few lines of code. So, the paging is easy in ASP.NET, but the default behavior of the DataGrid is that all resulting records from your query will be fetched from SQL server to the ASP.NET application. If your query returns a million records this will cause some serious performance issues (if you need convincing, try executing such a query in your web application and see the memory consumption of the aspnet_wp.exe in the task manager). That's why a custom paging solution is required where desired behavior is to fetch only the rows from the current page.
Code
Here I provide some query which provide solution for custom pagination. It helps to improve your search result for your filter data.
Code
One small step for an Employee, a giant leap for an Organization
Hello guys,
My first blogpost on Hi-Tech ITO blog, reminds me one of most famous line of last millenium.
"One small step for a man, a giant leap for mankind"
Yeah, for a company which focuses on Outsourcing Solutions, for them giving employees their own personal space via blog is really rare.
Hi-Tech Outsourcing again took wonderful step for their employees, now a team of excellent technical expertise post their routine problems which are likely faced by many others.
It is also an opportunity to groom employees writing skills and interpersonal skills.
As Operator in C#
The as operator is used to perform certain types of conversions between compatible reference types. "As" Operator is also known as a safe cast. What is does is it attempts to cast from one type to another and if the cast fails it returns null instead of throwing an InvalidCastException.
As-casting is equivalent to the following expression except that expression is evaluated only one time.
expression is type ? (type)expression : (type)null
Labels:
As Casting,
As Operator,
C#,
Casting,
DotNet,
InvalidCastException,
Null,
Operator,
Prefix-casting
NULLIF (Transact-SQL)
Yesterday I found one more function of sql server. NULLIF which returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression. NULLIF function is available from Sql Server 2005.
Syntax :
NULLIF ( expression , expression )
Example :
The following example creates a budgets table to show a department (dept) its current budget (current_year) and its previous budget (previous_year). For the current year, NULL is used for departments with budgets that have not changed from the previous year, and 0
is used for budgets that have not yet been determined. To find out the
average of only those departments that receive a budget and to include
the budget value from the previous year (use the previous_year value, where the current_year is NULL), combine the NULLIF and COALESCE functions.
ISNULLIF Example |
Migrating From MySQL to SQL Server running PHP on IIS
In the following code, we connect to the MySQL server with mysql_connect() and then select the database with mysql_select_db() that we will work against.
MySQL PHP
MySQL Actor Table Viewer
$db_host = 'localhost';
$db_user = 'root';
$db_pwd = 'pass@word1';
$database = 'sakila';
$table = 'actor';
if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");
if (!mysql_select_db($database))
die("Can't select database");SQL Server PHP
With SQL Server PHP, the database context is established in one call to sqlsrv_connect() that returns a connection handle for running a queries.
SQL Server Actor Table Viewer
$db_host = '.\SQLEXPRESS';
$db_user = 'sa'; //recommend using a lower privileged user
$db_pwd = 'pass@word1';
$database = 'sakila';
$table = 'actor';
$connectionInfo = array("UID" => $db_user, "PWD" => $db_pwd, "Database"=>$database);
$conn = sqlsrv_connect( $db_host, $connectionInfo);
if( !$conn )
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
ASP.NET 4.0 Active MarkUp v/s Passive Markup
ASP.NET 4.0 gives us two main flavor of programming style. Active Markup and Passive Markup.
ohh..!! what is this new terminology Active Markup and Passive Mark Markup.. ?!!!. This term you never find on msdn or any Microsoft Evangelist's blog or book. this is new term coin by me for ASP.NET webform and ASP.NET MVC..
Subscribe to:
Posts (Atom)