|
by: new |
last post by:
Question:
What would be the best way to add carrage returns to a record, and would my
method create alot of overhead and wasted space. What would be the best
method to minimize overhead and wasted space.
Scenario:
Server MS SQL 2000
Table name= mitTickets
Fields= problem,details, created, lupdate
|
by: Doug Baroter |
last post by:
Hi,
DDLs and DMLs:
create table #job (jobID int identity(1,1) primary key, jobName
varchar(25) unique not null, jobEndDate dateTime, jobComplete bit
default(0), check (( is null and = 0) OR
( is not null and = 1)));
Q1 with check constraint:
sample dagta
|
by: renato |
last post by:
|
by: Programmer |
last post by:
Hi everyone
Well here is my problem
I hope you can help me
|
by: elia |
last post by:
Bonjour,
Débutant en asp, mon navigateur me signale une faute dans cette ligne,
avec ces "" et ses '' je ne vois pas trop d'où viens l'erreur,
quelqu'un pourait-il m'aider? merci, pascal
La ligne est :
req_sql = UPDATE t_abo SET txtTransactionID=" &
request.form("txtTransactionID") & ", txtPayMet=" &
|
|
by: aaj |
last post by:
Hi all
I have a continuous bound form and on each record is a tick box.
The user ticks the boxes and these boxes define the batch. for future
operations
before they leave the page I count the number of ticks using (ADO)
rst.Open "SELECT COUNT(update_po_ref) AS update_qty FROM dbo.tbl_forecasted
|
by: Jules |
last post by:
All,
how do I describe a string consisting of any number of characters, with
an optional (but unique when occuring) end-of-line expression '/'? With
groups if possible, as in "(?<sentence>.*(?<eos>{1}$)?)"
Say I have the phrase 'My Taylor is /' as input; I'd like 'sentence'
and 'eos' to match.
Now if I have 'My Taylor is //' or 'My...
|
by: technocraze |
last post by:
Hi guys & commnunity experts,
Does anyone knw how to go about checking for existing data in an MS Acess table? I have tried out the following code using vb but doesnt seem to work that well? Can anyone ps take a look at this code / logic and if possible point out the error or make correction?
What i need is to check for existing studentId...
|
by: RvGrah |
last post by:
I've built a small app to deploy my apps in a small domain, just for
my own use when I make small updates to pass to my end users. My app
uses File.Copy, and works fine except that it takes a long time to
fail if the machine I'm copying to is in standby, turned off or
hibernating etc.
How could I determine if the machine is running *before*...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|