sql-server

英文: Restore MSSQL backup file 问题 I receive a file like this from my hosting provider when I download...

英文: How do I make this code loop 7 times and go to the next row? 问题 I've been learning SQL by myself...

英文: SQL Sum by Group 问题 我有一个像这样的发票表： 组别 客户 发票金额 组别 1 约翰 250 组别 1 约翰 250 组别 2 黛布拉 250 我想要将报告显示为： 组别 客...

英文: How to get next child of root as the parent via stored procedure? 问题 表 `Label` (IdLabel 整数, IdPa...

英文: select merged column value sql 问题 以下是翻译好的部分： Table Bookings 包含 BookingId 和其他与预订相关的列。 每当预订有更新时，会将...

英文: How to reference SQL columns containing quotes? 问题 I am having trouble referencing the "cur...

英文: How update a table that contains to a single row but is initially set to NULL and return the nex...

英文: MSSQL ORDER BY with OFFSET and FETCH NEXT do not work properly 问题 以下是您要翻译的内容： 我有这个查询： SELECT TOP...

英文: How can I do "double-aggregation" in T-SQL / SQL Server? 问题 I have a table which conta...

英文: Invalid column name with alias and HAVING 问题 我添加了一些列并给它们起了别名。然后我想只显示那些加法结果大于某个特定值的行： SELECT (COA...