SQLServer2008版本号查询

时间:2020-03-17 22:13来源:计算机教程
本文实例讲述了SQLServer实现将特定字符串拆分并进行插入操作的方法。分享给大家供大家参考,具体如下: SqlServer Management Studio vnsc5858威尼斯城官网,新建查询 select @@version --循环执行

本文实例讲述了SQL Server实现将特定字符串拆分并进行插入操作的方法。分享给大家供大家参考,具体如下:

SqlServer Management Studio
vnsc5858威尼斯城官网,新建查询
select @@version

--循环执行添加操作declare @idx as intWhile Len(@UserList)  0Begin Set @idx = Charindex(',', @UserList); --只有一条数据 If @idx = 0 and Len(@UserList)  0BeginInsert Into BIS_MsgCenterInfo(ID,MsgID,UserID,[State])Values(Newid(),@ID,@UserList,0);Break;End--多条数据 If @idx  1BeginInsert Into BIS_MsgCenterInfo(ID,MsgID,UserID,[State]) Values(Newid(),@ID,left(@UserList, @idx - 1),0);Set @UserList = right(@UserList, Len(@UserList) - @idx);End Else Set @UserList = right(@UserList, Len(@UserList) - @idx);End

10.0.1600.22 SQL Server 2008 RTM

希望本文所述对大家SQL Server数据库程序设计有所帮助。

10.0.1763.0 SQL Server 2008 RTM Cumulative Update 1

10.0.1779.0 SQL Server 2008 RTM Cumulative Update 2

10.0.1787.0 SQL Server 2008 RTM Cumulative Update 3

10.0.1798.0 SQL Server 2008 RTM Cumulative Update 4

10.0.1806.0 SQL Server 2008 RTM Cumulative Update 5

10.0.1812.0 SQL Server 2008 RTM Cumulative Update 6

10.0.1818.0 SQL Server 2008 RTM Cumulative Update 7

10.0.1823.0 SQL Server 2008 RTM Cumulative Update 8

10.0.1828.0 SQL Server 2008 RTM Cumulative Update 9

10.0.1835.0 SQL Server 2008 RTM Cumulative Update 10

10.0.2531.0 SQL Server 2008 SP1

10.0.2710.0 SQL Server 2008 SP1 Cumulative Update 1

10.0.2714.0 SQL Server 2008 SP1 Cumulative Update 2

10.0.2723.0 SQL Server 2008 SP1 Cumulative Update 3

10.0.2734.0 SQL Server 2008 SP1 Cumulative Update 4

10.0.2746.0 SQL Server 2008 SP1 Cumulative Update 5

10.0.2757.0 SQL Server 2008 SP1 Cumulative Update 6

10.0.2766.0 SQL Server 2008 SP1 Cumulative Update 7

10.0.2775.0 SQL Server 2008 SP1 Cumulative Update 8

10.0.2789.0 SQL Server 2008 SP1 Cumulative Update 9

10.0.2799.0 SQL Server 2008 SP1 Cumulative Update 10

10.0.2804.0 SQL Server 2008 SP1 Cumulative Update 11

编辑:计算机教程 本文来源:SQLServer2008版本号查询

关键词: