SQL SUBSTRING - Introduction and syntax
SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai
Explain the SQL SUBSTRING statement. Write SQL syntax for the SQL SUBSTRING
statement along with an example.
SQL SUBSTRING: The Substring function in SQL is used to capture
a portion of the stored data
Syntax:
SUBSTR(str,pos,len): Starting with the
th character in string and select the next
characters.
Example:
SELECT SUBSTR(company_name, 3) FROM Company WHERE company_name =
‘tata’;
Also read
Answer - Restricting query
result means return of required rows instead of all rows of the
table. This helps in reducing network traffic......
Answer - Both are used for
filtering of records based on filtered criteria.....
Answer - Data Integrity validates the data
before getting stored in the columns of the table. SQL Server
supports four type of data integrity.....
Answer - The Bulk Copy is a command utility that
transfer SQL data to or from a data file.
This utility mostly
used to transfer huge data to SQL server from other
database....
Answer - XPath is a language defined by the W3C,
used to select nodes from XML documents. ....
Answer - A file or file group can only be used
by one database. For example, the files abc.mdf and abc.ndf
contains....
|
