google

Newest Post

SQL Server Update statement with Joins and Where clause

| Thursday, February 27, 2014
Read more »
Update statement of MS SQL server is used to update the tuples or set of tuples in a table. Update statement can also be used with joins to update the values from one table into another table as follows.
UPDATE  Customer
SET BrandName= BrandNameMaster.Id
from Customer Inner Join BrandNameMaster on
BrandName=BrandNameMaster.Name




This will update the "BrandName" column of the "Customer" table with the values of "Id" columns from the "BrandNameMaster" table based on the Inner join condition on columns "BrandName" of "Customer" table and "Name" column of "BrandNameMaster" table.

We can also additionally use where statement with such Update statement as follows.

UPDATE  Customer
SET BrandName= BrandNameMaster.Id
from Customer Inner Join BrandNameMaster on
BrandName=BrandNameMaster.Name

where  BrandName='Nike'










 If you have used any other variations of update statement, Please post in the comments.

Thanks 

SQL Server Update statement with Joins and Where clause

Posted by : Stranger
Date :Thursday, February 27, 2014
With 0comments

Purpose of android.intent.category.DEFAULT

| Thursday, February 20, 2014
Read more »
Purpose of android.intent.category.DEFAULT

This category is mainly used for implicit intents. If your activity wishes to be started by an implicit intent it should include this category in its filter.


I think the term "default" should be understood as "default candidate". If the action on a piece of data resolves to multiple activities, then Android will present all candidates to the user and the user can select his preferred default.


Purpose of android.intent.category.DEFAULT

Posted by : Stranger
Date :Thursday, February 20, 2014
With 0comments

TextBoxMode Enumeration or TextMode attribute of TextBox

|
Read more »
The TextBoxMode enum specifies the behavior mode of the ASP.NET web control textbox. This is specified in the TextMode attribute of TextBox control.

 <asp:TextBox ID="txtPassword" runat="server" TextMode="Password"></asp:TextBox>  

"TextMode" attribute or "TextBoxMode" enum represents the different display options of the TextBox.

  • SingleLine - displays the textbox in a single row. If text exceeds the physical size of the control, it automatically adds scroll to the textbox
  • MultiLine - displays the height and length of the textbox based upon the Rows and Columns of the textbox. It allows text entry in multiple lines. Data entered in multiline textbox can be wrapped if Wrap property is set to true.
  • Password - similar to SingleLine except the all characters entered in Textbox are masked and not saved in viewstate.
There are other options also for TextMode attribute of textbox control like Email, Number, Date, DateTime etc. but they correspond to the type attribute of input element in the HTML5 hence not supported in other versions of html.

TextBoxMode Enumeration or TextMode attribute of TextBox

Posted by : Stranger
Date :
With 0comments

LPU students showcasing their automotive projects at India Expo Mart 2014, Greater Noida

| Friday, February 7, 2014
Read more »






LPU students showcasing their automotive projects at India Expo Mart 2014, Greater Noida

Posted by : Stranger
Date :Friday, February 7, 2014
With 0comments

How to use Built-in Content Filters of RadEditor to enable Absolute URLs

| Thursday, February 6, 2014
Read more »
RadEditor provides feature to upload images, documents, videos etc along with the content. The default path for uploading and viewing these attachments is the path relative to the website.

To make the path absolute for certain situations, add ContentFilters="MakeUrlsAbsolute" attribute to the RadEditor as follows.


  <telerik:RadEditor runat="server" ID="RadEditor1" SkinID="DefaultSetOfTools" Height="400px" ContentFilters="MakeUrlsAbsolute"  
         Width="100%" CssClass="addeditor">  
         <Content>  
         </Content>  
         <ImageManager ViewPaths="~/Upload" UploadPaths="~/Upload" DeletePaths="~/Upload"></ImageManager>  
         <DocumentManager MaxUploadFileSize='2100000' ViewPaths="~/Upload" UploadPaths="~/Upload" DeletePaths="~/Upload"></DocumentManager>  
       </telerik:RadEditor>  

It will make all src attributes in the editor content to have absolute URLs

How to use Built-in Content Filters of RadEditor to enable Absolute URLs

Posted by : Stranger
Date :Thursday, February 6, 2014
With 0comments

Kolibree Bluetooth toothbrush helps improve the brushing technique through the power of its app

|
Read more »
The Kolibree toothbrush has an accelerometer, a gyroscope, and a magnetometer inside, which it uses to record how long you brush your teeth for, and how you brush them.It can send this information to an Android phone or iPhone via a Bluetooth wireless connection.



The Bluetooth toothbrush from Kolibree

It can show you live information on how you're doing so you can adjust your brushing technique, or simply brush for longer. Or it can sync that information with a phone app to give you a running total of how well you've brushed.
You end up looking at a screen that gives you a score out of five that's based on how long and well you've cleaned your teeth.

Silliest is it has the ability to set up different family members in one app and track them separately, with the app generating a graph showing how well you brush compared with everyone else.

generate a graph to pit your brushing habits against the rest of the family

Its kind of having a personal dentist actually watching you brushing on a day-today basis.It can be useful only in one way : for kids.

Toothbrush will go on sale this summer (summer 2014) and will be priced from $99 to $199 depending upon the features (whoopp!!!).

Courtesy - CNET, CES 2014
Next Prev
▲Top▲