Viewing 15 posts - 2,446 through 2,460 (of 49,571 total)
mw112009 (9/8/2016)
The code for a SP goes in this table. Similarly how can we get the DEFINITION of a view
select [definition] AS ProcDef from sys.sql_modules
Exactly the same way....
September 8, 2016 at 1:20 pm
What do you need help with? What's the code doing or not doing that it shouldn't?
And I will reiterate my comment from last time this came up
GilaMonster (6/10/2016)
Chitown (6/9/2016)
September 8, 2016 at 8:43 am
djj (9/8/2016)
September 8, 2016 at 8:40 am
Grant Fritchey (9/8/2016)
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It...
September 8, 2016 at 8:36 am
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a...
September 8, 2016 at 6:08 am
There's no way to pass parameters to a view. Either the users apply the date filter when they query the view, or you'll need to change to a procedure or...
September 8, 2016 at 1:09 am
http://source.entelect.co.za/why-is-this-upsert-code-broken
While it talks about insert/update pairs, your manual sequence code will have the same problems.
Edit: And if you need an incrementing value that starts at 5,
SomeNumber INT IDENTITY (5,1)
September 8, 2016 at 1:00 am
If you've analysed and tested, and have confirmed through careful testing and consideration of alternatives, that the hint is the best way to solve the specific problem you have (most...
September 7, 2016 at 6:15 am
Same way you shrink any other database. DBCC ShrinkFile ('File name', Target Size)
September 6, 2016 at 2:39 pm
No.
You could bcp every table out to flat file, script the structures and recreate the DB, but that's a huge amount of work.
What are you trying to achieve here, and...
September 6, 2016 at 9:13 am
Speak to your SAN admin, storage admin or whoever is responsible for the storage on that server. If the files aren't accessible, then that will have to be fixed before...
September 6, 2016 at 6:43 am
Gregory Hart (9/6/2016)
if divide by zero is allowed, it's possible to prove that 1=2
The above claim would only work in a logical proof if you identified that NULL= NULL ....
September 6, 2016 at 6:40 am
Not asking if you can see the properties of the database in SQL. with the errors mentioned it's obvious you can't.
Can you see the database files in the file system?...
September 6, 2016 at 4:19 am
Wow, you got a 'thanks'. Impressive.
September 6, 2016 at 4:17 am
I second the recommendation for an audit table.
That said, there's no stored procedure that I know of to run alter table syntax on multiple tables, you have to run it...
September 6, 2016 at 3:03 am
Viewing 15 posts - 2,446 through 2,460 (of 49,571 total)