<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>VerySource - MS-SQL Server</title>
    <link>https://forum.verysource.com/forum-37-1.html</link>
    <description>Latest 20 threads of MS-SQL Server</description>
    <copyright>Copyright(C) VerySource</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Wed, 15 Apr 2026 12:06:13 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://forum.verysource.com/static/image/common/logo_88_31.gif</url>
      <title>VerySource</title>
      <link>https://forum.verysource.com/</link>
    </image>
    <item>
      <title>ssm停车场管理系统</title>
      <link>https://forum.verysource.com/thread-3888-1-1.html</link>
      <description><![CDATA[今天介绍一个基于SSM+Redis的停车场管理系统，话不多说先看图：
系统有三种权限

用户，管理员，超级管理员。

功能

停车位管理（管理员，超级管理员）

停车卡管理（用户，管理员，超级管理员）-（临时停车，正常卡，月卡，年卡）。有需要的可以修改一下，然后放到red ...]]></description>
      <category>MS-SQL Server</category>
      <author>268410</author>
      <pubDate>Mon, 27 Jun 2022 12:35:05 +0000</pubDate>
    </item>
    <item>
      <title>sql 语法指南</title>
      <link>https://forum.verysource.com/thread-3798-1-1.html</link>
      <description><![CDATA[选择
订购单
通过...分组 
分钟
最大限度]]></description>
      <category>MS-SQL Server</category>
      <author>qinghuaxiong</author>
      <pubDate>Tue, 12 Oct 2021 03:35:27 +0000</pubDate>
    </item>
    <item>
      <title>On the problem of multi-table join query to eliminate duplicate rows</title>
      <link>https://forum.verysource.com/thread-3650-1-1.html</link>
      <description><![CDATA[I have 3 tables, a product table, and 2 different types of classification tables. One is necessary for classification and the other is not necessary. My SQL statement is as follows:

select distinct(int_product_id),str_productCatalog_title,
str_produ .]]></description>
      <category>MS-SQL Server</category>
      <author>wshch0725</author>
      <pubDate>Fri, 12 Mar 2021 02:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Can you use SQL to store a video file</title>
      <link>https://forum.verysource.com/thread-3649-1-1.html</link>
      <description><![CDATA[Can you use SQL to store a video file, if possible, please tell the master about the code, if you want to read out what stream should be used.]]></description>
      <category>MS-SQL Server</category>
      <author>rtyrtyu</author>
      <pubDate>Fri, 12 Mar 2021 01:30:02 +0000</pubDate>
    </item>
    <item>
      <title>Can\'t write select statement in avg aggregate function?</title>
      <link>https://forum.verysource.com/thread-3642-1-1.html</link>
      <description><![CDATA[Like the title, does it have to be listed?]]></description>
      <category>MS-SQL Server</category>
      <author>bellers</author>
      <pubDate>Wed, 10 Mar 2021 05:00:02 +0000</pubDate>
    </item>
    <item>
      <title>SQL statement query maximum problem</title>
      <link>https://forum.verysource.com/thread-3613-1-1.html</link>
      <description><![CDATA[Table RUNCARD has M, N and other fields
The data in M ​​such as M(1)=mm001
             M(2)=mm002
             M(3)=mm003
             ......
    Type varchar
Now I want to make a loop, extract the maximum value from the number part after mm in M, ]]></description>
      <category>MS-SQL Server</category>
      <author>liuwei09314</author>
      <pubDate>Tue, 02 Mar 2021 04:30:01 +0000</pubDate>
    </item>
    <item>
      <title>Accumulate a number every ten seconds</title>
      <link>https://forum.verysource.com/thread-3606-1-1.html</link>
      <description><![CDATA[I need to generate a record from a start time, every time an integer point (for example, 13 o\'clock, 14 o\'clock) is reached, and a record is generated in the table. A field in the record is a field of cumulative numbers, and L is every ten seconds. T ..]]></description>
      <category>MS-SQL Server</category>
      <author>xyhhhh</author>
      <pubDate>Mon, 01 Mar 2021 03:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Table of parent-child structure transformed into a hierarchical Web page</title>
      <link>https://forum.verysource.com/thread-3605-1-1.html</link>
      <description><![CDATA[Now there is such a problem, there is a Table in the database of SQL SERVER

Column A Column B Column C
1 ABC 0
2 BCD 1
3 CDE 1
4 DEF 3
5 EFG 3


If it’s displayed on the Web, it’s a structure like this
ABC BCD
ABC CDE DEF
ABC CDE EFG

How ]]></description>
      <category>MS-SQL Server</category>
      <author>五个蛋</author>
      <pubDate>Mon, 01 Mar 2021 02:30:01 +0000</pubDate>
    </item>
    <item>
      <title>Seeking a basic sql</title>
      <link>https://forum.verysource.com/thread-3568-1-1.html</link>
      <description><![CDATA[table a,b,c


a column da,name in the table
b column in table da,acc
c column acc,je

Among them, column da of table a = column da of table b
acc column of table b = acc column of table c

Want now

a.da,a.name ,sum(c.je) such a result

Such]]></description>
      <category>MS-SQL Server</category>
      <author>xiangjieray</author>
      <pubDate>Thu, 17 Dec 2020 06:30:01 +0000</pubDate>
    </item>
    <item>
      <title>How to take the first line</title>
      <link>https://forum.verysource.com/thread-3559-1-1.html</link>
      <description><![CDATA[The existing SqlServer data table (the table name is TestTable) contains the following three columns
Number Name Other
10000 Beijing, A Dou falls with the wind
10000 Hebei sfsaadf
10000 Shanxi 23424234
10001 Eat with the wind
10001 sleep haha
10005]]></description>
      <category>MS-SQL Server</category>
      <author>maxsteven</author>
      <pubDate>Thu, 17 Dec 2020 02:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Joint inquiry question!</title>
      <link>https://forum.verysource.com/thread-3549-1-1.html</link>
      <description><![CDATA[I am a beginner, and I have come to ask for advice. Urgent!

Two tables about train information
T_Schedule
ScheduleCode varchar(10)
fromCity varchar(20)
toCity varchar(20)
LeaveTime datetime
ArrivalTime datetime
TrainType varchar(10)
Speed ​​var]]></description>
      <category>MS-SQL Server</category>
      <author>youg21</author>
      <pubDate>Wed, 16 Dec 2020 14:00:02 +0000</pubDate>
    </item>
    <item>
      <title>How to get the line number Press 1, 2, 3, 4.... etc.</title>
      <link>https://forum.verysource.com/thread-3547-1-1.html</link>
      <description><![CDATA[The following data table Sql2000 (the table name is TestTable) contains the following three columns
Number Name Other
10000 Beijing, A Dou falls with the wind
10000 Hebei sfsaadf
10000 Shanxi 23424234
10001 Eat with the wind
10001 sleep haha
10005 ]]></description>
      <category>MS-SQL Server</category>
      <author>maxsteven</author>
      <pubDate>Wed, 16 Dec 2020 13:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Looking for a simple trigger, I haven\'t written a trigger before, it should be very simple</title>
      <link>https://forum.verysource.com/thread-3543-1-1.html</link>
      <description><![CDATA[TA
id mtype mk
1 aa 123
2 bb 123

TB
id ntype Status ts
1 aa 0 123
2 bb 1 123
3 bb 0 10


----------------
Find a trigger, when mk in TA is updated, the corresponding ts in TB is also updated.

The condition for triggering TB is ntype=mtype]]></description>
      <category>MS-SQL Server</category>
      <author>lyhtfrykln</author>
      <pubDate>Wed, 16 Dec 2020 11:00:02 +0000</pubDate>
    </item>
    <item>
      <title>How to delete all stored procedures prefixed with \"usp_\" using SQL statements</title>
      <link>https://forum.verysource.com/thread-3537-1-1.html</link>
      <description><![CDATA[I want to delete all stored procedures that start with the prefix USP_. How to write DROP PROCEDURE\'usp_%\' This is a syntax error. How to write it?]]></description>
      <category>MS-SQL Server</category>
      <author>ldqcom3000</author>
      <pubDate>Wed, 16 Dec 2020 08:00:02 +0000</pubDate>
    </item>
    <item>
      <title>I can\'t write such a simple sentence, I\'m depressed</title>
      <link>https://forum.verysource.com/thread-3534-1-1.html</link>
      <description><![CDATA[declare @pagesize varchar(10)-----Display the size of each page of data
declare @pageindex varchar(20)-----current index page
declare @testtime datetime -------Establish test time
select @pagesize=10,@pageindex=9000,@testtime=getdate()

declare @sql ]]></description>
      <category>MS-SQL Server</category>
      <author>8424cyy747</author>
      <pubDate>Wed, 16 Dec 2020 06:30:01 +0000</pubDate>
    </item>
    <item>
      <title>Date conversion problem in sql server</title>
      <link>https://forum.verysource.com/thread-3531-1-1.html</link>
      <description><![CDATA[To develop a database with VC, you need to get the date in two edit boxes, one for the year and the other for the month. For example: 2017 1
To convert the input character into a date type, the code: convert(datetime,\'yyyy-mm\') An error message appea .]]></description>
      <category>MS-SQL Server</category>
      <author>rabbitwcm</author>
      <pubDate>Wed, 16 Dec 2020 05:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Ask for a sql statement</title>
      <link>https://forum.verysource.com/thread-3527-1-1.html</link>
      <description><![CDATA[A varchar field aa of table ttt; its value: 2145, 21235, etc.,
I want to select the value from the 2nd position to the end, such as:
select *... from ttt
 aa
 145
 1234 (Don\'t leave the first ‘2’)]]></description>
      <category>MS-SQL Server</category>
      <author>deejeh</author>
      <pubDate>Wed, 16 Dec 2020 03:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Ask every master a SQL article</title>
      <link>https://forum.verysource.com/thread-3514-1-1.html</link>
      <description><![CDATA[Table as:
id par root
1 0 A
twenty one       
3 1
4 0 ss
5 4 B
6 4
7 2 C
8 2

Use SQL to realize that the root value of par non-zero record is consistent with the root value of id equal to its par.]]></description>
      <category>MS-SQL Server</category>
      <author>对不起谢谢</author>
      <pubDate>Tue, 15 Dec 2020 11:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Ask how to write the date segment SUM</title>
      <link>https://forum.verysource.com/thread-3510-1-1.html</link>
      <description><![CDATA[80 5 2 30 2016-12-02 00:00:00
114 11 4 58 2016-12-03 00:00:00
85 8 1 38 2016-12-04 00:00:00
82 11 1 31 2016-12-05 00:00:00
83 9 0 39 2016-12-06 00:00:00
91 7 2 42 2016-12-07 00:00:00

SELECT SDate,sum(SaleGroup) as SaleGroup,sum(SzG) as SzG FROM db]]></description>
      <category>MS-SQL Server</category>
      <author>skyfly</author>
      <pubDate>Tue, 15 Dec 2020 09:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Study Discussion Post: Design of Financial/Invoicing Software Database</title>
      <link>https://forum.verysource.com/thread-3495-1-1.html</link>
      <description><![CDATA[Now I am designing a small sales software database, and I have encountered some problems. I hope you can take care of it. Pay more attention to this post. I will organize it later to facilitate beginners to learn. Questions will be raised one by one, ...]]></description>
      <category>MS-SQL Server</category>
      <author>shimaly</author>
      <pubDate>Mon, 14 Dec 2020 06:00:01 +0000</pubDate>
    </item>
  </channel>
</rss>