sqlserver005,SQLserver2005

oracle转sqlserver 语法问题

用case when 慢慢写

'1110630' +

case b.wdh when '00' then '0201'

when '02' then '0301'

when '03' then '0401'

...

else '0101' end

+ '00000000' as P005

相关问答

Q1: SqlServer2005交叉表查询问题

DECLARE @str as nVARCHAR(max)

set @str='yyq,'

select @str=@str+''''+fkmc+''''+'=sum(case fkmc when

'+''''+fkmc+''''+' then fk else null end),'

from hb group by fkmc

set @str='select '+substring(@str,1,len(@str)-1)+',sum(fk) as 合计 from hb group by yyq'

print @str

exec(@str)

你这样写，我执行了一下是可以的，除了数据为空时，其他都可以的

Q2: 求毕业论文摘要英文翻译 ！！ 谢谢

International logistics has become an important part of economic system. Modern logistics is the result of economic globalization, but also promote the economic globalization is an important services. Logistics enterprise to improve the competitiveness of enterprise informatization construction, there is the road. Modern logistics management system including single business management, scheduling up business management, transportation business management, inventory management, personnel management. Business management and operation in the whole logistics management system in control.

In business for scheduling, inventory management workload big technical problems, we design and implement inventory management system. This system is running on Windows platforms, using J2EE platform development, with high throughput and scalability of the system, the system can adapt to a larger scale of operations and future development. And in the business can provide complex function at the same time, still can provide simple and intuitive operating mode and the page.

The main content of this article for:

First, introduces the research background, and modern logistics system, analyses the development status of modern logistics system of inventory management system.

Second, introduces MVC design patterns, currently using frame of Struts J2EE technology and SQL Server database in the use and development of 2005.

Third, according to the pattern design, design MVC dispatching business module of inventory management subsystem,

Fourth, using J2EE technology and SQL Server 2005 database, realizes the inventory management subsystem according to the following functions: single information retrieval outbound request form, According to the state Treasury information retrieval request list, According to the state information retrieval transport request list, Searching out the corresponding information warehouse inventory goods, The outbound transportation and request for review.

Added:

This system USES B/S model design, use Java, JavaScript as the application development, using the language Sqlserver005 create backstage database, making use of graphics software Visio state chart and control flow graph and Jtest use of unit tests, using open-source Bug management tools mantis, submit the related Bug finally formed through the test data, to test for business process.

Q3: 跪求高手解决关于sql2005数据库连接问题java.lang.ClassNotFoundException

加入sql2005的jar包 ;displaylang=zh-cn 下载

在看数据库用户名和密码是否正确

你试试把下载数据库驱动包下的一个.dll文件放在windows目录下的system32还是system下面试试 我以前遇到过这样的问题

Q4: sqlserver dense_rank（）排序问题

那你最好分开写，一个SQL查询不为1的，一个SQL查询为1的，然后Union起来