Viewing 15 posts - 436 through 450 (of 498 total)
Sounds to me like you need to do a replacement of the data when you display it. IE: When you have an e with an accent you change it to...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 14, 2003 at 1:04 pm
I would say that it all depends on the data you have. Personally I'm still using temp tables for a lot of my work. I do this because I typically...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 8, 2003 at 11:52 am
I recently had a situation exactly like what Phillip described where I had to go back several days to get to some valid data. Luckily for me I have a...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 8, 2003 at 1:30 am
I would take a look at BOL for 'Pivot Table'. This is a classic case where you need to pivot the data on the values. They are a royal pita...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 8, 2003 at 1:10 am
A couple more comments. What is the reasoning behind using a varchar field for the NextCustNo and CustID fields? As Mark stated it seems these fields should be INTEGERS and...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 8, 2003 at 12:55 am
Have you tried simply the Linked Server name plus the table name? IE:
SELECT * FROM Test2...ATAB
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 11:12 pm
Since you already have the linked server have you tried just using the fully qualified table name with a normal Insert or Update query? IE:
UPDATE LEAVESBOX.YourDB..YourTable
SET Field = 'blah'
WHERE Foo...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 10:43 pm
After a table has data in it you can't set the field to have the identity property. So in order to do this you will need to create a new...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 1:42 pm
The simple answer is no you can't do that.
You need to think of "Table Variables" instead as a temporary table that is stored in memory instead of the tempdb. You...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 1:14 pm
UDT's are great when modeling a database. Having said that I don't use them in any of my databases as I prefer to use the base data type. This lessens...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 1:08 pm
You might want to create a simple stored procedure that calls the suser_sname() function in SQL Server. The Access CurrentUser function will only work if you have turned on the...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 1:00 pm
The best way to go about this in my opinion is to put the data you want to compare into a formatted XML string. You can then use OPENXML in...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 12:47 pm
I would create a small app that connects to SQL Server using their credentials and then have the app call sp_password to make the change. This way they will be...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
August 7, 2003 at 12:18 pm
I would go about this a little differently than everyone has suggested so far. I would make server c the publisher and servers a and b the subscribers. I would...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
June 19, 2003 at 5:47 pm
I would probably create a table to hold the values you want to replace and then do something like the following...
UPDATE t
SET Addr = SUBSTRING(t.Addr, LEN(t.Addr)...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
June 19, 2003 at 5:38 pm
Viewing 15 posts - 436 through 450 (of 498 total)