Viewing 15 posts - 4,981 through 4,995 (of 7,185 total)
Not as far as I know - there is no create_date column in sys.columns. I would advise against using the GUI to insert a new column between two existing...
November 1, 2011 at 5:32 am
You're ordering your results by the create date of the table. Since that will be the same for each column in the table, you can't guarantee that your results...
November 1, 2011 at 5:15 am
Have you tried logging a call with Quest support? I usually find them very helpful.
John
October 31, 2011 at 10:01 am
From the link I posted:
- Never run with more privileges than necessary. Users that log into an application with their own login should normally only have EXEC permissions on stored...
October 31, 2011 at 4:51 am
prashant-507002 (10/31/2011)
By your point of view i have to make store procedure for each table insert, update and delete
That's what I'd recommend, yes. See also this:
http://www.sommarskog.se/dynamic_sql.html
John
October 31, 2011 at 4:37 am
Bear in mind that we usually have shorter hours and longer holidays here in the UK than in the US, especially in public sector jobs. Comparing the salary only...
October 21, 2011 at 3:29 am
Frank
Please will you post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements, and show us the data you're trying to insert...
October 20, 2011 at 7:05 am
Murali
What column(s) do you want to match the two result sets on?
John
October 20, 2011 at 4:45 am
Something like this?
WITH MinVals AS (
SELECT
TransNo,
MIN(IsVoid) AS IsVoid
FROM
MyTable
)
SELECT
t.IncidentId
,v.IsVoid
,t.TransNo
FROM
MyTable t
JOIN
MinVals v ON m.TransNo = v.TransNo
Please post table DDL (CREATE TABLE), sample data (INSERT) and expected results next time. You'll get...
October 20, 2011 at 4:00 am
Actually, your article doesn't cover use of the REPLACE option. And the Microsoft page you link to is...
October 20, 2011 at 3:43 am
Does the message go on to say anything else? I think you can use the REPLACE option to overwrite the existing database. I would advise you to use...
October 20, 2011 at 2:50 am
Two other things you could consider: back up msdb on your test server, then restore over it, then restore the original one back once you've retrieved your package. Or...
October 20, 2011 at 2:43 am
I would set them both to 12GB, for example, and if there's a failover, let them fight for the available memory. The reason for this is that failovers should...
October 19, 2011 at 7:51 am
I think there are compliance issues here, as well. In the UK, the Data Protection Act covers data that can be used to identify a living individual. As...
October 19, 2011 at 3:46 am
One way of doing it is put a DISTINCT in, thus:
...
LEFT OUTER JOIN (SELECT DISTINCT ServiceOrder FROM ServiceOrders) SO ON I.ServiceOrder = SO.ServiceOrder
...
John
October 18, 2011 at 8:43 am
Viewing 15 posts - 4,981 through 4,995 (of 7,185 total)