IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE
   ► KBRole-Based T...DBA & DataANSI SQL Scr...   Print This     

DBA KB: ANSI SQL Scripting Topic


5 Articles Found in the ANSI SQL Scripting Topic 

  KB Article    

Scott Wehrly
1. Concatenation of VARCHAR fields yields NULL When you have a concatenation of two or more CHAR or VARCHAR fields in a SELECT statement, and one of the fields is NULL, the resulting value will be NULL.
19 years ago
(1 Comments )

KB Post
Nothing New Since Your Last Visit
8887
Hits

DBA, Databases, & Data

Mike Prestwood
2. Drop Index Drop an index with the DROP INDEX statement.
14 years ago

Flashcard
Nothing New Since Your Last Visit
5540
Hits

DBA, Databases, & Data

Mike Prestwood
3. Finding Duplicate Values Using SQL To find duplicate values in the same field, you need to use an alias with the same table twice.
19 years ago, and updated 13 years ago

KB Post
Nothing New Since Your Last Visit
8142
Hits

DBA, Databases, & Data

Mike Prestwood
4. Not In SQL Select Query

The following selects all the records in Table1 where IDField is not in Table2.

12 years ago

Code
Nothing New Since Your Last Visit
10786
Hits

DBA, Databases, & Data

Mike Prestwood
5. Reverse sort order in a select Is there a way to reverse order a select statement?
19 years ago

FAQ
Nothing New Since Your Last Visit
12428
Hits

DBA, Databases, & Data

Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New DBA, Databases, & Data Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  DBA, Databases, & Data Message Board
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]