valores random en SQL Server

UPDATE Usuarios Set pin = ABS(CAST(NEWID() as binary(6)) % 100000) + 1


http://www.jasoft.org/blog/CategoryView,category,Programaci%c3%b3n.aspx

Index Server & SqlServer

 Sample

SELECT Q.FileName, Q.Size, Q.DocAuthor
FROM OpenQuery(FileSystem,
              'SELECT FileName, Size, DocAuthor
               FROM SCOPE()
               WHERE CONTAINS(''"SQL Server"
                                NEAR() text'')
                 '
             )   AS Q


Select * from OpenQuery(FileSystem, 'Select DocTitle, vpath, Filename, Size,
Contents, characterization, PATH, URL, A_Href, rank, write
from server.TestCatalog..Scope()
where FREETEXT(Contents, ''texto'') AND Rank > 0 order by rank desc,
write desc')



EXEC sp_addlinkedserver FileSystem,
  'Index Server',
  'MSIDXS',
  'Web'



select doctitle, vpath, size, create from
RemoteServerName.RemoteCatalogName..Scope() where contains('microsoft')

Concatenar campos de una tabla SqlServer

 

declare @prueba varchar(8000)

 

set @prueba = ''

 

select @prueba = @prueba + Usuario + ',' from table1

 

set @prueba = left(@prueba,len(@prueba) - 1)

 

print @prueba

 

 

Alejandro A Sfrede