Tag: Database

Install Cassandra Database – Download Cassandra Database

Install Cassandra Database – download cassandra database for windows Install Cassandra Database Cassandra is support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages. To Install Cassandra by follow simple steps: Follow these simple steps to install: Download

About NOSQL Database – What is NoSQL

Know About NOSQL Database – What is NoSQL About NOSQL Database NOSQL stands for NOT ONLY SQL. Some developer say it ‘future database’ and critics rule out the possibly that it can be the replacement of RDBMS(Relational Data Base Model). Others say it is not a replacement but a good choice for non-relational data. From

Stored Procedures Benefits – Execution Speed

Stored Procedures Benefits Stored Procedures have many benefits of using a stored procedures like increased execution speed, fast access data, consistency etc. Advantages of Stored Procedures 1. Execution Speed Increased execution speed is the most useful advantage. and they are optimized the first time they are compiled. They are cached on the server. 2. Security

Get Last Insert Id From Database Table Using Coldfusion

Get Last Insert Id From MSSQL, Oracle, Sybase, Informix and MySQL Table Using Coldfusion with identifycol, rowid, sys_identity, serial_col, generated_key, @@identity, SCOPE_IDENTITY() Get Last Insert Id From Database Table Using Coldfusion <cfquery name="insertDatabase" datasource="MyDSN" result="queryResult"> INSERT INTO employee ( FName, LName ) VALUES ( 'sql', 'server' ) </cfquery> <cfoutput> #queryResult.GENERATED_KEY# - From MySQL #queryResult.identifycol# -