1,109 reputation
31840
bio website
location Sydney, Australia
age
visits member for 2 years, 4 months
seen Dec 15 at 2:47

Jan
7
awarded  Famous Question
Dec
16
awarded  Popular Question
Dec
16
awarded  Popular Question
Dec
12
comment Move values from one table to another one via stored procedure in sql server 2008
I think the best way is using the trigger as described below by Kin, otherwise even if you implement a stored proc, how do you want to call it? Trigger is the best option for this.
Dec
11
comment Uniqueidentifier vs. IDENTITY vs. Material Code --which is the best choice for primary key?
I agree with Joel. Sometimes the natural keys are subject to change or duplication. In these cases, obviously they are not good candidate for primary keys.
Dec
9
comment OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
I installed it from the link above, reopen the SQL management studio but still this provider is not listed there. Is there anything else should be done to add it to the provider list?
Dec
9
comment OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
Thanks for your time. I think the reason it's not working for me, is because I don't have 'Microsoft.Ace.OLEDB.12.0' among the providers as you specified in your answer. Could you please advise me how to add it? I've edited my question to include the provider lists I've got currently.
Dec
9
revised OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
added 143 characters in body
Dec
8
asked OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
Nov
29
awarded  Popular Question
Nov
27
comment Finding rows where a column contains [ and ] characters
Thanks. I used the second option and it worked well.
Nov
27
accepted Finding rows where a column contains [ and ] characters
Nov
27
asked Finding rows where a column contains [ and ] characters
Nov
25
accepted How to add rows/columns to the table in runtime in SSRS 2008
Nov
25
comment Using OLE DB Source SQL command vs desinging the query using the object tools
Such an insightful answer! I totally agree.
Nov
25
accepted Using OLE DB Source SQL command vs desinging the query using the object tools
Nov
25
asked Using OLE DB Source SQL command vs desinging the query using the object tools
Oct
28
awarded  Popular Question
Oct
25
awarded  Famous Question
Oct
8
awarded  Popular Question