Viewing 7 posts - 1 through 7 (of 7 total)
This is SQL Forum, so put your political frustrations somewhere else.
Windows Cyrillic, Code Page 1251 contains MACEDONIAN letters DIFFERENT than GREEK letters
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2e95.asp
August 4, 2005 at 4:19 am
In fact using sp_OACreate and its sp_OA*** brothers
can be very dangerous.
The second argument that you can use against your developers,
is that in YUKON sp_OA*** procedures will not exist.
I'm developer so...
September 25, 2003 at 2:02 am
You can see Sql books online, there is some examples like this:
Use WHERE and LIKE syntax with Unicode data
This example uses the WHERE clause to retrieve the contact name, telephone,...
September 25, 2003 at 1:29 am
Use OSQL Utility
DECLARE @CurrentDate VARCHAR(8) -- YYYYMMDD
DECLARE @cmd VARCHAR(256)
SET @CurrentDate = CONVERT(VARCHAR(8),DATEADD(DAY,0,GETDATE()),112)
SET @cmd =
'osql -E -SSrvName -Q "EXEC "DB..Proc" -o c:\OutFile' PLUS @CurrentDate PLUS '.txt'
EXEC ...
September 23, 2003 at 3:47 am
You can use SQLXMLBulkLoad (SQLXML3.0 SP1) in this way
first you have to create table
Customer (CustomerId int,CompanyName varchar,City varchar)
Insertcustomers.vbs -- vb script
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objBL.ConnectionString = "provider=SQLOLEDB.1;data source=MyServer;database=MyDatabase;uid=sa;pwd=pass"
objBL.ErrorLogFile =...
September 19, 2003 at 1:09 am
You can use SQLXMLBulkLoad (SQLXML3.0 SP1) in this way
first you have to create table
Customer (CustomerId int,CompanyName varchar,City varchar)
Insertcustomers.vbs -- vb script
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objBL.ConnectionString = "provider=SQLOLEDB.1;data source=MyServer;database=MyDatabase;uid=sa;pwd=pass"
objBL.ErrorLogFile =...
September 19, 2003 at 1:02 am
Nice Thing
This is similar procedure for starting trace
that I'm using in daily processing.
CREATE PROCEDURE sp_startTrace
AS
DECLARE @TraceIdOut INT
DECLARE @FolderTracenvarchar(128)
DECLARE @FileTraceLikenvarchar(128)
DECLARE @FileTracenvarchar(128)
SELECT @FolderTrace = 'C:\FolderTrace\'
SET @FileTraceLike = @FolderTrace + 'Trace%'
IF
(select count(*)...
September 16, 2003 at 4:30 am
Viewing 7 posts - 1 through 7 (of 7 total)