|
Assuming you use varchar as the data type:
Update tablename Set Memeber_Id = substring(Memeber_Id,2,len(Memeber_Id-1))
Why don't you store the Memeber_Id in int column?
|
|
|
|
|
Thank you very much for your response.
Memeberid is Char(30) data taype.
When i run your script it comes with the following error
""""The conversion of the varchar value '7207513006 ' overflowed an int column. Maximum integer value exceeded.
Please advice
Thanks
|
|
|
|
|
What is UP?
Is it not possible to do?
thanks
|
|
|
|
|
Can you plz provied the structure of your table??
RK..
|
|
|
|
|
Thank for your reply.
Its just a single table with no relationship to other tabel.
Having
Id int
message nvarchar(150)
Memberid Nvarchar(50).
I have to store memberid as nvarchar for some reason.
hope this helps to understand my table structure.
regards
kibrom
|
|
|
|
|
kibromg wrote: Memberid Nvarchar(50).
did not you say that it's char(30)?
|
|
|
|
|
|
can you post the exact query that you run and the exact error?
What database and version do you run?
This query should not give this kind of errors, no conversion to int occurs.
|
|
|
|
|
Yes it's true... the querry which was wriiten will not give such type of error.
RK..
|
|
|
|
|
Thanks man,
I am using SQL 2005. The table is not related to any other table.
I am just to change the data in memeberid and run the script you gave me.
Update tablename set memberid=substr(.........
Thanks
|
|
|
|
|
I think the problem is memberid is nvarchar(50) datataype not int.
is it?
|
|
|
|
|
no
and the function is substring not substr
Please post the complete query.
|
|
|
|
|
Update DATA Set Memeber_Id = substring(Memeber_Id,2,len(Memeber_Id-1))
|
|
|
|
|
Change it to:
Update tablename Set Memeber_Id = substring(Memeber_Id,2,len(Memeber_Id)-1)
len(Memeber_Id)-1 not len(Memeber_Id-1)
|
|
|
|
|
Thank you vety much man .Its working now.
How erver its trancating all the numbers.Its not removing 0 only.
It removes someother digits on the numbers
thanks
|
|
|
|
|
Yes
this query removes the 1st character whatever it is.
If you want to remove the first character only if it starts with '0' then add this where clause to the query:
Where Memeber_Id like '0%'
|
|
|
|
|
Thanks very much for your help.You know what i wanted to check who run a script on my database and at what time.
Where will i check that on SQL2005 database using athe admin login?
Thank you very very much.
|
|
|
|
|
You can use SQL profiler to display all queries running with some info about them.
Note that this will may cause performance issues.
|
|
|
|
|
thank you very much,
How will i open the activites on SQL profiler?
Thanks
|
|
|
|
|
|
Thank you very much.I really appreciate it.
|
|
|
|
|
1. Vendor Registration master
• Vendors are register as per the currency (INR, Forex)
• If the currency is INR, then vendors for airline, visa, mediclaim, miscellaneous, POE gets added
• If the Forex currency selected then the vendors are register as per the country
• In case of Forex currency, for the single vendor they can select the multiple currency
This master i suppose to create Please advice me on the side of Database Designing
Please create Supplier_master for this
pl suggest me the fields and there data types.
Thanks in Advance.
|
|
|
|
|
soniasan wrote: Please create Supplier_master for this
We're not here to do your homework for you. Read the discussion forum guidelines.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Dear Paul
Thanks for your replay.
I am in intention to give any Homework to u.
I am just want to ask that what fields and on what fields
i suppose to put constraint.
i create supplier_idand currency as primary key
so is it all wright or do u have any suggestion on this
CREATE TABLE [dbo].[Supplier_Mst] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Supplier_id] [int] NOT NULL ,
[currency] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[supplier_type_id] [int] NOT NULL ,
[Country_id] [int] NOT NULL ,
[supplier_name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[supplier_add] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contact_person] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[phone1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[phone2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[fax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
|
|
|
|
|
hi ...
is it possible to show the values in the column as a header for another table
..need query for that...
ex:
in emp table.. i got emp names.. and i want to put all the names in the header for another table..
thanks
mahen
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
