Memory Management

Technical Article

RE: implement parent and child in build of materials “

  • Reply

Hi folks, I’m working away at this end and would like to ask if I’ve followed you correctly regarding: 1) the number of primary keys for each table 2) the relationships between them. So, I’ve listed the tables, with my interpretation of them. tblProduct (single primary key) productId INT NOT NULL IDENTITY(1,1), productDesc VARCHAR(150) NOT […]

You rated this post out of 5. Change rating

2003-06-27

1 reads

Technical Article

RE: How to store result of SELECT in local var.

  • Reply

Thanks Frank, this works fine. I've been browsing BOL, but didn't really find what I was looking for (didn't see your solution either). Now the last thing that won't work properly, is the CASE statement: whatever the value of the BIV field, I always get 'A' filled in. Anyone an idea how come? Thanks, Bart

2003-06-27

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers