Well technically you don't connect to a database, you connect to an instance of SQL Server. Then from that connection...

Yes that is...

todd.ayers (5/2/2013)

---

I just had sql server 2012 installed on my local machine but after typing my code I clicked on the execute button to test it but I am not...

npyata (5/2/2013)

---

Here is code which has been suggested: I need the incremental value of log_seqno. How to compute vr_seqno incrementally.

ffhand i think this would do it in a single shot,...

One question I would ask is, do you care about the order? Your cursor has no order by so there is no guarantee what order the data will be returned....

npyata (5/2/2013)

---

Here is the updated code: Still this is running slow.

DECLARE @log_id INT

DECLARE @vr_seqno INT

DECLARE @getlogid CURSOR

SET @getlogid = CURSOR FOR

SELECT log_id

FROM [testdb].[dbo].[match_event_log]

OPEN @getlogid

FETCH NEXT

FROM @getlogid INTO @log_id

WHILE @@FETCH_STATUS =...

mjmshopper (5/2/2013)

---

I am trying to use a query that works in SQL Management in Visual Studio but the code it not translating. Can any one help me fix this. Here...

ROFL Lowell. I was at a meeting...

The big question is do you know why that fixed it?

rohit.anshu (5/2/2013)

---

hi,

I just came across an error, the cause of which is unknown to me.

why would a TSQL :

-----------------------------------------------------------------------

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'Schema1' AND...

npyata (5/2/2013)

---

I am new to sql server 2008 R2. I have an issue with CURSOR. This is an simple cursor to get rows sequential and update an colum with flag...

I think I may see part of the problem. You create a temp table but you never populate it. Then you try to update it and select from it.

CREATE TABLE...

Hi and welcome...

umm....this new problem is not any better than the last one. Your inserts don't work as posted, your sample data compared to your output doesn't seem to match. The description...

Agreed about not sending in a where clause. I would guess that if you are wanting to pass in a where clause it is because you are building a search...