I was trying to do a database mirroring( for learning purposes). But the mirroring process failed.
I am currently having sql server 2005...
The joined columns are correct.
Is there a solution?
I am having a table( a Junction Table aka Cross Reference table ) named XrefList,
This table is holding TableIds Which are the primary keys of...
Got this interesting article.
This is not much related to sql server 2005; but I hope some one among You might have encountered such problem in his/ her experience.
Thanks for the solution Frank.
Also I am thankful to all of the other people who helped me.
in the second last method ( method 5th)
Select min(num) from (select top 5 num from @number order by num desc) T
I think it should be...
I think I should be having order by DESC here
Does order by work for numeric column? (I think it works for varchar or Nvarchar but won't...
I am having a newbie question here which was asked in an interview:
How to find the fifth largest salary from an employee table where the salary...
<p> </p><p>Thank You, very much for the reply. Looks like You are working too much or are SQL alcoholic <img...
It is a Identity Column
I will be using Stored Procs to Insert the values in the tables(parent- child) rather than using triggers.
No, because I am just breaking a big table into logical groups, also the employee in question can be shifted to different team, but won't be a...
actually I am trying to create a database to manage teams,
like there is a table employees for a company
and another table which has the...
Is there any performance benefit from a self referencing foreign key, If I have a choice for reference from other table or the current table;...
If I am not wrong You are suggesting that I should be making a primary index (non clustered ) on natural key(key that has a bussiness...
I am using IDENTITY COLUMN AS A primary key; then according to You I should not be using primary key AS an IDENTITY?
Then what else...
I don't know if IDENTITY_INSERT ON is possible if we actually create a new column.
can You please improve this script:
(where should I...
I need help regarding the identity column.
I have a column whose Identity seed was 1 when the column was initially created.
Now I have to change...
Thank You very much again
Can You please elaborate more on this.
Separate names with a comma.