i re install ssms but the error is exists

I Set the code in side SP And When I Run my code I see this error:

Msg 16958, Level 16, State 3, Line 257

Could not complete cursor operation because the...

I Use this sp but execution time is very high--more than 10 min--

CREATE PROC [dbo].[SearchAllTables2]

(

@SearchStr nvarchar(100)

)

AS

BEGIN

SET @SearchStr...

c# code generates all the words of given length L

The basic problem is this:

Consider the case that we are looking for a particular term, for example, the word network.

A word can be located anywhere, such as the subject and...

hi,

one specific writer may write some books or one publisher published many books and etc etc.so we have must have 7 tables.

Explains:

My Database is for book store.I have 7 tables that stored book info on theirs.

The Stored Procedure SearchAllTable search tables for any string .for example if we want to retrieve...

yes

;with cte as

(

select '1' as SomeVal union all

select '11' union all

select 'Some Non Number' union all

select '88'

)

select * from cte

where SomeVal between '1' and '9'

And Result :

1

11

88

but I want...

in a field of a table ( with nvarchar data type) we have about 10000 data,some of them are integer - from 1 to 1000- and other are string;

I want...

I Connect using sa

And I have 5 bak files. all of these files are restored before.

Because of a hardware error I change VGA and RAM then install windows...

i try to restore using this query :

RESTORE DATABASE MyDatabase

FROM DISK = N'C:\MyBackup.bak'

WITH

FILE = ?,

NOUNLOAD,

REPLACE,

STATS = 10

GO

because there are many backups in...

Hello

My Backup file is from sqlserver 2008 r2 sp1 and I try to restore it on another pc with sqlserver 2008 r2 sp1

When I select backup file I see error...

thanks for your post 'Adi Cohn-120898' but see this:

DECLARE @Col nvarchar(50)

SET @Col='?'

SELECT @Col

DECLARE @Col2 nvarchar(50)

SET @Col2=N'?'

SELECT @Col2

First Select result is '?' and second result is '?'

Hi Dear

Please Explain more

hi dear

(I can not write English well)

I use these procedures in my application.But I want if in the second stored procedure transaction is rolled back , the first transaction will...