2-3 words in field name

Goran

Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?

Dec 20 '06 #1

Subscribe Post Reply

1447

Erland Sommarskog

Goran (gz****@gmail.com) writes:

Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?

Yes you can. You need to enclose the name in brackets [] or double quotes ""
whenever you use it.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Dec 20 '06 #2

Dave Sexton

Hi,

It's not recommended though.

You shouldn't use the field names as captions if you want something more
readable. For instance, if you're using a DataSet you can assign the
Caption property to something other than the field name. In grids you can
easily set the headers at design-time.

--
Dave Sexton

"Goran" <gz****@gmail.comwrote in message
news:em**********@sunce.iskon.hr...

Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?

Dec 20 '06 #3

by: mr_burns | last post by:

Hi there, I have a text box that I will use to search a database. I would like to use it so that it will not use a whole string (ie. 'red striped top') but instead break it up into individual...

PHP

listing words in a textbox using checkboxes

by: Gary | last post by:

Hello, Is it possible to dynamically update a textbox with words chosen from a list using form checkboxes and javascript? Gary

Javascript

Would like to tabulate occurrences of words in a table

by: Peter Bungart | last post by:

I have a text field in Access (XP) that lists the occurrences of various plants, which are delimited within the field by commas (e.g., cactus, mesquite, yucca, cliffrose). Is there a way to...

Microsoft Access / VBA

the 79 key words you need

by: PLENI SELENE | last post by:

HOW TECHNOLOGY MOVES FROM TALK TO ELECTRONIC DEVICES TO SPEAK GOOD SPANISH! Would you Like To Know How The Electronic Devices Understand When You Talk to Them, And How It Works To...

C# / C Sharp

Searching for words out of older in Access

by: yourtrashhere | last post by:

So basically, what I have is a bunch of words in one memo field, for example: dog cat cowboy tree flower To search it, this is the code I have now. ' Check for LIKE Last Name If...

Microsoft Access / VBA

best way to search for multiple words through a query

by: vonclausowitz | last post by:

Repost from an VB group. Hi All, I'm looking for a way to search for multiple words in a database. There is however one but. The words have to be within a certain range of each other. For...

Microsoft Access / VBA

2-3 words in field name

by: Goran | last post by:

Can I define field names with more words in Access and SQL Server like field: "Bus station" instead "BusStation" or "Bus_Station"? I have had problems because of this in VB6. Can I have problems in...

ASP.NET

Reserved Words in Access, Especially Date and Time

by: missinglinq | last post by:

When naming controls and variables in Access you should always be careful not to use Access Reserved Words! If you have to give them a similar name, use something like txtDate, or even better,...

Microsoft Access / VBA

sql for @[word1 word2].....how do build a query when field name has 2 words?

by: captainphoenix | last post by:

In VB (.NET?) building a query from a table made in MS Access. I'm trying to type the sql line WHERE = @ but it won't recognize the code because "Course Number" is two words. the whole thing...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

2-3 words in field name

Similar topics