uliasz.com

Just another WordPress site

Uncategorized

T-SQL Tricks

Few useful SQL tricks: Move table to different schema ALTER SCHEMA targetSchema TRANSFER sourceSchema.tableName Rename object sp_rename ‘schemaName.tableName.columnName’, ‘newColumnName’

How to close all connections to a MSSQL database

This script closes all connections to MS SQL database USE master; GO ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE dbName SET MULTI_USER; GO

Hello world!

Welcome to my technical blog, This is a very first post here (and I really hope not the last one). Being in IT industry for a few years now, I realise more and more everyday that having good…

Categories

Tags

.NET Ajax ASP.NET ASP.NET MVC C# CTE Entity Framework git JavaScript jQuery SQL SQL Server T-SQL Unit Testing WCF Web Services XAML XML