Tag: database

Per duplicare una tabella eseguire questi due comandi:

mv /var/lib/rpm/__db* /tmp/ rpm --rebuilddb yum clean all

Connettersi al db con l’utente root e lanciare il seguente comando: SET GLOBAL general_log = ‘OFF’; Riavviare il servizio 

DECLARE @tableSchema VARCHAR(5) = 'dbo' DECLARE @dbName VARCHAR(50) = 'TEST' SELECT CONCAT('USE [', @dbName, ']') AS Obj2Drop UNION SELECT CONCAT('DROP TABLE [', TABLE_NAME, ']') AS Obj2Drop ---TABLES--- FROM information_schema.tables WHERE…

---SQL Server 2008--- IF OBJECT_ID(N'[dbo].[nome_stored]', N'P') IS NOT NULL DROP PROCEDURE [dbo].[nome_stored] GO ---SQL Server 2008 R2--- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('[dbo].[nome_stored]') AND type in…

USE MASTER GO ALTER DATABASE DatabaseName MODIFY FILE (NAME = 'LogicalName_Data', NEWNAME='NEWLogicalName_Data') GO ALTER DATABASE DatabaseName MODIFY FILE (NAME = 'LogicalName_Log', NEWNAME='NEWLogicalName_Log') GO

ALTER DATABASE 'NomeDatabase' SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE 'NomeDatabase' SET MULTI_USER WITH ROLLBACK IMMEDIATE;

EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE GO DECLARE @Command VARCHAR(1000) SET @Command = 'dir c:\*.txt /b /s' DECLARE @FilesInAFolder TABLE (FileNamesWithFolder…

SELECT Name, CASE WHEN Type = 'U' THEN 'Table' ELSE 'View' END AS 'Type', Create_Date, Modify_Date FROM SYS.OBJECTS WHERE TYPE IN (N'U', N'V') ORDER BY Name ASC

SELECT co.Column_Name AS 'Name' ,co.Data_Type AS 'Type' ,ISNULL(co.Character_Maximum_Length, 0) AS 'Lenght' ,CASE WHEN co.Data_Type='Bit' AND NOT co.Column_Default IS NULL THEN CASE WHEN REPLACE(REPLACE(REPLACE(ISNULL(co.Column_Default,''),'(',''),')',''),'''','') = 0 THEN 'False' ELSE 'True' END…