database dependencies

Technical Article

problem with run PROCEDURE-table is empty

  • Topic

i work with link server (pioledb)the problem is thet the table is empty sometimes an it not work OKhow can i condition the delete  ???i wont thet the table is always be fullCREATE PROCEDURE [select_pi2]asDELETE FROM [pitable].[dbo].[Table1]INSERT INTO [pitable].[dbo].[Table1]([val],[uu],[col])SELECT *FROM OPENQUERY(pcntn, 'SELECT value as val ,''UNIT1''as uu ,''FF9900'' AS col FROM picomp WHERE time = […]

You rated this post out of 5. Change rating

2004-12-30

2 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

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