DotNetShoutout

TSQL

6
Shouts

Shout it

Fun with dot - Madhivanan's TSQL Blog

published 1033 days, 16 hours, 27 minutes ago posted by

jacobsebastian 1035 days, 18 hours, 4 minutes ago

SQL Server MVP Madhivanan comes up with several interesting points about the usage of the dot operator in TSQL. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: TSQL

8
Shouts

Shout it

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them - TSQL Challenges

published 1035 days, 15 hours, 1 minute ago posted by

jacobsebastian 1036 days, 3 hours, 5 minutes ago

This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, Puzzle, TSQL, challenge

6
Shouts

Shout it

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log - TSQL Challenges for Beginners

posted by

jacobsebastian 1044 days, 22 hours, 58 minutes ago

This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: challenges, TSQL, puzzles, SQLServer, challenge

8
Shouts

Shout it

Export all table data to Text file - Madhivanan's TSQL Blog

published 1046 days, 16 hours, 37 minutes ago posted by

jacobsebastian 1047 days, 1 hour, 4 minutes ago

One of my friends asked me if it is possible to export each table's data to each text file so that those files can be used in another system for data import? The point is he wanted to move database from SQL Server to Mysql. But there was not possible to have a connectivity between the two systems. He generated the script but exporting data was the problem. I suggested him to run this script that will take all userdefined table's data to each file where filename is the table name itself (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: TSQL, scripts, export data, SQLServer, export

7
Shouts

Shout it

Using a UDF as a SARG. Make a hash of it! - Dave Ballantyne's Blog

published 1047 days, 16 hours, 41 minutes ago posted by

jacobsebastian 1048 days, 23 hours, 30 minutes ago

The evils and inadequacies of UDF (User Defined Functions) in SqlServer are well documented, but there is another scenario using UDF’s that will cause a lot of pain if not carefully controlled. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: UDF, TSQL, Performance, SQLServer, query plan

8
Shouts

Shout it

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery - Jacob's Blog

published 1048 days, 16 hours, 52 minutes ago posted by

jacobsebastian 1049 days, 22 hours, 4 minutes ago

This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: xquery, XML, TSQL, SQLServer

4
Shouts

Shout it

XQuery Lab 61 – Writing a Recursive CTE to process an XML document - Jacob's Blog

published 1053 days, 16 hours, 40 minutes ago posted by

jacobsebastian 1053 days, 22 hours, 26 minutes ago

In this XQuery Lab, we will see how to write a recursive CTE to process all the elements and attributes of an XML Document. In XQuery Lab 39, we saw an example that generated the fully qualified path to all the elements and attributes of an XML document using OPENXML(). In this lab, let us look at a new version of the same code using XQuery (instead of OPENXML). (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: xquery, XML, TSQL, SQLServer, xquery labs

6
Shouts

Shout it

Understanding Datetime column - Part IV - Madhivanan's TSQL Blog

posted by

jacobsebastian 1055 days, 1 hour, 17 minutes ago

This post provides a number of best practices for working with DATETIME data types in SQL Server. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: DateTime, data types, TSQL, SQLServer

8
Shouts

Shout it

XQuery Lab 60 – Executing dynamic query strings with OPENXML() - Jacob's Blog

published 1058 days, 18 hours, 18 minutes ago posted by

jacobsebastian 1059 days, 3 hours, 12 minutes ago

This installment of XQuery Lab shows how to execute dynamic queries that contain OPENXML() calls. We will see examples that use EXEC() and sp_executesql. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: xquery, OpenXML, XML, TSQL, SQLServer

6
Shouts

Shout it

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

published 1070 days, 19 hours, 43 minutes ago posted by

jacobsebastian 1071 days, 32 minutes ago

The idea of this challenge is to clean up the phrase from the words identified as noise words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, DBA, Puzzle, TSQL, developer, challenge

8
Shouts

Shout it

T-SQL Enhancements in SQL 2008

published 1073 days, 19 hours, 57 minutes ago posted by

jacobsebastian 1075 days, 20 hours, 31 minutes ago

Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, developer, Database, Programmability

3
Shouts

Shout it

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

posted by

jacobsebastian 1078 days, 1 hour, 26 minutes ago

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, Puzzle, TSQL, developer, Database, challenge

8
Shouts

Shout it

Understanding SQL Server Datetime column - Part II

published 1077 days, 19 hours, 16 minutes ago posted by

jacobsebastian 1078 days, 23 hours, 28 minutes ago

SQL Server MVP, Madhivanan has come up with the second installment of his DateTime tutorial where he explains the problems of using ambiguous date formats. He also demonstrates a number of TSQL datetime processing tricks. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, DateTime, DataTypes, TSQL, Date, time

6
Shouts

Shout it

TSQL Challenge 31 - Managing multiple overlapping date intervals.

published 1082 days, 16 hours, 11 minutes ago posted by

jacobsebastian 1084 days, 21 minutes ago

This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession. Your job is to provide this synthesis using all the other information in that database described below. In particular, we are interested in... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: tsql challenges, TSQL, puzzles, SQLServer

5
Shouts

Shout it

Understanding LINQ to SQL (7) Data Changing - Dixin's Blog

published 1086 days, 19 hours, 46 minutes ago posted by

raju 1088 days, 13 hours, 59 minutes ago

[LINQ via C# series] After understanding how to retrieve data with LINQ to SQL, now take a look at data change (create (insert) / update / delete).Object Identity When changing data queried by LINQ to SQL, one common confusion for LINQ to SQL beginners is the object identity. Identity of entity objects The models working in LINQ to SQL are mappings of SQL Server database stuff, like one .NET entity object in the mummery is the mapping of one record in the database table, etc. Generally speaking, withi... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

tags: .NET, Linq To SQL, C#, LINQ via C# Series, TSQL, Visual Studio, Linq

2
Shouts

Shout it

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

published 1087 days, 19 hours, 53 minutes ago posted by

jacobsebastian 1088 days, 18 hours, 34 minutes ago

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved traversing a hierarchy of employees and rolling a count of orders from subordinates up to superiors. The first concept I shall address is the hierarchyId , which is constructed within the CTE called cteTree. cteTree is a recursive cte that will expand the parent-child hierarchy of the personnel in the table @emp. One useful feature with a recursive cte is that data can be ‘passed’ from the... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: tsql challenges, challenges, TSQL, puzzles, SQLServer

7
Shouts

Shout it

TSQL: Error handling with Try Catch from a .NET perspective « Mehroz’s Experiments

published 1102 days, 18 hours, 13 minutes ago posted by

mehroz 1105 days, 15 hours, 51 minutes ago

Starting with SQL 2005, we can handle unexpected situations in our TSQL scripts/procedures/functions in an structured manner using the famous Try/Catch methodology, similar to what we are used to in our object oriented programming languages (C#, Java, etc). This post will describe certain similarities and how to enjoy the features that look absent at the first look. (more)

category: Data | clicked: 0 | comment | | source: smehrozalam.wordpress.com

tags: finally, Exception Handling, error handling, TSQL, catch, try

4
Shouts

Shout it

outcoldman: Developing web application with time zones support

published 1142 days, 17 hours, 41 minutes ago posted by

http://outcoldman.ru/en/site/index 1144 days, 10 hours, 30 minutes ago

When you develop web application you should know that client PCs can be located anywhere on earth. Even if you develop app just for your country users you should remember it (in Russia now we have 9 time zones, before 28 of March we had 11 time zones). On big sites with many members do it very easy – you can place field “time zone” in member profile, in Sharepoint I saw this solution, and many enterprise app do it like this. But if we have simple website with blog publications or website with news and we... (more)

category: Web Dev | clicked: 0 | comment | | source: outcoldman.ru

tags: TSQL, JavaScript, HTML, Localization, ASP.NET

5
Shouts

Shout it

SQL Server Programming Fundamentals Tutorial

published 1183 days, 10 hours, 48 minutes ago posted by

BlackWasp 1184 days, 7 hours, 14 minutes ago

A 60-part series of articles exploring the fundamentals of programming using Microsoft SQL Server. The tutorial includes explanation of SQL Server and relational database concepts, the creation of databases and the Transact-SQL query language. (more)

category: Data | clicked: 1 | comment | | source: www.blackwasp.co.uk

tags: TSQL, MSSQL, SQLServer

8
Shouts

Shout it

SQL-Articles - Function to Split Comma separated string to Integer

published 1199 days, 19 hours, 6 minutes ago posted by

sqlarticles 1201 days, 15 hours, 5 minutes ago

There are cases where we need to pass the input parameter to the stored procedure as a comma-separated string in order to avoid multiple db calls from happening. This helps in reducing the db calls thereby reducing the load on the db server. The below function will split the given comma-separated string into integers and process the result... (more)

category: Data | clicked: 2 | comment | | source: www.sql-articles.com

tags: TSQL, scripts

Welcome!

TSQL

Fun with dot - Madhivanan's TSQL Blog

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them - TSQL Challenges

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log - TSQL Challenges for Beginners

Export all table data to Text file - Madhivanan's TSQL Blog

Using a UDF as a SARG. Make a hash of it! - Dave Ballantyne's Blog

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery - Jacob's Blog

XQuery Lab 61 – Writing a Recursive CTE to process an XML document - Jacob's Blog

Understanding Datetime column - Part IV - Madhivanan's TSQL Blog

XQuery Lab 60 – Executing dynamic query strings with OPENXML() - Jacob's Blog

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

T-SQL Enhancements in SQL 2008

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

Understanding SQL Server Datetime column - Part II

TSQL Challenge 31 - Managing multiple overlapping date intervals.

Understanding LINQ to SQL (7) Data Changing - Dixin's Blog

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

TSQL: Error handling with Try Catch from a .NET perspective « Mehroz’s Experiments

outcoldman: Developing web application with time zones support

SQL Server Programming Fundamentals Tutorial

SQL-Articles - Function to Split Comma separated string to Integer

Open ID Login

Standard Login

Forgot Password?

Sign up