Viewing 15 posts - 136 through 150 (of 1,131 total)
Mladen Prajdic has written an SSMS add-on that includes reserve word capitalization and a few very other usefull features.
See http://www.ssmstoolspack.com
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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.
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
June 25, 2009 at 10:43 am
I naturally leaned towards the idea that the groups for sets and the awards form sets of groups so would go for a set based approach. Other guys in the...
SQL = Scarcely Qualifies as a Language
June 25, 2009 at 10:10 am
Viewing 15 posts - 136 through 150 (of 1,131 total)