I was performing some case sensitive comparsions and as one of options was to use check sum, anyway I conluded that CHECK_SUM and BINARY_CHECK sum functions return same value for different inputs.As far as I know those functions are like hash functions and CHECKSUM applied over any two lists of...
Is there possible two fill table with second result set returned by stored proc.For instance
create proc test
as
begin
select *from orders
select *from Employees
end
insert into sometable exec test
So I want to fill table 'sometable' with result set
'select *from Employees'. There by...
I need to call rand functino within another function but server raises an error.For example I can't create followng function
create function dbo.test()
returns float
as
begin
declare @i float
select @i = rand()
return @i
end
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.