Viewing 15 posts - 436 through 450 (of 789 total)
Yea this is true!
I cannot see any results from Hari's T-SQL, everything is empty! 😛
January 30, 2009 at 2:26 am
Very easy: right click on the table and click View Dependencies and you will see all other objects related to that table!
You can see the results in attachment!
😎
January 30, 2009 at 12:40 am
Yea very nice info Steve I like it ...Congratz to all the people that spend the time offering help!
:hehe::hehe::hehe::hehe:
January 29, 2009 at 6:23 am
Dont' do double post!
Every reply should goes
January 21, 2009 at 5:15 am
Dont' do double post!
Every reply should goes
January 21, 2009 at 5:14 am
omlac (1/16/2009)
I DIDNT KNOW THAT,Thank you very much.
yea you have too many things here to know ... that's nice to help each-other!
You are welcome!
January 16, 2009 at 7:36 am
BigJohn (1/16/2009)
Hi,The Wikipedia article is also quite good for determining the differences between the various join types quickly. It also includes examples and source code.
http://en.wikipedia.org/wiki/Join_(SQL)
Cheers,
Yes it is true like few...
January 16, 2009 at 7:17 am
ABOSS is BOSS of A department
A1 is Team Leader of department A
A2 is employee
So
A Boss
A1 Team Leader
A2 Employee
The hierarchy is BOSS >>> BOSS-TeamLeader >>> BOSS-TeamLeader-Employee
January 16, 2009 at 7:07 am
There is the test:
--CREATING TABLE JUST FOR TEST
CREATE TABLE AAA
(
ID INT IDENTITY(1,1),
PLACE NVARCHAR(40),
DATE DATETIME
);
--JUST TO ADD SOME DATE VALUE IN FORMAT DD/MM/YYYY
SET DATEFORMAT DMY
--INSERTING VALUES IN TABLE
INSERT INTO AAA
SELECT...
January 16, 2009 at 6:19 am
cotzan
Let me know that results from the query above is ok!? :w00t:
January 16, 2009 at 6:14 am
cotzan (1/16/2009)
i want to see first one with its ID
WITH IDD
AS
(Select ROW_NUMBER() OVER (PARTITION BY StCompanyName ORDER BY StCompanyName) AS IDNR, StCompanyName,StAccountName,StProcDTime,BoIsActive,StNotes FROM vwPurchase)
SELECT * FROM IDD
WHERE IDNR =1
January 16, 2009 at 5:58 am
And be sure that you do not have any Foregin Key from other tables which is referenced to the PK ( Your Clustered Index)
January 16, 2009 at 5:41 am
satyawan_sanap (1/16/2009)
it's a primary key clustered.. so wt would be the ans???
ALTER TABLE YOUR_TABLE
DROP CONSTRAINT your_constraint_name
January 16, 2009 at 5:38 am
Abhijit More (1/16/2009)
SELECT tmp.PojID, tmp.Cat,
...
January 16, 2009 at 3:38 am
Paresh Prajapati (1/16/2009)
Can anybody tell me the Difference between inner join and cross join.how and when we have to use them?
January 16, 2009 at 3:26 am
Viewing 15 posts - 436 through 450 (of 789 total)