Članci u ovoj kategoriji: CHECKCONSTRAINTS This command can be run as follows: Rebuild all indexes on all tables (see attachment) DECLARE @Database Brzo kreiranje tabele i kolona Brzo kreiranje tabele i kolona DateTime u ISO 8601 Opcija 1: CONVERT sa stilom 126 (ISO 8601 bez vremenske zone) Na neke M2 i NVMe diskove greska kod instalacije sql-servera REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f JMBG DECLARE @JMBG VARCHAR(13) = '1506993501234'; Broj zapisa u tabelama (broj zapisa) if object_id('_tabele') is nullbegincreate table _tabele Broj zapisa u tabelama MB SELECTt.NAME AS TableName, Dodjeljivanje statusa u vd insert into tPA_SetDocTypeStat (acDocType, acStatus, acVerified, acName)select g.acDocType, 'N', 'F', 'Nepotvrđen'from tPA_SetDocType gleft join tPA_SetDo Query html for sent mail DECLARE @html nvarchar(MAX); EXEC spQue Send email from sqlexpress EXECUTE msdb.dbo.sysmail_add_account_sp --sysmail_add_account_sp --sysmail_update_account_sp@account_name = 'eDoc', Kill users sesion DECLARE @sqlstring NVARCHAR(max)='' Lista tabela i broj zapisa SELECT o.name,ddps.row_count drop all fk Set NoCount ON Declare @schemaName varchar( drop all fk Set NoCount ON Declare @schemaName varchar(200)set @schemaName=''Declare @constraintName varchar(200)set @constraintName=''Decla enable/disable constraint all -- Disable all the constraint in databaseEXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" -- Enable all the SPID and time execution select P.spi Brisanje tHE_SetSubj set nocount on declare @nesto char (30)declare xPoz cursor local fast_forward forselect acSubject from tHE_SetSubj where acSubject <> Database space and logical files destination EXEC sp_helpdb N'Baza55'; EXEC sp_databases; Brise ENTER iz kolone REPLACE(REPLACE(@str, CHAR(13), List tables with row count SELECTQUOTENAME prenos podataka izmedju baza declare @s varchar(max),@ss varchar(max),@k varchar(max),@kk varchar(max),@t char (80),@nesto char (80),@tsql varchar(max),@db_from char (80),@db_to char (80) Brise ENTER REPLACE(REPLACE(acName,char(10),''),char(13),'') SPID, runing process selectP.spid Brisanje velikih tabela use Bazago declare @i int, @m intset @m = (select count(*) from tHE_Move)set @m = @m / 1000 + 5set @i = 0while @i <= @m Brzo kreiranje liste kolona neke tabele declare @s varchar(max) Create sql user from query create login [xx] with password =N'xx', default_database = datalablt_etn, check_expiration=off, check_policy=off exec master..sp_addsrvrolemember @login Backup po danima za sve baze declare @cBaza varchar (1000) declare @cPut varchar (1000) declare btsPoz cursor local fast_forward for select name from sysdatabases where name not in ('master','model','tempdb','msdb') open btsPo... Brisanje referencijalnog integriteta DECLARE @database nvarchar(50)DECLARE @table nvarchar(50) set @database = ‘DataLab’ — UNIJETI NAZIV BAZEset @table = ‘tHE_SetItem’ — NAZIV T Primjer kurzora declare xPoz cursor local fast_forward for Check is linked server visible declare @srvr nvarchar(128), @retval int; Loop declare @index integer set @index = 0while @index < 10beginselect ‘loop counter = ‘, @indexset @index = @index + 1end Zaokruzenje na 5pf Floor((round(m.anWSPrice - m.anWSPrice * @p /100,2) / 0.05) + 0.5) * 0.05 * 1 db Suspect ALTER DATABAS DB SET EMERGENCYALTER DATABAS DB SET SINGLE_USERDBCC CHECKDB (emergencydemo, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS verzija sql-a i lokacije datoteka SELECT SERVERPROPERTY('ProductVersion') AS [Version] SELECT name, physical_name AS current_file_locationFROM sys.master_files Truncate LOG file USE masterGO Backup and restore select Namefrom sys.database_filesgo backup database fiscalpos to disk = 'C:\fiscalData\fp.bak'go Attach Database EXEC sp_attach_db @dbname = 'db', Row Number ROW_NUMBER() OVER(ORDER BY UserId) Datum bez vremena DATEADD(day, DATEDIFF(day, 0, Split Split Index rebuild DECLARE @Database NVARCHAR(255) DECLARE @Table NVARCHAR(255) DECLARE @cmd NVARCHAR(1000) DECLARE DatabaseCursor CURSOR READ_ONLY FOR SELECT name FROM master.sys.databases WHERE name NOT ... Backup svih baza - full declare @cBaza varchar (1000)declare btsPoz cursor local fast_forward for select name from sysdatabases where name not in ('master','tempdb','model','msdb') open btsPoz za sumarnu sync ispraviti kod pog.nivelacija tsql1.txt Create existing table sql script DECLARE @object_name SYSNAME Lista baza i automatski attach SELECT d.name AS 'Database', m.physical_name as mdf, x.physical_name as ldf into baze FROM sys.master_files m inner JOIN sys.databases d ON d.database_id = m.database_id and m.type_desc = 'ROWS' inner... Lokacija sql baza na disku SELECT db.name AS DBName, type_desc AS FileType, Physical_Name AS LocationFROM sys.master_files mfINNER JOIN sys.databases db ON db.database_id = mf.database_id Index Rebuild DECLARE @Database Datumi NowDATEADD(dd, 0 ALTER AUTHORIZATION ON DATABASE declare @sql varchar (max), @db char (30) declare xPoz cursor local fast_forward for select name from sysdatabases where name not in ('master','tempdb','model','msdb') open xPoz fetch from xPoz into... Funkcija, vraca samo brojeve Funkcija, vraca samo brojeve Izvuce iz Json-a samo određeno polje DECLARE @jsonInfo NVARCHAR(MAX) DECLARE @town NVARCHAR(32)