qq_42899641的博客

SELECT [USERNAME], [USERACCOUNT] , [ROLENAME] = stuff(( SELECT ',' + [ROLENAME] FROM [TEST].[dbo].[T_Role] WHERE [USERACCOUNT] = a.[USERACCOUNT] FOR XML path('') ), 1, 1, '') FROM [TEST].[dbo].[T_Role] a GROUP BY [U.

静态 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Configuration; namespace DAL { public class DB

Sql数据库 delete from 表名; truncate table 表名; drop table tablename select datename(HH,getdate()) drop table WareHouseingInfo CREATE TABLE [dbo].[WareHouseingInfo] ( [ID ]int PRIMARY KEY IDENTITY(1,1),–主键自...