Subscribe: SQL
http://feeds.feedburner.com/blogspot/llFkx
Preview: SQL

SQL



SQL is a standard interactive and programming language for querying and modifying data and managing databases



Last Build Date: Thu, 07 Sep 2017 15:59:33 PDT

 



FETCH_STATUS function in sql server

Mon, 04 Mar 2013 03:29:00 PST

@@FETCH_STATUS function determines whether FETCH keyword has successfully retrieved a row from the current cursor. The value of @@FETCH_STATUS is undefined before any fetches have occurred on the...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



CURSOR_ROWS function in Sql Server

Mon, 04 Mar 2013 03:02:00 PST

@@CURSOR_ROWS function returns number of rows currently in the last opened cursor. The number returned by @@CURSOR_ROWS is negative if the last cursor was opened asynchronously. Keyset-driver or...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



REPLICATE Function

Wed, 08 Aug 2012 20:36:00 PDT

REPLICATE function of sql server with examples. REPLICATE is used to repeat a string with specified number of times. Syntax of REPLICATE Function :REPLICATE ( character_expression...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



NULLIF Function

Wed, 08 Aug 2012 20:27:00 PDT

NULLIF function in sql server with examples. NULLIF function returns null value if the two specified expressions are equivalent. NULLIF is equivalent to a searched CASE function in which the two...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



CASE Expression

Tue, 07 Aug 2012 02:21:00 PDT

CASE expression in sql server with examples. CASE expression enables many forms of conditional processing to be placed into a SQL statement. By using CASE, more logic can be placed into SQL...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



FILE_ID Function

Tue, 07 Aug 2012 02:05:00 PDT

FILE_ID function in sql server with examples. FILE_ID function is used to get file identification number for logical file name in the current database.Syntax of FILE_ID Function :FILE_ID (...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



SQL Wildcards

Wed, 13 Jun 2012 09:43:00 PDT

  SQL wildcards can substitute for one or more characters when searching for data in a database. SQL wildcards must be used with the SQL LIKE operator. With SQL, the following wildcards can...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



SQL TOP Clause

Thu, 01 Mar 2012 21:37:00 PST

The TOP clause is used to specify the number of records to return.The TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Integration Services

Fri, 21 Jan 2011 20:36:00 PST

SQL Server Integration Services (SSIS) is Microsoft’s new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000’s...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Reporting Services

Fri, 21 Jan 2011 20:35:00 PST

Reporting Services is a Web service–based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Analysis Services

Fri, 21 Jan 2011 20:35:00 PST

Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications. As its name suggests, Analysis Services provides a very robust...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



SQL Server 2008’s Database Engine

Thu, 13 Jan 2011 05:06:00 PST

The Database Engine is the primary component of SQL Server 2008. It is the Online Transaction Processing (OLTP) engine for SQL Server, and has been improved and enhanced tremendously in this version....

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



What is SQL Server 2008/RDBMS?

Thu, 13 Jan 2011 05:05:00 PST

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



SQL Server Security

Mon, 02 Aug 2010 01:32:00 PDT

There are several levels of security to SQL Server. At the a base level, in order to be granted get access to a SQL Server, a user is required to have a login account. There are two modes of...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Top 7 Free Open Source Database Server

Sun, 25 Jul 2010 21:51:00 PDT

Open Source Server based database management systems have become a common choice for organizations over the stand alone desktop databases. The server based databases or RDBMS such as MySQL,...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Top 10 PostgreSQL Performance Optimization Tips

Sun, 25 Jul 2010 21:20:00 PDT

PostgreSQL performance optimization is a widely discussed issue on the most forums. Although PostgreSQL is shipped with a solid default configuration aimed to fit most setups, it requires fair amount...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



How To Process MySQL Timestamp in PHP

Thu, 22 Jul 2010 01:34:00 PDT

Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



MySQL 5.5 Milestone 2 improves replication and stored procedures

Wed, 14 Jul 2010 00:30:00 PDT

The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



MariaDB 5.1.44b Released

Tue, 13 Jul 2010 00:30:00 PDT

MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download. This is a bugfix/security release of MariaDB 5.1.44. From the MariaDB 5.1.44b...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Microsoft links free SQL database with ASP .Net

Mon, 12 Jul 2010 00:30:00 PDT

Microsoft is enabling its free SQL CE (SQL Server Compact Edition) database to work within ASP.Net Web applications, thus providing a lightweight database option for ASP.Net Web development, a...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



Stored Procedures in MySQL 5.0

Sun, 11 Jul 2010 00:30:00 PDT

MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



MySQL 5.0 New Features: Triggers

Sat, 10 Jul 2010 00:30:00 PDT

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



MySQL 5.0 New Features: Data Dictionary

Fri, 09 Jul 2010 00:30:00 PDT

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



MySQL 5.0 New Features

Thu, 08 Jul 2010 00:30:00 PDT

This book is for the long-time MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". The long answer is the MySQL...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)



MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

Fri, 25 Jun 2010 21:31:00 PDT

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server: mysqlcheck -u root -p --auto-repair --check --optimize...

SQL is a standard interactive and programming language for querying and modifying data and managing databases(image)