Viewing 15 posts - 466 through 480 (of 789 total)
Michael Earl (1/9/2009)
Dugi (1/9/2009)
SELECT c.name, b.name
FROM sys.tables b
INNER JOIN sys.schemas c ON b.schema_id = c.schema_id...
January 9, 2009 at 7:45 am
jameslester78 (1/9/2009)
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
oh, when i look in my system...
January 9, 2009 at 5:35 am
Did you try the 2 little code above!?
January 9, 2009 at 5:27 am
Use this Script to find the Tables without any Primary Keys or Clustered Indexes!
SELECT c.name, b.name
FROM sys.tables b
INNER JOIN sys.schemas c ON b.schema_id = c.schema_id
WHERE b.type =...
January 9, 2009 at 5:21 am
Let say your table has 100 rec and the ID column withvalues 1,2,3,4,5...100
so you write
SELECT * FROM TABLE WHERE ID IN (2,3,24,1)
Post more info for your problem!
:hehe:
January 9, 2009 at 3:37 am
barunkmallick (1/9/2009)
you can use the belowinsert into
select column1,column2 from
Don't do double post just edit the post!
January 9, 2009 at 2:52 am
All reply should post here
http://www.sqlservercentral.com/Forums/Topic633185-338-1.aspx
Don't do double post!
================================================================================
January 9, 2009 at 2:51 am
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
Yes the system databases in SQL Server 2005...
January 9, 2009 at 2:26 am
Anybody has info aobut that or anybody has success!?!:w00t:
January 9, 2009 at 2:05 am
Ooooppsss I didn't see the "r" ...ok try with replace option during restoration !
January 9, 2009 at 1:31 am
umer (1/8/2009)
January 9, 2009 at 1:13 am
Gaurav (1/8/2009)
I was able to merge two table however the final table has no more primary key and also in my database there is a relationship...
January 9, 2009 at 1:00 am
ahall13 (1/8/2009)
January 9, 2009 at 12:49 am
or you can try like this:
NEW OR your table is TAB1
OLD OR the table with old values is TAB2
the code should be like this:
UPDATE TAB1
SET new_amount = T2.old_amount
FORM TAB1 T1,...
January 8, 2009 at 6:13 pm
If you want the best and the correct solution, post the structure of the tables and some sample data!!
January 8, 2009 at 5:55 pm
Viewing 15 posts - 466 through 480 (of 789 total)