摘要:
try { using (MySqlConnection conn = new MySqlConnection("Database=Database;Data Source=127.0.0.1;User Id=root;Password=123456;pooling=false;CharSet=utf8")) ... 阅读全文
摘要:
USE MASTER GO DECLARE @dbname SYSNAME SET @dbname = 'EducationManagementSystem' -- 这个是要删除的数据库库名 DECLARE @s NVARCHAR( 1000) DECLARE tb CURSOR LOCAL FOR SELECT s = 'kill ' + CAST( spid... 阅读全文
摘要:
1 SELECT 2 HOUR (时间) AS HOUR, 3 COUNT( 4 CASE 5 WHEN orderlist.State = 1 THEN 6 orderlist.State 7 END 8 ) AS suCount, 9 COUNT( 10 CASE 11 WHEN orderli 阅读全文