How to create a SQL Server Agent Job (Transact-SQL) – with only needed fields

Share

In this post you will see two major sections: I. Detailed description for every needed field in system stored procedures. II. Full working example related to above description. Here you need only to replace the names if the default configuration is suitable.

Share
Tags:  

SQL Transactions in Java

Share

1. Rollback all data on import from a table if a row is corrupted.You have a list of sql queries as a parameter:

Share
Tags:     

Windowing Functions in PostgreSQL 8.4

Share

PostgreSQL recently added several great new features like Common Table Expressions (CTE), Recursive CTEs, Windowing Functions (my favorite) and Parallel restoring of dumps. The goal of this article is to provide an overview of the new PostgreSQL Windowing Functions. Previously limited to enterprise databases such as Oracle and DB2, they open up a completely new […]

Share
Tags:   

SQL statements embedded into PowerScript code

Share

SQL statements can be embedded directly into PowerScript code, allowing you to include PowerScript variables in any area of the statement ,whereas you can’t include them if using PowerBuilder Database painter. To work with variables, the SELECT statement accept the INTO clause, that enable assignment of the result to existent variables.  For example: SELECT COUNT(*) […]

Share
Tags:   

Database Glossary – Power Builder

Share

Concurrency Several clients sharing a resource Contention Multiple users try to access a resource at the same time resulting in waits or event deadlocks. Deadlocks A deadlock occurs when two or more transactions are both in a wait state, with each one waiting for the other to release a lock before it proceeds.

Share
Tags:  

By continuing to use the site, you agree to the use of cookies. More information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close