I have slight disconnect with this reply. As far System testing is concerned as it is a black box testing the test cases doesn't specifically say that this the boundary condition for this...
Type: Posts; User: jbanx; Keyword(s):
I have slight disconnect with this reply. As far System testing is concerned as it is a black box testing the test cases doesn't specifically say that this the boundary condition for this...
In my perspective integration testing is done by the person who is responsible for the functionality. This functionality could be divided into many smaller function and handed over to a developer for...
Inheritance is a way of reusing the method, properties etc. This allows you to define class for very specific reason and inherit rest of the methods and properties from base class (which again is...
To tell you more Convert internally uses toString. In convert first there is a check for null, if there is null then string.empty is returned, else normal toString method is called
Select MAx(MaxSalary) from (Select Max(Salary) MaxSalary from table A
Union
Select Max(Salary) MaxSalary from table b) as B
Hope this will work
One example is here
create table t1(col1 int, col2 int, col3 char(50))
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 2,...
Certainly using "case" we can update a row with different values !!!
I would certainly suggest that if you have huge list of argument list then pass it as comma seperated value and then extract value in SP
Hi,
Following is one example of dynamic query
Declare @TableName varchar(128), @ColumnList varchar(1000)
Declare @SQL varchar(1000)
set @TableName = 'authors'
SELECT @ColumnList =...
CHAR
CHAR should be used for storing fix length character strings. String values will be space/blank padded before stored on disk. If this type is used to store varibale length strings, it will...
You can't do it but what you can do it is add at the end of the table with alter table add column statement !!!
This is with reference to Oracle
VARCHAR
Currently VARCHAR behaves exactly the same as VARCHAR2. However, this type should not be used as it is reserved for future usage.
VARCHAR2 is used to...
Here is one of the example:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
...
An action causing the automatic invocation of a procedure, for instance to preserve {referential integrity}. A triggers goes into effect when a user attempts to modify data with an insert, delete, or...
a trigger is a set of Structured Query Language (SQL) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs. A trigger consists of an...
I think followin should work for you
ALTER TABLE <table name>
MODIFY houseno varchar2(30) ;
Hi
Please explain the Difference between Convert Vs String.ToString