Viewing 15 posts - 421 through 435 (of 476 total)
Phil Parkin (9/14/2015)
This is not correct. They can insert into local table variables, which are then returned by the function. See here for an example.
Thanks. I wasn't specific 🙂 Are...
September 14, 2015 at 9:28 am
Rod at work (9/14/2015)
I'd like to know how people save the stored procs, views, triggers, etc. in a VCS?
No idea if my way is suitable for large / multiple...
September 14, 2015 at 9:22 am
GilaMonster (9/14/2015)
my option allows for changes made on the new server to be transferred back to the old server (providing same version) if necessary/
That I didn't know and would be...
September 14, 2015 at 9:05 am
P.S. I can't see a justification to have Log Backups more than about 10 minutes apart. There is a small overhead in each file, and if you have to restore...
September 14, 2015 at 8:52 am
crazy_new (9/14/2015)
September 14, 2015 at 8:47 am
Hopefully someone has an answer, the only ones I can think of are LOOP based.
You can find rows that have extended characters with
WHERE MyColumn LIKE '%[^ -~]%'
You might need a...
September 14, 2015 at 8:38 am
A function can't insert into a table. I presume that is the error that you are encountering.
A Stored Procedure could do.
The Function could return the SQL, for the code to...
September 14, 2015 at 8:28 am
Use the sp_addextendedproperty procedure to store a descriptive comment against each Table, Column, Index, etc? This is stored at a database level and can be part of any query about...
September 14, 2015 at 8:23 am
robinwilson (9/14/2015)
September 14, 2015 at 8:15 am
Why do you want a table with the NextAvailableID in it - rather than just putting an IDENTITY property on the ID column in the underlying table?
We have used this...
September 14, 2015 at 8:04 am
Can't remember what version of SQL it came in with - SQL2012 perhaps? - but that provides a SEQUENCE object which will do what you are describing - hopefully without...
September 14, 2015 at 6:58 am
Thanks Gail, must have misread something, somewhere, to have got that into my head!
September 14, 2015 at 5:56 am
haridatpurohit (9/14/2015)
2.get all oracle data in SQL servers temp table and after that you can update data in sql server .(works in my case .)
Over the years we've found that...
September 14, 2015 at 4:30 am
SELECT INTO #TEMP FROM OPENQUERY
Sorry, I meant
INSERT INTO #TEMP
SELECT
FROM OPENQUERY
as you have it.
September 14, 2015 at 2:13 am
Longshot:
Datatype difference one a column(s) between #TEMP table and Oracle's table?
I suspect that in the Old Way a change to Oracle datatype would just make a change to an Implicit...
September 14, 2015 at 2:00 am
Viewing 15 posts - 421 through 435 (of 476 total)