Viewing 10 posts - 1 through 10 (of 10 total)
This works in Sql 2008 and above but fails in SQL 2005.
September 24, 2013 at 1:00 pm
Instead of dropping and adding subscriptions, we may also alter the SP_MSins_<ArticleName> sp, in the subscribers by adding a condition at the start of SP, to check if the record...
September 11, 2013 at 2:56 pm
the question is abot types of index structures but not about the types of indexes.
May 21, 2010 at 1:04 am
select * from mytable where rownum >=10 and rownum <= 20
The above query is fine only when rownum is a column in your table or...
April 23, 2010 at 2:40 am
hi sameer,
nice question.... you r question it self has the answwer..
The actual question asked is
A Primary Key is always enforced by a clustered index at creation?
which is not always...
March 10, 2010 at 12:30 am
Hi Nandini,
this is an internamtional forum and most of the members doesn't know about our great USA (United Streets of Ameerpet) :-). But for sure it will...
February 17, 2010 at 2:06 am
We have three types of dml triggers,
AFTER Triggers, INSTEAD OF Triggers & CLR Triggers
December 2, 2009 at 6:15 am
i am refferning to the below question posted,
What is the output of the following code (disregarding "X row(s) affected"):
CREATE TABLE TriggerTest (Value int)
GO
INSERT INTO TriggerTest VALUES (1)
GO
CREATE TRIGGER tr_TriggerTest ...
December 2, 2009 at 6:03 am
The above error occurs when ever you pass a negative value to the substring function.
EX:-
select substring('asdf',1,-1)
Server: Msg 536, Level 16, State 3, Line 1
Invalid length parameter passed to the...
November 17, 2009 at 5:12 am
Viewing 10 posts - 1 through 10 (of 10 total)