what operator performs pattern matching?
Answers were Sorted based on User's Feedback
Answer / rajendra prasad reddy penumall
'Like' operator is a pattren matching operator.
Eg;
select name from class where name like 'a%'
selecting names starting with letter 'a' and any length
select name from class where name like '_a%'
selecting names starting with second with letter 'a' and
any length.
select name from class where name like '[abc]%'
selecting names starting with first letter 'a'or 'b'
or 'c' and any length.
select name from class where name like '[^abc]%'
selecting names except starting with first letter with
letter 'a'or 'b' or 'c' and any length.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / deepak
Pattern matching is used to get the information without
mentioning the full name and by just using the LIKE operator
and just mention the starting letter.
Is This Answer Correct ? | 1 Yes | 0 No |
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Using the customer, and order table in northwind database, please write a query to produce xml?
Describe about first three Normal forms.
Explain what is the difference between union and union all?
What are the advantages of using stored procedures?
What is always encrypted?
What are the differences between clustered and non-clustered index?
How to get the query of a table in sql server?
Can we perform backup restore operation on tempdb?
How to insert and update data into a table with "insert" and "update" statements?
What are the different SQL Server Versions you have worked on?
What to check if a User database is locked?