Discuz! The NT Forum reported some column problems caused by the @ pigesize variable not being declared ..

Discuz! The open-source forum of NT Version 3.5 had a good chance of changing the host on the previous host, so it was not good for me to get it locally. I was very depressed. In the past two days, the emperor finally found out the reason for the bad case. problem

The final cause is that the variables used in the stored procedure are case-insensitive. Therefore, if the code runs properly locally on another machine, an error will be reported. The root cause is that SQL server is not set. after checking the multi-resource information, you can check whether SQL statements are case sensitive when installing SQL Server.

 

When installing SQL, we can select case-sensitive or recreate mastar after installation, and then select size-sensitive

The following is the path of rebuildm.exe:

C:/program files/Microsoft SQL Server/80/tools/binn/rebuildm.exe

To modify the sorting rule, follow the preceding settings.

If only one table is modified, use the alter table statement.

If you modify the default sorting rules of a database, use the alter database statement.

If you modify the sequence rules of the entire server, use rebuildm.exe to recreate the master database.