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 […]

You rated this post out of 5. Change rating

2007-07-10 (first published: )

164 reads

Blogs

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Friday Flyway Tips–Flyway Parameters

By

Flyway is a command line tool with lots of options and parameters. Working with...

Read the latest Blogs

Forums

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Migration from Sybase SAP SQL Anywhere to SQL Server 2022

By Stewart "Arturius" Campbell

We are working on a project to migrate a client from a version of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers