Download Windows Server 2012TechNet Gallery - resources for IT professionals
Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by:
|
This article is about multiple ways of splitting a column with delimited string into multiple columns .If the number of delimiters are 3 or less than that then PARSENAME function can be used to Split a column with delimited string into multiple columns like shown below : To make
|
(4)
Updated 8/3/2013
Released 8/3/2013
300
Downloads
|
|
|
This code will work from SQL Server 2005 and above version . PARSENAME function is the key behind this code.I have developed this code to answer the MSDN forumn thread - http://social.m
|
(2)
Updated 7/27/2013
Released 5/4/2013
295
Downloads
|
|
|
If the requirement is to import/shred XML from XML file placed in a folder into table , then this can be done by creating stored procedure using XQUERY & OPENROWSET .If multiple XML files are placed in a folder then it is better to use SSIS - ForEach Loop container to capture lis
|
(0)
Updated 6/21/2013
Released 6/21/2013
132
Downloads
|
|
|
In SQL Server , we can generate Index script in the following ways :1.) Under Object Explorer -> Databases -> Database -> Tables - > Indexes -> right-click on index - > Create Script as ..2.) Using Generate SQL Server Scripts Wizard - > setting Script Indexes to True 3.) Using In
|
(2)
Updated 9/7/2013
Released 9/7/2013
117
Downloads
|
|
|
Consider below scenario :Table 1:DEPARTMENTEMP
|
(2)
Updated 9/14/2013
Released 9/14/2013
59
Downloads
|
|
|
This article is about the example on T-SQL Script to compare two tables definition / metadata in different databases .The T-SQL Script [used to compare two tables definition / metadata in different databases] in this article can be used from SQL Server 2012 and above version bec
|
(0)
Updated 8/11/2013
Released 8/11/2013
67
Downloads
|
|
|
This article is about the example on T-SQL Script to check the syntax of dynamic SQL before execution.The T-SQL Script [used to check the syntax of dynamic SQL before execution] in this article can be used from SQL Server 2012 and above version because I have used the function s
|
(0)
Updated 8/12/2013
Released 8/11/2013
49
Downloads
|
|
|
This article is about the script which I wrote to get detailed information about Index settings . The script in this article does not shows any information about missing indexes or index usage details , the script will show only the information about settings made on an Index usi
|
(0)
Updated 9/7/2013
Released 9/7/2013
74
Downloads
|
|
|
This article shares the information on how to compare two versions of the same report .Sometimes we might be in a need to compare the changes in two versions of the same report.We can observe the changes easily on the report if it is a color modification or something like this, W
|
(0)
Updated 9/8/2013
Released 9/8/2013
72
Downloads
|
|
|
This article is about an example for inserting rows repeatedly based on particular count . I haven't come across this scenario but after seeing this question on MSDN forumn , I wrote this script .Example :Consider if we have sample data like shown below :IdDescriptions
|
(0)
Updated 8/25/2013
Released 8/25/2013
54
Downloads
|
|