Kategoria: SQL Server


select * from dbo.sysobjects where id = object_id(N'[dbo].[tmp_procedura_lista]')

select * from dbo.sysobjects where id = object_id(N'[dbo].[tmp_procedura_lista]') and OBJECTPROPERTY(id, N'IsProcedure') = 1


select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1

export danych z tabeli do pliku tekstowego

declare @str varchar(500)
set @str = 'bcp new..tabela1 out e:\pliki_txt\test.txt -t "|" -r "\n" -c -C RAW -S10.10.1.10 -U sa -P 123456'
exec master..xp_cmdshell @str

import danych z pliku tekstowego do tebeli

declare @str varchar(500)
set @str = 'bcp new. .tabela1 in e:\pliki_txt\test.txt -t "|" -r "\n" -c -C RAW -S10.10.1.10 -U sa -P 123546'
exec master. .xp_cmdshell @str

declare @st varchar(500)
set @st = 'Now is the time for all good men ... '
select charindex('all', @st)