wiki.borovicka.name

programming:mssql:explodedates

Tomas Borovicka — 2015-09-07T11:00:04+02:00

ExplodeDate * function, which returns days between given range as a table, * uses CTE, no additional tables needed Sql statetement WITH DatesTable AS ( SELECT CONVERT(datetime,'2015-01-01') AS [Date] UNION ALL SELECT DATEADD(DAY,1,[Date]) FROM DatesTable WHERE DATEADD(DAY,1,[Date]) <= CONVERT(datetime,'2015-09-01') ) SELECT [Date] FROM DatesTable OPTION (MAXRECURSION 1000);

programming:powershell:mssqlexport2csv

Tomas Borovicka — 2015-04-25T22:54:28+02:00

Export data from MSSQL to csv with Powershell * Useful when you need to export data from MSSQL into csv with a script. * At first you need to add sql server snapin. add-pssnapin sqlserverprovidersnapin100 add-pssnapin sqlservercmdletsnapin100

programming:powershell

Tomas Borovicka — 2015-04-25T22:47:42+02:00

PowerShell * Run executable * Kill process if running * Export from MSSQL to csv * Execute MSSQL stored procedure

programming:mssql:getdateonly

Tomas Borovicka — 2015-03-22T18:00:47+02:00

MSSQL GetDateOnly * Function returns date part of the datetime. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: Tomas Borovicka -- Create date: 14.4.2009 -- Description: -- ============================================= ALTER FUNCTION [dbo].[GetDateOnly](@date DATETIME) RETURNS DATETIME AS BEGIN RETURN CONVERT(datetime,CONVERT(VARCHAR(25), @date, 104),104) END

programming:mssql:setidentity

Tomas Borovicka — 2014-12-21T23:31:51+02:00

SET IDENTITY * Allows explicit values to be inserted into the column with the identity property. SET IDENTITY_INSERT SomeTable OFF GO INSERT INTO SomeTable(IdentityColumn) VALUES(1) GO SET IDENTITY_INSERT SomeTable OFF

programming:mssql

Tomas Borovicka — 2014-12-21T23:25:45+02:00

MSSQL, T-SQL Functions * LPAD * Split * GetDateonly * Running processes and kill * Import data from excel * ExplodeDates - returns days in the given range as a table * Column to CSV Features and techniques * Techniky T-SQL * Novinky MSSQL 2008 * Test connection * Close connections * Common Table Expression * Shrink DB * Synchronize tables * SET IDENTITY * Reset identity * Disable printing number of affected rows * Fast COUNT * Reading CSV files * * …

sidebar

Tomas Borovicka — 2014-10-28T11:19:18+02:00

Navigation Programming C / C++ Python C# Scala PowerShell HTML, CSS, JavaScript MSSQL MATLAB MarkTime Latex Other tricks Utilities School Rozvrhy FIT FBMI FEL Links * Computational Intelligence Group * Data Science Laboratory at FIT Other playground syntax

school:fit:minur:semestralwork

Tomas Borovicka — 2014-10-28T11:13:29+02:00

MI-NUR Semestrální práce Projekt Irmon - monitoring insolvenčního rejstříku Tým * Tomáš Borovička * Ladislav Stára Product statement * IRMON je služba, která poskytuje nepřetržitý monitoring subjektů v insolvenčním rejstříku.

programming:mssql:testconnection

Tomas Borovicka — 2014-10-26T23:32:10+02:00

Test connection to MSSQL server * Simply create an empty file with UDL extension, for example “Test_MSSQL_Connection.UDL” . * Double-click the file, SQL connectivity window should pop up. * Then you can test your connection to MSSQL server.

programming:mssql:sqlconnectivitywindow.png

Tomas Borovicka — 2014-10-26T23:30:43+02:00

school:fit:mirun:minur_borovto1_hublales.zip

Tomas Borovicka — 2012-02-27T23:58:09+02:00

school:fit:miric:jaramipaa:u5_jaroslav_fibichr_2011.zip

Jara Fibichr — 2012-02-22T11:16:28+02:00

school:fit:miric:jaramipaa:56e.png