SQLServerCentral: Content tagged t-sql

Content with tag t-sql

<< Previous 20 Items 21 to 40 of 2897 Next 20 >>

REPLICATE - 1

By bitbucket 2013/05/01 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,459 reads

Table Variable

By Sergiy 2013/04/30 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,895 reads

QUERY and TABLE HINTS

By Steven Neumersky 2013/04/29 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,738 reads

Create Table

By Kapil Singh 2013/04/26 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,860 reads

Triggers 2

By Hugo Kornelis 2013/04/25 | Category: triggers

Rating: (not yet rated) |

Discuss |

Briefcase | 1,548 reads

Solving Complex T-SQL Problems, Step-By-Step

What should you do if your first, most intuitive solution to a problem ends up scanning the data more than is necessary, resulting in poor performance? Have you missed a new SQL Server feature that can remove inefficiency from your technique? Alternatively, do you need a little help, and some lateral thinking, to open the path to a different approach? Sometimes, the answer is "both". Read more...

By Additional Articles 2013/04/25 | Source: SimpleTalk | Category: t-sql

Rating: (not yet rated) Rate this |

Briefcase | 5,970 reads

FK to IDENTITY

By Nenad Zivkovic 2013/04/24 | Category: foreign keys (fk)

Rating: (not yet rated) |

Discuss |

Briefcase | 1,755 reads

Nested triggers 1

By Tom Thomson 2013/04/23 | Category: triggers

Rating: (not yet rated) |

Discuss |

Briefcase | 1,472 reads

Using FULL JOINs to Compare Datasets

This article describes a technique of using FULL JOINs to compare two datasets within a numerical tolerance. Read more...

By Mark Murphy 2013/04/23 (first published: 2010/09/27) | Source: SQLServerCentral.com | Category: full join

Rating:

Discuss |

Briefcase | 26,811 reads

Handling NULL

By Kapil Singh 2013/04/22 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,871 reads

Triggers 1

By Hugo Kornelis 2013/04/19 | Category: triggers

Rating: (not yet rated) |

Discuss |

Briefcase | 1,532 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio. Read more...

By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions

Rating:

Discuss |

Briefcase | 9,208 reads

Comparison of Queries Written in T-SQL and SQL Server MDX

Beginning to learn and comprehend SQL Server Analysis Services (SSAS) MDX queries can be difficult after one has spent years writing queries in T-SQL. When trying to write SQL Server MDX queries, it's worth considering "How would I write this query in T-SQL?" Read more...

By Additional Articles 2013/04/19 | Source: MSSQLTips.com | Category: t-sql

Rating:

Rate this |

Briefcase | 3,518 reads

Sum and Count

By G C 2013/04/18 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,003 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL? Read more...

By John Hick 2013/04/18 | Source: SQLServerCentral.com | Category: t-sql

Rating:

Discuss |

Briefcase | 18,345 reads

Row Constructor

By Chirag Patel 2013/04/17 | Category: row constructor

Rating: (not yet rated) |

Discuss |

Briefcase | 1,664 reads

COUNT() Function

By Yogesh Kumar 2013/04/16 | Category: count

Rating: (not yet rated) |

Discuss |

Briefcase | 1,923 reads

SQL Server – Generate Calendar using TSQL

Introduction Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011.... Read more...

By vinaypugalia 2013/04/16 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 5,071 reads

The Cascading (CROSS) APPLY

An old trick nowadays but one which is still underused here on SSC is the cascading CROSS APPLY – where output from one CROSS APPLY is used as input for another. Read more...

By Chris Morris 2013/04/16 | Source: SQLServerCentral.com | Category: t-sql

Rating:

Discuss |

Briefcase | 12,201 reads

T-SQL Coding Style

When you write T-SQL code what kind of coding style do you use? Do you have a consistent way to comment and format your code? Does your organization provide standards for how you must code your T-SQL? Join Greg Larsen as he discusses some of the coding styles you should consider when writing your T-SQL scripts and stored procedures. Read more...

By Additional Articles 2013/04/16 | Source: Database Journal | Category: t-sql

Rating:

Rate this |

Briefcase | 5,556 reads

<< Previous 20 Items 21 to 40 of 2897 Next 20 >>