Learn more about SQL Server tools

   
   






































Functions - System Tips

All Tips
  Different ways to get random data for SQL Server data sampling
  Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server
Aggregate
  SQL Server TSQL Aggregate Functions
Concatentation
  Concatenate SQL Server Columns into a String with CONCAT()
  Using SQL Server Concatenation Efficiently
Conversions
  Concatenation of Different SQL Server Data Types
  New Data Type Conversion Functions in SQL Server 2012
Date Range
  SQL Servers Lag and Lead Functions to Help Identify Date Differences
Logical
  New Logical Functions in SQL Server 2012 (IIF and CHOOSE)
Meta Data
  Getting SQL Server Metadata With Python
Monitoring
  SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
Numbers
  SQL Server Rounding Functions - Round, Ceiling and Floor
Random Data
  Randomly Retrieve SQL Server Records
  Retrieving random data from SQL Server with TABLESAMPLE
Ranking
  Calculate the Statistical Mode in SQL Server using T-SQL
  Forgotten SQL Server Functions - VARP, SOUNDEX and NTILE
  Percent_Rank and Cume_Dist functions in SQL Server 2012
  SQL Server 2005 and 2008 Ranking Functions DENSE_RANK and NTILE
  SQL Server 2005 and 2008 Ranking Functions Row_Number and Rank
  SQL Server 2012 Analytical Functions - Percentile_Cont and Percentile_Disc
  SQL Server 2012 Functions - First_Value and Last_Value
  SQL Server 2012 Functions - Lead and Lag
Result Set
  Dynamically controlling the number of rows affected by a SQL Server query
Strings
  Deciding between COALESCE and ISNULL in SQL Server
  Name Parsing for Result Sets with Different Name Formats
  Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL
  Name Parsing with SQL Server Functions and T-SQL Programming
  New FORMAT and CONCAT Functions in SQL Server 2012
  Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions
  SQL Server Text Data Manipulation
  The Many Uses of Coalesce in SQL Server
System
  CHECKSUM Functions in SQL Server 2005
  SQL Server 2008 Functions for Tables, Views, Indexes, Columns, Stored Procedures
  Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema name
  Using the SQL Server APP_NAME function to control stored procedure execution

 
Sponsor Information







 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.