Viewing 15 posts - 136 through 150 (of 1,132 total)
How can I ensure the once the ActualStartDate is entered i.e. Is Not NULL anymore the ActualStartTime is also entered.
This can be enforced with a check constraint
ALTER TABLE tblJobsBR
ADD...
July 18, 2009 at 7:02 am
Mladen Prajdic has written an SSMS add-on that includes reserve word capitalization and a few very other usefull features.
July 17, 2009 at 11:11 am
I am not able to reproduce you problem, so you must have run some extra SQL that is causing the problem.
Set up an environment:
CREATE TABLE dbo.Foo
( FooIdINT IDENTITY(1,1) NOT NULL...
July 13, 2009 at 8:59 am
To insure that the clients can connect only specifying the DNS Alias and do not need to specify the SQL Server Name, IP or port, here is a list of...
July 13, 2009 at 8:07 am
See the information article "How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server" at http://support.microsoft.com/kb/224071
July 12, 2009 at 10:33 am
As far as the "Pointer-based foreign keys", this implementation is described in the article "SQL Anywhere Cost Based Query Optimizer"
for version 5 at http://m.sybase.com/detail?id=1003010. The specific paragraph is:
4.1. Indexes
There...
July 10, 2009 at 10:09 am
As Lynn Pettis advised, you need to cast the datetime2 datatype into a datetime datatype but this conversion of datatypes needs to performed on the SQL Server 2008, which supports...
July 9, 2009 at 12:52 pm
What we want to do now is switch to 4 data and 1 log LUN for every DB
I assume you mean 3 data files and 1 log file for...
July 9, 2009 at 8:52 am
Can these SQL statements be defined as views ? If so, then the users can just select from the views and add a where clause as needed.
July 9, 2009 at 8:22 am
So using Timestamp could i keep track of recent updates on the table row values?
No and here is a scenario: Versus two different SQL Servers get the latest...
July 9, 2009 at 8:14 am
After installing SQL Server 2000 SP4, there is also a hot fix needed in order to get AWE to function correctly: http://support.microsoft.com/kb/899761
July 8, 2009 at 10:52 pm
The benefits of a natural key is that it can be validated externally, debugged easily, doesn't require extra joins in some cases, free index etc. Surrogates do not belong in...
July 8, 2009 at 10:44 pm
SQL_Quest:
if the column cnsmr_accnt_id is removed along with inserted.cnsmr_accnt_id in your whole code, it gives me an error message:
Msg 515, Level 16, State 2, Procedure trig_test_insert1, Line 8
Cannot insert the...
June 26, 2009 at 3:01 pm
From Paul White:
Bizarre. So if we change the question the answer changes?
Heh. So given a proper primary key (i.e. a way of identifying a row uniquely) we have a proper...
June 26, 2009 at 2:51 pm
Lowell - yes , User-Defined Table Type are a new feature of 2008 and does not work on 2005.
"I got mislead by the forum, being 2005 i think." This...
June 25, 2009 at 10:43 am
Viewing 15 posts - 136 through 150 (of 1,132 total)