I.T. Discussion Community!
-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.
17 years ago
(1 Comments )

KB Post
Nothing New Since Your Last Visit
8588
Hits

DBA, Databases, & Data

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

Flashcard
Nothing New Since Your Last Visit
5314
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.
17 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7765
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.

10 years ago

Code
Nothing New Since Your Last Visit
10307
Hits

DBA, Databases, & Data

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

FAQ
Nothing New Since Your Last Visit
11764
Hits

DBA, Databases, & Data

Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 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
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech