Search - Joel Lipman .Com

1. T-SQL: Parse an XML value: / Transact-SQL /; ... node -- returns STAFF SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*') AS r(c) ) AS RootParent FROM [dbo].[XML_EVENTS] -- to get name of immediate ...; Created on 27 March 2014
2. DataTumble - Randomize Data Rows: / Transact-SQL /; ... DECLARE @UpdateData VARCHAR(MAX) DECLARE @Chosen BIT DECLARE @ChosenID INT DECLARE @SqlStatement NVARCHAR(MAX) DECLARE @UpdateSqlStatement NVARCHAR(MAX) DECLARE ...; Created on 07 December 2012
3. Search a database with SOUNDEX: / Databases /; ... ** ** WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** ** To: ...; Created on 11 October 2012
4. Search a database for a string (MySQL, T-SQL): / Databases /; ... You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE ...; Created on 08 October 2012
5. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN ...; Created on 03 August 2012
6. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
7. The ReportServer Database: / Databases /; ... as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...; Created on 08 August 2011
8. Parameters not being used in report processing: / SQL Server Reporting Services /; ... varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate datetime, @specifiedCampus varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET ...; Created on 07 January 2011