SELECT a.ID,
DATEADD( s, RAND( CONVERT( INT, CAST( NEWID() AS BINARY(16) ), 1)) * 252460800, '20080101' ) AS dt
FROM
(VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)) AS A (ID)
CROSS JOIN
(VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(11), (12), (13), (14), (15), (16), (17), (18), (19), (20),
(21), (22), (23), (24), (25), (26), (27), (28), (29), (30)) AS B(C)
ORDER BY NEWID()
не могу отсоединить БД,Остановите службу сервера и файлы освободятся.
SELECT main_id AS [Код], 0 AS [Код.Код], 0 AS [Код.Код.Код], name_site AS [Текст]
FROM MainTabMatrix
WHERE name_site = 'Начальник РЭС'
UNION
SELECT MainTabMatrix.main_id, id_taks, 0, NameTask AS [Текст]
FROM MainTabMatrix
JOIN TasksM ON MainTabMatrix.main_id = TasksM.main_id
WHERE name_site = 'Начальник РЭС'
UNION
SELECT MainTabMatrix.main_id, TasksM.id_taks, duties_id, NameDuties AS [Текст]
FROM MainTabMatrix
JOIN TasksM ON MainTabMatrix.main_id = TasksM.main_id
JOIN Duties ON TasksM.id_task = Duties.id_task
WHERE name_site = 'Начальник РЭС'
ORDER BY 1, 2, 3
DECLARE @actionsUsers TABLE ( Пользователь VARCHAR(100), Действие VARCHAR(100), ТипДействия INT )
INSERT @actionsUsers VALUES ( 'Иванов', 'Изменил дату', 1 ),
( 'Петров', 'Добавил запись', 4 ),
( 'Соколов', 'Изменил описание', 2 ),
( 'Иванов', 'Изменил дату', 1 ),
( 'Соколов', 'Изменил заголовок', 3 ),
( 'Соколов', 'Изменил заголовок', 3 )
SELECT [Пользователь],
[Добавил запись], [Изменил дату], [Изменил описание], [Изменил заголовок]
FROM
( SELECT [Пользователь], [Действие]
FROM @actionsUsers ) AS AUC
PIVOT ( COUNT([Действие]) FOR [Действие]
IN ([Добавил запись], [Изменил дату], [Изменил описание], [Изменил заголовок] )) AS PT
ORDER BY [Пользователь]
DECLARE @L VARCHAR(100) = '%Mars%'
DECLARE @TB VARCHAR(100), @CL VARCHAR(100), @Q NVARCHAR(250)
DECLARE @R TABLE ( TableField VARCHAR(100), FieldValue VARCHAR(250) )
DECLARE AllTable CURSOR FOR
SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE LIKE '%char'
OPEN AllTable
FETCH NEXT FROM AllTable INTO @TB, @CL
WHILE @@FETCH_STATUS = 0 BEGIN
SET @Q = 'SELECT ''' + @TB + '.' + @CL + ''', ' + @CL
+ ' FROM ' + @TB + ' WHERE ' + @CL + ' LIKE ''' + @L + ''''
INSERT @R EXECUTE sp_executesql @Q
FETCH NEXT FROM AllTable INTO @TB, @CL
END
CLOSE AllTable
DEALLOCATE AllTable
SELECT * FROM @R
SELECT * FROM HOUSE_HOUSENUM
WHERE UPPER( Name ) = UPPER( '33_а' )
COLLATE
SELECT * FROM HOUSE_HOUSENUM
WHERE Name = '33_а' COLLATE Cyrillic_General_CI_AI