The best way to do this is using a table with positive numbers. This way you can avoid using cursors, and even create a view.

This sql script ( test it...

To avoid the problem, I use my function dbo.fn_getdate(). This function can be used in other functions:

script ( create it in master, and call fn_getdate as master.dbo.fn_getdate() ) :

create table...

For this to work, your xml should be like :

<root>

<screens>

<ScreenId>1</ScreenId><RoleId>1</RoleId>

</screens>

<screens>

<ScreenId>3</ScreenId><RoleId>1</RoleId>

</screens>

<screens>

<ScreenId>7</ScreenId><RoleId>1</RoleId>

</screens>

<screens>

<ScreenId>8</ScreenId><RoleId>1</RoleId>

</screens>

</root>

I couldn't get it either ...

Great article.

I would really like to see how this is implemented, but could not find the download ?

You can read the xml into a text variable. But you can not declare a text variable in a stored procedure. You can have a parameter of type text, so...

For a function, you have to give all the parameters. You can use default to specify you want to use the default value : select @a =dbo.ufn_test(DEFAULT)

Bert

I tried that before proposing upper(). I tried it using an english alphabet ... and it does not work with '%[a-z]%'. I do not understand why ...

Bert

You can also use

where somecode != upper(somecode) COLLATE SQL_Latin1_General_CP1_CS_AS

It depends of the numer of data to be inserted in the table. If you create the clustered index first, the server has to find first where to insert the...

If you want to increase performance, creating an index that will never be used makes no sense.

I would replace one of the non clustered indexes by a clustered index. But again,...

This is not possible with bcp.

Can you try this script ? :

set nocount on

go

if object_id('dbo.person_identif_test') is not null drop table dbo.person_identif_test

go

create table dbo.person_identif_test

(

    --id int not null identity(1,1),

    person_id...

You do not need dynamic sql to do this. You can crate the table with a dummy name first, and use sp_rename to give it the name you want :

declare...

This is a new script. The first part ( up to the first go ) creates the stored procedure. This should only be executed once. The part after the go...