@eric,

I agree with your solution.

Simple and basics are remembered.

Thanks,

Durga

Hi,

There are many online tutorials to help you.

You may start with referring to this tutorial, http://www.tutorialspoint.com/teradata/.

Thanks,

Durga Prasad.

Yes, its always a best practice to have a primary key on table to avoid the heap. It can be either simple identity column or any business key.

Also as...

Yes, SQL Server 2014 express edition supports business intelligence.

For minimum system requirements, refer to books online.

Best regards,

Durga Prasad.

nolock is same as Isolation level ReadUncommitted.

You can find the saem using below query,

SELECT CASE transaction_isolation_level

WHEN 0 THEN 'Unspecified'

WHEN 1 THEN 'ReadUncommitted'

WHEN 2 THEN 'ReadCommitted'

WHEN 3...

@Grant Fritchey,

Thanks for the reply.

It seems the SQL Test tool will unit test to check the values of data types and to mock database objects but my requirement is not...

I agree with you, Partitioning main purpose is to maintain the database but not for performance.

Thanks,

Durga Prasad.

Thanks for the update.

So this test case worked for you with float datatype or not?

I have verified this and it works fine for me, refer to the attachment.

Hi all,

Can somebody explain if there are any tools available to unit test the functional test cases in database?

Thanks,

Durga Prasad.

Interesting scenario, I am also keenly interested to learn about this.

strictly this usage is not possible in SQL Server as the other expert suggested.

For better help, you need to post the associated DDL and DML statements with sample data.

Thanks,

Durga Prasad

Yes, please post the DDL and DML associated with this query to help you better.

@luis,

The OP should be good enough now.