Technical Article

scrript to convert datatypes of multiple columns

generates an runs a select statement to convert all th olumns of a certain datatype in apirticular table to another datatype:eg all columns of type int to varchar etc the sp takes three parameters namely the table name, source data type and detination data type generates a select query ad executes it eg: exec ConvertTableTypes […]

2007-07-10 (first published: )

161 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Returning To An Employer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Returning To An Employer

SQL Server Collation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Collation

Replace calendar table multiplier column with date logic

By Chrissy321

Hello All, It's been a while. See the DDL/DML. I have a multiplier field...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers