Viewing 15 posts - 11,761 through 11,775 (of 18,923 total)
I used to do something like this :
SELECT dbo.fnGetCustResidId(), CustomerId
from inserted i
...
I made a udf that returned the type (ID) of something.
That way I could always call the UDF in...
September 18, 2006 at 8:01 am
Have you tried putting everything in dynamic sql and run it like that??
I think it's like the problem with : "use @MyDbname" >> can't work without dynamic sql.
September 18, 2006 at 7:55 am
Thanx.
Let's just call that plan B for now
.
September 17, 2006 at 6:21 pm
Can you connect to the db and do something like Select * from dbo.SysObjects?
September 17, 2006 at 4:02 pm
ND I'm not telling you are a liar.
SHOW US how the heck you do that!
September 17, 2006 at 3:59 pm
How does that insert in 2 tables at once?
And how does it work when you insert more than one row at the time?
September 16, 2006 at 1:53 pm
There's already a thread started on this subject and you are not the only one complaining. The bottom line is that sqlservercentral has signed a contract to test this...
September 16, 2006 at 8:51 am
Or if it's an table valued or inline function :
Select Cols_List from dbo.FunctionName (@Par1, @Par2) where ...
September 16, 2006 at 8:49 am
Sorry but there's no way to code an insert in 2 tables at once.
You have to do something like this :
Insert into dbo.Customers
--fetch the new ID
SET @MyNewID = SCOPE_IDENTITY()
Insert...
September 16, 2006 at 8:47 am
I think you may have a look at replication (maybe bi-directionnal). It's surely gonna come up later with admin DBAs (I'm not one of them).
Check it out in books...
September 16, 2006 at 8:44 am
I can forward you all the beer I won't drink. But you have to pay the shipping charges
.
September 16, 2006 at 7:02 am
1. Checked
2. CHECKED!!!!!!!!!
3. Check.
4. Sorry don't like beer
5. On my very best day I can beat the world champion. On my normal day I can beat 99.9% of the players...
September 16, 2006 at 5:47 am
Are you guys hiring junior DBAs? I'd love ot come in and start a career (not that I don't like programming but sql server is just more of a...
September 15, 2006 at 6:53 pm
Ya made the mistake of the (implicit) cross join once... not gonna do it again
.
September 15, 2006 at 9:55 am
As I said EXCLUDING CLR you can't call a proc in a function.
September 14, 2006 at 9:35 pm
Viewing 15 posts - 11,761 through 11,775 (of 18,923 total)