Hi everyone?
How can i change collation of userdefined datatype?
When i try to change it Management Studio Query
varcharUzun = varchar(100) --> userdefined data type....
ALTER TABLE tbxxxx ALTER COLUMN sDefinition varcharUzun COLLATE Turkish_CI_AS NOT NULL
when i run the query it says...
Hi everyone.
suppose that i have 3 dimensions as.
ProductModel and Color
and SalesFact table.
i want to find the distinct count of ProductModel+Color.
i mean.
Year/ProductModel/Color/Sales
---------------
2006/010101 /White /1.0
2006/010101 /Black /2.0
2007/010101 /White /1.0
2006/010102...
Hi,
I just want to uninstall COM1 or COM2 Commination Device.
I can easily do it by right clicking COM2 and click COM2 from Device Manager.
But i want to do it with VB Script.
I can the read the properties with the code below.
But i want to remove the port????
On Error Resume Next...
Hi All
I have created XML File with XMLDocument in ASP.NET
than i want send or show this file in browser to visitors.
without saving it to disk. How can i do that?
i want to show (MyXML) in explorer. or post it to customers?
Dim dst As DataSet
dst = ReturnDatasetFromSql(db, "Select *...
Hi everyone.
i have a problem isql utility.
My Server : SQLServer2000
xxx.sql example
---------
insert into Table1
select 's', 'Çarsi '
For example this xxx.sql is my sql table.
I have no problem when running isql queries like below.
But when run this query i cant insert the characters like...
Hi every one.
I have to SQLServers in my computer.
First one SQL Server 7.0 (CEM)
Second one SQL Server 2000 (CEM\SQL2)
When use (select @@servername) in sql2000
Result : CEM\SQL2
But When use (select @@servername) in sql7
Result : NULL
There is no problem when i connect Query Analy. Or...
Hello everyone!
I have a database Backup problem
with Win2003 OS + SQLServer 2000
Any Ideas? memory problem or what ?
:((
2003-12-04 13:51:46.68 spid107 BackupMedium::ReportIoError: write failure on backup device 'D:\Winner\Backup\ipek_muh2003'. Operating system error 2(error not found)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.