Blog Posts - Sql



Difference between close and deallocate cursor in SQL

Cursor in a database is used to retrieve data from the result set, mostly one row at a time. You can use Cursor to update records and perform an operation on a row by row. Given its importance on SQL and Stored procedure, Cursor is also very popular...
by javarevisited on May 12, 2016

Cara Backup Database SQL Server Linux

Cara Backup Database SQL - Linux merupakan sebuah sistem operasi yang berbasiskan open source. Namun seiring berkembangnya jaman semakin banyak pula yang menggunakan sistem ini, selain dikenal yang tahan terhadap serangan virus juga sangat cepat bila...
by AndroSoft on Apr 1, 2016

How to increase length of existing VARCHAR column in SQL Server

You can increase the length of a VARCHAR column without losing existing data in SQL Server. All you need to do is that execute following ALTER TABLE statements. Though, you need to specify NULL or NOT NULL constraint explicitly, depending upon your d...
by javarevisited on Mar 27, 2016

BITes: Servicios NodeJS, Linux*(monitorización+MSSQL Server+PS4), Stallman in BCN

Estos son algunos de los enlaces que me han parecido interesantes esta semana. Muchas cosas de Linux, sistemas, Microsoft, y mucho más. Selección de la semana Ejecuta tu App NodeJS como un Servicio en Producción: La descripción lo dice todo, y n...
by Poesía Binaria on Mar 13, 2016

How to add Columns to an Existing table in SQL Server

Adding a new column to an existing table with data is always tricky. You need to know what data is there, how much data is there, to gauge how long your query is gonna take to complete in production. Also, you cannot add NOT NULL columns into an exis...
by javarevisited on Feb 19, 2016

2 Types of Views Updatable and Read-only -Advanced SQL

Unlike base tables, VIEWs are either updatable or read-only, but not both. INSERT, UPDATE, and DELETE operations are allowed on updatable VIEWs and base tables, subject to any other constraints.INSERT, UPDATE, and DELETE are not allowed on read-only...

SQL Query to describe ‘NULL’ value -Best example

Table: DATA COL1     COL2    COL3 1           2          NULL SQL Query: SELECT col1 + col2, col2 + col3, col1 + col2 / col3 FROM data Question : What are the three values returned by the sample table and query above? Choice...

DB2- Split Predicates to improve SQL Performance

Best rewriting SQL query methods to improve Query performance. First write Split predicates out if possible: SELECT DEPTNO, DEPTNAME FROM DEPT WHERE (ADMRDEPT = ‘E01′ AND DEPTNAME LIKE ‘BRANCH%’) OR (DEPTNO = ‘D01′...

Top Data virtualization Techniques for BI projects (1 of 5)

The term data virtualization is based on the word virtualization. Virtualization is not a new concept in the IT industry. Probably the first application of virtualization was in the 1960s when IBM used this concept to split mainframes into separate v...

Mainframe: DB2 Tutorial For Software Developers (2 of 5)

What is SQL? SQL – all data object manipulation, creation and use, involve SQL’s. DB2 objects – Database, Tablespaces & Indexspaces – creation & use, and other terminology’s associated with databases. SQL or Structur...

These IMS DB, IMS DC Error Codes asked in Many Mainframe Interviews

IMS DB, IMS DC error codes for mainframe interviews. How to prepare for IMS DB interviews is a big challenge. I made here simplified. AM – Proc option ‘P’ is not defined for command code VI – Variable segment size is crossing...

These DB2 SQL Errors asked in Many Mainframe Interviews

Below is the list of frequently asked DB2 SQL errors in Mainframe+job interviews. 000- Successful 100-Row not found -205-Column name is not a column of the table -305-Null value cannot be assigned to a host variable -313-Number of host variables dec...

Project Manager Responsibilities in Software Company (2 of 2)

Roles and responsibilities: The Project Manager has the authority to run the project on a day-to-day basis on behalf of the Project Board . Responsibility: The Project Manager’s prime responsibility is to ensure that the project produces the...

MySQL case sensitive insert

Recently faced a problem where I needed case-sensitive inserts but they are not supported by default or they need some trickery per say … Create database Test character set utf8 collate utf8_bin; CREATE TABLE Test.Users( name varchar(30) primar...
by Concluzions on Jun 27, 2015

ALTER TABLE table_name DROP COLUMN column_name

ALTER statement we can use in DB2 SQL query to drop a column. ALTER TABLE table_name DROP COLUMN column_name But, there are lot other conditions involved, which column we can drop or not. The containing table space is not a universal table space. The...

5 amazing facts to blow your mind (#2).

1. The dot above the i or j is called a ‘tittle' 2. The fastest spinning pulsar is PSR J1748-2446ad( PSR J1748-2446ad)It spins at a staggering 0.24c ( c= speed of light) and a radius less than 16 km!3 .SQL- airport code for San Carlos airport...
by What did you learn today? on Apr 9, 2015

Dar um tapinha no SAP........Função RSDU_EXEC_SQL

É necessário aquela alteração, mas o ambiente não permite que se faça da maneira correta...por centenas de milhares de motivos já bem conhecidos....dai você precisar atualiza aquele campo.....????Como fazer???Eis a solução dos seus problema...
by SAP ABAP on Mar 31, 2015

Cara Import File Excel ke Database MySQL

Pernah import data dari excel ke database mysql? klo sebelumnya kan pernah kita bahas bagaimana cara export data dari mysql ke bentuk excel. Nah kali ini sebaliknya import data-data dari data dalam file excel ke database. Sebenarnya caranya mudah saj...
by CodeNol on Mar 20, 2015

KEEP_DENSE_RANK_OVER

SELECT K.NO,        K.CINS,        K.TC,        K.ISIM,        K.DYER,        FLOOR(MONTHS_BETWEEN(SYSDATE, K.DOGUMTARIHI) / 12) AS YAS,        RANK() OVER(PARTITION BY K.DYER, K.CINS ORDER BY FLOOR(MONTHS_BETWEEN(SYSDATE, K.D...
by Istikamet Italia on Feb 17, 2015

21 Consultas SQL para administrar fácilmente nuestro WordPress

Muchas veces cuando trabajamos con WordPress hacemos uso directamente de algún plugin, dentro de la infinidad de ellos que tenemos disponible, lo cual está muy bien pero a veces nos despegamos un poco de los orígenes. MySQL está hecho para usar M...
by Poesía Binaria on Feb 11, 2015


Trending Topics

Close