try using this:

BEGIN TRAN

SELECT *

FROM test_table (tablockx)

WHERE col1 = '1' ...

rVadim (8/22/2012)

---

Lokesh Vij (8/21/2012)

---

Slight modification in CTE:

WITH CTE AS(

SELECT CAST( (SELECT CAST( col1 AS varchar(10))+ ','

...

you can use sp_getapplock. Check out the following link:

http://msdn.microsoft.com/en-us/library/ms189823.aspx

Slight modification in CTE:

WITH CTE AS(

SELECT CAST( (SELECT CAST( col1 AS varchar(10))+ ','

FROM @test-2 b...

If it is always the second character string that you want to extract do it like this:

DECLARE @text VARCHAR(100) = 'abc_def_cet_qwe '

DECLARE @start_index INT

DECLARE @end_index INT

SELECT @start_index = CHARINDEX('_', @text,...

Good question:-)

Its always wonderfu to brush up our fundamentals 😀

Easiest question of all times..thanks for an easy 1 point 🙂

Create a function or stored procedure with @hyphen and @inputstring as arguments or parameters

DECLARE @hyphen VARCHAR(100) = '2,10',

@inputstring VARCHAR(max) = 'ABCDEFGHIJKLMNOPQRST',

...

Hope you are looking for something like this:

DECLARE @LoginName VARCHAR(128);

DECLARE @dynsql VARCHAR(max);

DECLARE @default_db VARCHAR(200) = 'AP';

DECLARE @role_name VARCHAR(100) = 'PaymentEntry';

DECLARE c_login CURSOR FOR

SELECT LoginName

FROM ...

Keld Laursen (VFL) (8/15/2012)

---

Lokesh Vij (8/15/2012)

---

Keld Laursen (VFL) (8/15/2012)

---

It is also worth noting that you have no method of resetting the identity counter for the table.

Thanks for the question. I...

Keld Laursen (VFL) (8/15/2012)

---

It is also worth noting that you have no method of resetting the identity counter for the table.

Thanks for the question. I were fairly sure that I...

Lowell (8/15/2012)

---

the best, most foolproof way is to backup the database, and restore it on the other server, with whatever name you would like. That is the standard recommendation.

everything other...

Good one. Learnt something obvious 🙂

+1

Yes that's correct!