Viewing 15 posts - 916 through 930 (of 1,478 total)
Actually, if the target table already exists, you need to run an insert select statement. Something like this:
Insert into TargetTable (col1, col3)
Select colA, ColB
From target server
For more...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 22, 2009 at 9:22 am
As far as I know the only way is to read about it in BOL. If it exists just for backward compatibility, BOL will state so.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 22, 2009 at 5:16 am
The fact that you always got the same results at the past doesn’t guarantee that you’ll always get the same results at the future. If something would change in...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2009 at 8:03 am
Just out of curiosity – Why would you want to change the name of all columns to be in upper case?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 18, 2009 at 2:28 pm
I have to admit that Carl's post did surprise me. I wasn't aware of problems with accuracy of money data type, and suddenly he came up with something that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 18, 2009 at 1:57 am
--creating test table
create table test (id int, string varchar(100))
go
--inserting demo data
insert into test (id, string)
select 1, 'aaa'
union
select 1, 'bbb'
union
select 2, 'ccc'
union
select 3, 'ddd';
--using for xml cluse with path...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 17, 2009 at 8:47 am
t.hitendra (6/16/2009)
Thanks for correction I wasn't sure about clustered index on primary keys though.
May be you can point what anomalies could arise if...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2009 at 7:56 am
Don't trust the information from sysdepends table. There are few cases that you will not see the dependency of objects. Beside the scenario that you showed there...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2009 at 7:44 am
You can use an instead of trigger and change the value of the column according to the original value that the user used. I suggest that you'll read BOL...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2009 at 7:30 am
t.hitendra (6/16/2009)
I would love to know why do you need two primary keys in your table.
Although i think in relational database a primary...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2009 at 7:22 am
This is taken from BOL:
" rowversion is the synonym for the timestamp data type and is subject to the behavior of data type synonyms. In DDL statements, use rowversion...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2009 at 7:07 am
Grant Fritchey (6/15/2009)
GilaMonster (6/15/2009)
I thought Rockies were mountains.Any thoughts on who's going to take the FIFA Confederations Cup this year?
I seriously doubt it'll be the US, but I always hold...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 15, 2009 at 8:17 am
It is possible. Few reasons that can cause this:
1) Different data in each server can cause different query plan.
2) Different session settings (this one can also cause different query...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 15, 2009 at 5:13 am
There could be many reasons for this behavior and it is impossible to find it without any details. Here are few things that I would check. First of...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 15, 2009 at 1:01 am
MarkusB (6/12/2009)
The guest user has the permissions of the public role.[/url]
Just a small clarification. Every user and role (including the user guest) will get the permissions that are...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 15, 2009 at 12:48 am
Viewing 15 posts - 916 through 930 (of 1,478 total)