|
|
Browse by Tags
- Tags:
- 2000
- 2005
- 9
- 9i
- As Statement
- Business Objects
- compare
- Crystal Reports
- data connection
- Database
- database design
- db design
- db diagram
- db2
- ddl script
- diagram
- filemaker
- Filemaker Pro
- group by
- InfoPath
- Internet Explorer
- join tables
- Live Communications Server
- Microsoft
- MSSQL
- mysql
- normalization
- one to many relationship
- Oracle
- postgres
- query
- RDBMS
- relational database
- rows
- sql
- SQL 2000 and 2005
- SQL 2005
- SQL Queries
- SQL Query - Ignore row if there's letter in a field
- sql script
- SQL Server
- SQL Server 2005
- SQL Snytax
- sql statement
- sql syntax
- SQL update convert datetime to varchar yyyymmdd
- Sybase
- syntax error
- toad
- TSQL
- T-SQL: JOIN statement returning syntax error
- union
- v11
-
SQL Query - Ignore row if there's letter in a field
Hello Experts, Is it possible to filter a row if a particular field has letter? I have a field called ID that support both alphanumeric. However, I would like to filter out any ID that has letters. -
T-SQL: JOIN statement returning syntax error
I recently asked a question on how to create a table of cross-referenced values from multiple tables. My question was answered, but the actual query I needed was more complex than the question originally indicated. After some discussion, the person helping me came up with the following query, which ... -
Sql query
Hi Experts! I am trying to create a query that meets the following conditions. From my duplicate table I would like to list Customerno1 and customerno2 where both customerno1 and customerno2 exists in the customer table I have tryed with the following query, but it gives me 0, and I know that is not... -
SQL update convert datetime to varchar yyyymmdd
Hello, I have data stored as datetime: 2001-02-22 16:27:57.293 and would like this to be 8-digit string field yyyymmdd as: 20010222. There are also some null and/or blank values in there as well, so I want to case those out. something like: update tablename SET datefield = CASE WHEN Isdate(datefield... -
One to One Relationship and ON DELETE CASCADE - RDBMS Design
Customer and CustomerPrivateInfo are meant to be one to one relationship. If CustomerPrivateInfo record is attempted to be deleted, prevent deletion. If Customer record is deleted, delete its associated CustomerPrivateInfo. Does the DDL below fulfill my request? I'm using Oracle... Code Snippet:... -
Displaying Decimal Points
Hi, I have a generic question that is really annoying me... I have a couple of different ways of querying my DB.. I use Toad, Excel, SQL Plus & a SQL editor called "Universal SQL Editor" When I query the DB using SQL Plus & Excel, I can see the number of decimal places that are in the... -
How to Draw Diagram for My Database Design?
I find database designs get the db designer mixed up/confused in some point of designing. Is there a certain diagram flow that is commonly known amongst designers? When i design a database, it comes to a point i feel i want to put them all in one sheet of paper so i can know what goes in and what goes... -
SQL*Plus Error While Running a DDL Script - Oracle
I have DDL Script. When i run every table DDL script individually, tables gets created. However, when i run the whole script by doing: SQL> @C:\Users\Home_User\Desktop\motel_db_schema.sql I got error for one the tables which screws up all the child tables too. This is the error i get: SP2-0734: unknown... -
Infopath: Query a SQL database
I have been searching for hours now and I can't seem to find an answer on my very simple question: How do I CODE a SQL connection in InfoPath? (VB in Visual Studio for Applications) Everywhere I find some example of codes, it all starts with "Add 'Imports System.Data.SQLClient'"...