Network Today Database Tutorials

I often get request from blog reader for T-SQL script to rename database table column name or rename table itself. The script for renaming any column : sp_RENAME ‘TableName.[OldColumnName]‘ , ‘[NewColumnName]‘, ‘COLUMN’ The script for renaming any object (table, sp etc) : sp_RENAME ‘[OldTableName]‘ , ‘[NewTableName]‘ This article demonstrates two examples of renaming database object. [...]

I often get request from blog reader for T-SQL script to rename database table column name or rename table itself. The script for renaming any column : sp_RENAME ‘TableName.[OldColumnName]‘ , ‘[NewColumnName]‘, ‘COLUMN’ The script for renaming any object (table, sp etc) : sp_RENAME ‘[OldTableName]‘ , ‘[NewTableName]‘ This article demonstrates two examples of renaming database object. [...]

Random Number Generator There are many methods to generate random number in SQL Server.