select col1 collate SQL_Latin1_General_CP1_CI_AS from YourTable1
union
select col2 collate SQL_Latin1_General_CP1_CI_AS from YourTable2

-- This command connects you to the database server. You will need to replace the 
-- "(local)\SQLEXPRESS" with the correct server name (or log on the server and run 
-- the commands from there). Alternatively, you can connect to the server using
-- SQL Server Management Studio.
sqlcmd -s (local)\SQLEXPRESS 

-- Look up the collation property of the Database. They probably found that it is
-- SQL_Latin1_General_CP1_CI_AS
SELECT DATABASEPROPERTYEX('AADHAARMasterData', 'Collation') SQLCollation
go

-- Look up the collation for each column in the 'RC_VTC' table. They probably found that
-- the collation of all columns is the same as that of the database.
SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC')
go

-- Look up the collation for each column in the 'RC_VTC_Add' table. They probably found that
-- the collation of six columns is different from the collation of the database.
SELECT name, collation_name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'RC_VTC_Add')
go

-- The six alter table statements below changes the collation of each of those
-- columns to match that of the database.
ALTER TABLE RC_VTC_Add ALTER COLUMN Id int COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN State_Code varchar(5) SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN District_Code varchar(7) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Code varchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN VTC_Name varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER TABLE RC_VTC_Add ALTER COLUMN Pincode varchar(6) COLLATE SQL_Latin1_General_CP1_CI_AS
go

quote:

---

Originally posted by tk.pal

Aadhaar software problem, export time hang my aadhaar software .No virus detected my computer. Pls help me ...


English week so problem not understood to u .




Team viewer connecting Perpose
India 09832671771

Thank you


T.Pal

---