problem related with uploading code to server

Posted by Amritha444 under C# on 12/29/2010 | Points: 10 | Views : 945 | Status : [Member] | Replies : 4
dear all

i have stored procedure which works well in local host but didnt get out put in server.
The problem i notice is i have a table named 'type' but when it writes in stored procedure all small characters goes to uppercase like TYPE indicating the existence of built in type.Its works in localhost may its not case sensitive.Its a master table i cant change name every where any other solution like adding any function to make it our original table name.
Please reply quickly

Thanks in advance




Responses

Posted by: T.saravanan on: 12/29/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi,

In your Procedure using lower function to get the value in lower case.
Try the following code...

 

Select lower( 'ABCD')
O/P: abcd


Cheers :)


Thanks,
T.Saravanan

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amritha444 on: 12/29/2010 [Member] Starter | Points: 25

Up
0
Down
but its not ordinary string its tablename when doing the suggested method errror comes
i also tried [type]
please give me a solution for this

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: T.saravanan on: 12/29/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi,

I am not clear about your question.what did you try ? Is it possible can you shown your code here ?

Thanks,
T.Saravanan

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 12/29/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi Amritha

1. Check your Instance and Database Collation setting on Server ( Give me your collation name of the Instance and Database)
2. Check, Your table belongs to which owner ?
3. Is it throwing any Err message in Server ?

Kindly confirm and give me the data listed above...with Stored procedure script !

Cheers
www.sqlserverbuddy.blogspot.com


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response