If I have an autoincrement column (is identity) the import/export wizard raise an error.

.... It's not good what you are telling me....

In what case it's reasonable to use cursors?

My table contains varchar(50) and int columns. For each row I need to verify the...

The result is that I want, but the solution "from sys.columns ,sys.tables"... very...

set nocount on

DROP TABLE #Tab1

CREATE TABLE #Tab1 ([Cpt] [varchar](50) COLLATE Cyrillic_General_CI_AS NULL)

INSERT INTO #Tab1 ([Cpt]) VALUES('2')

INSERT INTO #Tab1 ([Cpt]) VALUES('235')

INSERT INTO #Tab1 ([Cpt]) VALUES('234')

INSERT...

I have a solution but i don't like it (my 2 tables are very big)

SELECT SUBSTRING(Tab2.Tel, 1, 2) AS tel, COUNT(Tab2.total) AS total

FROM ...

Sorry, i wanted to simplify the question, but it didn't work :D.

Let try from the beginning:

Hi!

I have 2 tables:

CREATE TABLE [dbo].[Tab1](

[Cpt] [varchar](50)...

2005

The biggest incovinience is that my tab1 has 1.5 milion rows and tab2 has 1000 rows. I think this joins will take too much time. I would like to use...

I find the answer:

EXEC@err = sp_OAMethod @sh,'sqrtFunc',@ret OUT,@i

I solved the problem with mssoapinit (changigd the binding type), but can you tall me how to call a method. I have on my web service this operation:

public int sqrtFunc(int...

My web services in on WCF, in .net.

I tried:

DECLARE @err varbinary

,@sh int-- SOAP handle

,@ret varchar(8000)

,@msg varchar(32)

SELECT @msg = 'sp_OACreate'

EXEC @err = sp_OACreate 'MSSOAP.SoapClient30', @sh OUT

exec @err=sp_OASetProperty...