Search In
This function is used to get the character from a text field .
Syntax In MySQL :
select mid ( column_name , start [ starting_length , ending_length ] ) from table_name ;
Starting length : It is mandatory .
Ending length : It is optional . If you o
This function is used to convert value of column in uppercase . If value of column already in a uppercase then it doesn't covert . It convert only if value of filed is in lowercase .
Syntax :
select ucase ( column_name ) from table_name ;
Syntax f
This function is used to convert , value of column in lowercase . If value of column already in a lowercase then it doesn't covert . It convert only if value of filed is in uppercase .
Syntax :
select lcase ( column_name ) from table_name ;
Syntax
This operator is used to get the data from a combination of " greater than equal " and " less than equal " condition .
Syntax :
select column_name1.......column_nameN from table_name where column_name between value1 and value2 ;
Example :
Table na
Inserting Data from one database table to different Database table.
we can insert or copy data from one database table to another table of different database in SQL Server 2008 using following query keeping one thing in mind that the datatype of co
Following is the XML which we want to create:
SELECT magazineId
, magazineName
, coverPage
, publishDate
, expiryDate
, isActive
,(
SELECT (
SELECT (
SELEC
There are two ways to fetch Nth highest salary/number.
1 - By using general sql query which works on all database.
2 - By using database specific sql query.
Database specific sql query example Nth highest salary/number
SQL Queries in Oracle to fe
Sys Commands :
1) How to count number of procedures in a table
USE [Database_Name]
SELECT COUNT(*) as procedures FROM sys.procedures
2) How to get the attributes of procedure in a table
USE [DatabaseName]
SELECT * FROM sys.procedures where name L
Here is the small steps to upload images or any file into amazon S3 server:-
<?php
define('awsAccessKey', 'AKIAJMEIK5LU3NAR3BTQ');
define('awsSecretKey', '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');
function copyImagetoAmazon($imag
Below is the C sharp code to connect with the sql data base in .net
usingSystem.Data.Sql;
usingSystem.Data.SqlClient;
// FUNCTION TO CONNECT TO THE SQL SERVER DATABASE
privatevoidconnectToSQLServer()
{
// SQL CONNECTION REPRESENTS AN
