Difference Between Sql Server VARCHAR and VARCHAR(MAX) Data Type

Varchar ; It can store maximum 8000 Non-Unicode characters (i.e. maximum storage capacity is 8000 bytes of storage). Optional Parameter n value can be from 1 to 8000 .If we know that data to be stored in the column or variable is less than or equal to 8000 characters, then we can use this data type.For example ... . Like many initially when Varchar(MAX) datatype was introduced in Sql Server 2005, I too was not clear about the difference between Varchar and Varchar(Max) and which one to use when.

answered 27 Sep by Roshan333 mysql 2 Answer(s) September 28, 2017

What is Spring Framework?

The Spring Framework is a Java platform that provides comprehensive infrastructure support for developing Java applications. Spring handles the infrastructure so you can focus on your application. Spring enables you to build applications from "plain old Java objects" (POJOs) and to apply enterprise services non-invasively to POJOs. This capability applies to the Java SE programming model and to full and partial Java EE.

answered 26 Sep by Roshan333 java 3 Answer(s) September 27, 2017

What is Cross Page Posting? How is it done?

By default, ASP.NET submits a form to the same page. In cross-page posting, the form is submitted to a different page. This is done by setting the ‘PostBackUrl’ property of the button(that causes postback) to the desired page. In the code-behind of the page to which the form has been posted, use the ‘FindControl’method of the ‘PreviousPage’ property to reference the data of the control in the first page.

answered 25 Sep by muneshs16 c# 2 Answer(s) September 26, 2017

Mention what are the two ways for adding constraints to a route?

You can add route constraints in two ways: By using regular expressions. By creating and using custom route constraint classes. Let's look at both of the techniques one at a time. Using Regular Expressions to Restrict Route Open the Global.asax file again and modify the route definition you added earlier. routes.MapRoute( "BlogPosts", "posts/{year} ... PublishDate.Value.Year == value) { return Regex.IsMatch(value.ToString("0000"), strRegEx); } else { return false; } } catch { return false; } } }

answered 24 Sep by Roshan333 mvc 2 Answer(s) September 25, 2017

Explain what is VBA or Visual Basic for Applications?

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was discontinued in 2008, and its associated integrated development environment (IDE).Visual Basic for Applications (VBA) allows users additional customization beyond what is normally available in Microsoft Office products, such as Excel, Access, Word and PowerPoint.

answered 23 Sep by Roshan333 excel vba 2 Answer(s) September 24, 2017

Immutable objects are automatically thread-safe?

Since two different threads can see a different hashcode, in an external point of view we have a change of state and so it is not immutable.We can so conclude that String is immutable because it is thread safe and not the opposite.What's the point of saying "Use an immutable object, it is thread-safe.

answered 22 Sep by Roshan333 java 2 Answer(s) September 23, 2017

What is static keyword?

The static keyword in java is used for memory management mainly. We can apply java static keyword with variables, methods, blocks and nested class.

answered 21 Sep by rohith3309 java 2 Answer(s) September 22, 2017

PowerBuilder - Objects in nested report

You can do a GetChild on the nested report and then access it's properties. Make sure you set the Name field on the General tab on the nested report this is what you will use as part of your GetChild Call. dw_1.GetChild('Name Field',dwc_nest1)

answered 20 Sep by LogenRahul power builder 2 Answer(s) September 21, 2017

What is SAP BW/BI? What is the purpose of SAP BW/BI?

SAP BI is similar to BW but it is more advanced. SAP BW was renamed as SAP BI from NetWeaver 7.0 onwards. BI came after BW 3.5. The main difference between BI and BW are BI has BI accelerator which boosts the query performance. It will be much faster. Uses transformation rules instead of update rules and transfer rules. BI allows ... tool. BI/BW is where data, extracted from various applications, is sitting for further analysis... and BO is the front end tool that is used to analyze this data.

answered 18 Sep by Govind123 sap bw 2 Answer(s) September 19, 2017

where is hardware timer interrupt?

The hardware timer interrupt, the kernel scheduler code may suspend the process that was running and allow another process to run. It is the presence of the scheduler code which enables multitasking.

answered 17 Sep by rohith3309 operating systems 2 Answer(s) September 18, 2017

C# thread on forms

If you want your application to be responsive, you should perform the data operation on a separate thread instead. If you just want to show the PictureBox control, you don't need the extra thread at all: pictureBox2.Visible = true; pictureBox2.Refresh(); // <-- causes the control to be drawn immediately ...large operation ... you to keep your current code and use InvokeRequiredand Invoke, even though Invoke will only execute when the UI thread has time to process it (AFTER the data operation).

answered 15 Sep by muneshs16 c#, thread 2 Answer(s) September 16, 2017

What is the difference between (char)0 and '\0'? in C

They're both a 0, but (char) 0 is a char, while '\0' is (unintuitively) an int. This type difference should not usually affect your program if the value is 0. I prefer '\0', since that is the constant intended for that.

answered 14 Sep by muneshs16 c 2 Answer(s) September 15, 2017

Get VIEW ddl using query

By calling the GET_DDL() Function of metadata package DBMS_METADATA. Syntax: select DBMS_METADATA.GET_DDL('TABLE','<table_name>') from DUAL;

answered 12 Sep by rohith3309 sqlserver 2 Answer(s) September 13, 2017

How many recordings methods in WinRunner?

They are Two recording modes 1. Analog Recording: It is useful to record all mouse movement operations, bitmaps etc 2. ContexSensitive Recording: It is useful to record the actions performed on a stand alone objects.

answered 9 Sep by rohith3309 testing 2 Answer(s) September 10, 2017

what are the differences between OLEDB and ODBC?

The key difference between OLE DB and ODBC is that OLE DB can provide connection to data stored in non-relational formatODBC-it is designed for connectingto relational databas However, OLE DB can access relational databases as well as nonrelational databases. There is data in your mail servers, directory services, spreadsheets, and text files. ... to query, through SQL Server, the Active Directory on the domain controller, you couldn't do this with ODBC, because it's not a relational database

answered 7 Sep by Roshan333 sqlserver 2 Answer(s) September 8, 2017

Name the modes in which Hadoop can run?

Local (Standalone) Mode- By default, hadoop run in a single-node, non-distributed mode, as a single Java process. Local mode uses local file system for input and output operation. One can also use it for debugging purpose. It does not support the use of HDFS. Standalone mode is suitable only for running programs during ... same. Fully-Distributed Mode- In this mode, all daemons execute in separate nodes forming a multi node cluster. Thus, it allot separate nodes for Master and Slave.

answered 11 Sep by muneshs16 big data 2 Answer(s) September 12, 2017

PUT vs. POST in REST

The POST method is used to request that the origin server accept the entity enclosed in the request as a new subordinate of the resource identified by the Request-URI in the Request-Line The PUT method requests that the enclosed entity be stored under the supplied Request-URI. If the Request-URI refers to an already existing resource, ... resource, and that URI is capable of being defined as a new resource by the requesting user agent, the origin server can create the resource with that URI."

answered 10 Sep by rohith3309 api 2 Answer(s) September 11, 2017