将代码上传到服务器时出现问题 [英] issue while uploading code to server

问题描述

亲爱的所有人，

我有一个存储过程，该过程在本地主机上运行良好，但没有放到服务器中.
我注意到的问题是我有一个名为"type"的表，但是当它在存储过程中写入时，所有小字符都像TYPE一样变为大写，表示存在内置类型.它在本地主机上的工作可能不区分大小写.它是一个主表，我无法在任何其他解决方案(例如添加任何功能以使其成为我们的原始表名)的任何地方更改名称.
请快速回复
预先感谢

Dear all,

I have a stored procedure which works well in local host but didn''t get out put in server.
The problem i notice is that 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 local host 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

推荐答案

您总是可以用[]包裹类型，例如[type]，以避免内建和自定义之间发生冲突.

You could always wrap type with [] like [type], To avoid conflict between inbuilt and custom.

这篇关于将代码上传到服务器时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！