Hello, thank you,

But, is it possible to use a table value function in a computed column?

JoseAcJR

Thanks everyone, it was exactly the explanation I needed to get!

😀

JoseAcJR

Ok, but let me explain better:

During the installation of SQL Server or even once installed, can we define default value for some types (eg DateTime) for all tables that...

Thank you!!

Thanks to all

Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.

Hi Richard,

Varbinary values are the same..

In your example I noticed that was also inserted a zero because it is a odd numbers of digits after 0x

Is there any way to...

Lokesh Vij (10/25/2012)

A trick to catch the glitch.

1) Use SSMS, go to "Query" and select "IntelliSense Enabled"

2) Copy paste the code

3) the syntax error...

It was necessary to practice the basics to get where he is today!

..although I have been wrong,

Good question!

but the sqlservr.exe process continues to occupy too much memory ..

😉

with MySelect as

(

SELECT Name,

RANK() over(order by UserId) as newUseId

from TableUsers

)

-- Inserts

SELECT newUseId,

'INSERT TableUsers( ... ) VALUES ( '''+ UserId + ''',' + '...)' as SQL1

FROM...

Yes, see:

exec dbo.PD_Lista_Tabela_Diferente 'databaseNew' , 'databaseOld'', ''

Hi, You can do this:

exec dbo.PD_Lista_Tabela_Diferente 'databaseNew' , 'databaseOld'', 'p' --names of tables that start whit "p"

Thanks

😀

Jose Anchieta C. Jr