取消数据库大小写区别

取消数据库大小写区别 ÀýÈç,?íTable1ÖеÄÁÐÃûΪCol1,Ôò select col1 from table1 ?í! select Col1 from table1 ?í! select Col1 from Table1 ?Ô! ?Ø?ÕÆóÒµ?ÜÀíÆ???Ö?Áô?éÑ??ÖÎöÆ? 1.?Ï?ªËùÓÐÓësouvenirÊý?Ý?âµÄÁ??ÓÓÃ?? use master declare @dbname varchar(20) set @dbname='souvenir' declare @sql nvarchar(500) declare @spid int set @sql='declare getspid cursor for select spid from sysprocesses where dbid=db_id('''+@dbname+''')' exec (@sql) open getspid fetch next from getspid into @spid while @@fetch_status < >-1 begin exec('kill '+@spid) fetch next from getspid into @spid end close getspid deallocate getspid 2.ÐÞ?ÄÊý?Ý?âÅÅÐò?æÔò ??Çø?Ö?óÐ?Ð? ALTER DATABASE DB_name COLLATE Chinese_PRC_CI_AS Çø?Ö?óÐ?Ð? ALTER DATABASE DB_name COLLATE Chinese_PRC_CS_AS