Hi, i'm trying to run a stored procedure:
"EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT',
'2006-02-01 00:00:00', '2006-02-28 00:00:00'"
and gives me this error:
The identifier that starts with
"EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT',
'2006-02-01 00:00:00', '2006-02-28 00:00:00'"
is too long. Maximum length is 128.
Anyone could help? 1 21752
Try removing the double quotes around the statement:
EXECUTE dbname.dbo.spGid
'KFT',
'0000000011,0000000012',
'merch,DSMT',
'2006-02-01 00:00:00',
'2006-02-28 00:00:00'
You might also consider passing date strings in format yyyymmdd so that it's
independent of the DATEFORMAT setting.
EXECUTE dbname.dbo.spGid
'KFT',
'0000000011,0000000012',
'merch,DSMT',
'20060201 00:00:00',
'20060228 00:00:00'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Pedro" <p_*****@sapo.pt> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com... Hi, i'm trying to run a stored procedure:
"EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT', '2006-02-01 00:00:00', '2006-02-28 00:00:00'"
and gives me this error:
The identifier that starts with "EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT', '2006-02-01 00:00:00', '2006-02-28 00:00:00'"
is too long. Maximum length is 128.
Anyone could help? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Tobias |
last post by:
Hi all,
am I right assuming that the maximum length for a varchar field
I can fetch with the sybase_fetch_* functions is 255?
This maximum can only be circumvented by using a text or image...
|
by: dixie |
last post by:
Is there a maximum length in VBA of a line containing stuff like the
following:
If password = "1234" or password = "1235" or password = ............... Then
It seems to me that at some stage, I...
|
by: fieldfallow |
last post by:
Hello all,
Before stating my question, I should mention that I'm fairly new to C.
Now, I attempted a small demo that prints out the values of C's numeric
types, both uninitialised and after...
|
by: Alan Foxmore |
last post by:
Hello all,
Is it possible to use String.Format() to specify a maximum length for a
formatted item? For example, let's say I have:
String.Format("{0}", "FREDDY");
How can I specify that the...
|
by: hug |
last post by:
The valid character set for the ID= attribute of html tags is listed
here (http://www.htmlhelp.com/reference/html40/attrs.html) but I am
having difficulty finding the maximum allowable length of...
| |
by: Martin Pöpping |
last post by:
Hello,
does a String in C# have a maximum length?
I tried to write a ToString Method of my class containing a hashtable.
At the beginning of the method i defined a String "ret".
In every...
|
by: Paul Johnston |
last post by:
I know this may sound silly but given something like
if ($_ =~m/(one)|(two)|(three)/)
Is there a maximum length on the size of the item between "/" and" /"
?
Just curious as regards showing...
|
by: karthee |
last post by:
all,
what is the maximum length(text) of a node in a treeview.
can we set the text length for a treenode?
-Karthee
|
by: Ramu528 |
last post by:
Friends,
I am working on excel sheet. i populated gridview with excel sheet data.
the gridview has one column.
have to find out the maximum length of String in that column.
For example:...
|
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,...
|
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...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
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...
| |