Database, Programming, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Tips, Transact-SQL, tSQL

SQL Server Rounds FLOATS when Casting to VARCHAR

SQL Server
SQL Server

A quirk about converting between the FLOAT and the VARCHAR data types in SQL Server is the unexpected rounding that will happen. This is specific to working with the FLOAT data type, and the rounding will not happen when casting a DECIMAL or an INTEGER. Continue reading “SQL Server Rounds FLOATS when Casting to VARCHAR”

Database, SQL, SQL Server 2005, SQL Server 2008, SQL Tips, System Objects, Transact-SQL, tSQL

Get All Linked Servers Modify Date in SQL Server

Microsof SQL Server
Microsof SQL Server

This is a short post that extends on a concept that I talked about in a previous article about querying linked server information in SQL Servers 2005, 2008, & 2012 using T-SQL.¬†Specifically, I will give an example of how to check the last modified date for each linked server residing on your database server. Continue reading “Get All Linked Servers Modify Date in SQL Server”

Database, Programming, SQL, SQL Server 2005, SQL Server 2008, SQL Tips, System Objects, Transact-SQL, tSQL

T-SQL Programmatically Script Modified Stored Procedures

T-SQL
T-SQL

In this example I will show how to write a T-SQL routine that scripts any stored procedures in your database that have been modified in the past three days. You should, of course, modify this time filter as you see fit.

This T-SQL routine is useful to extend the scripting option built into SQL Server Management Studio, and can be even more useful if you are considering using it programmatically. Continue reading “T-SQL Programmatically Script Modified Stored Procedures”