Viewing 15 posts - 8,221 through 8,235 (of 13,460 total)
I'd like to take a stab at this one; i've got a lot of examples I post to the forums on the subject.
January 10, 2011 at 2:44 pm
it depends on your data.
if you are absolutely sure there are only two spaces in the field for every single record, you could use something like CHARINDEX2 and substrings to...
January 10, 2011 at 8:31 am
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "AS400" reported an error. The provider reported an unexpected fatal error.
Message 7330, Level 16, State...
January 10, 2011 at 6:04 am
your probably doing it right.
The important thing to remember about sp_executesql is that it is susceptible to SQL Injection. since using parameters defeats that security hole, simply using params everyplace...
January 10, 2011 at 5:58 am
Koen (da-zero) (1/10/2011)
At first glance this seems like a situation that the MERGE statement could handle.
I agree with Koen, a MERGE statement would work perfectly...only problem I forsee is the...
January 10, 2011 at 5:50 am
kind of... you can use this example to put together jsut a final script that executes a varbinary(max) ...so the proc body is not so obvious.
just remember that SQL Server...
January 10, 2011 at 5:33 am
a datatable in .NET has a flag on each row that signifies whether the row has been changed;
typically at our shop, we test a datatable,(usually from a types dataset, but...
January 7, 2011 at 12:34 pm
If you are talking about comparing a table in SQL Server to it's assumed equivient table by the same name on oracle, two important things are the way an IDENTITY...
January 7, 2011 at 12:18 pm
I'm a bit confused...the PK will be the hashed binary/varbinary column? And you need to search the column? That doesn't sound right at all.
I don't think you can search for...
January 7, 2011 at 11:14 am
one of either two ways: send as plain text:
@body_format = 'TEXT',
or, as i mentioned before, add an extra column that will have a "<BR>"
@query = 'SELECT ##TableTemp.*, <BR> AS...
January 7, 2011 at 9:00 am
one of the many optional parameters sp_send_dbmail allows you to include the results of a query as either an attachment, or as part of the body of an email.
here's a...
January 7, 2011 at 8:32 am
i don't think it's 32 bit vs 64;
it might be that your zipgenus app is returning an error at teh command line that you are not seeing...
could you try this...
January 7, 2011 at 5:56 am
when you run xp_cmdshell, you are not running under your own credentials....
prove it to yourself by running this, which will show you what NT name you are running cmdshell from.
DECLARE...
January 6, 2011 at 4:50 pm
the server executable itself is always installed on the same disk the %SYSTEMDRIVE% directory exists; databases, traces ,previous backups you can discover form some of the system views, but...
January 6, 2011 at 4:45 pm
here's a single SQL with both examples:
formatted zip, and jsut the first 5:
select CASE
WHEN LEN(ZIPCODE) > 5
...
January 6, 2011 at 1:48 pm
Viewing 15 posts - 8,221 through 8,235 (of 13,460 total)