Viewing 15 posts - 10,471 through 10,485 (of 13,469 total)
easy enough.
Stripping preceeding zeros, you just convert to int.
for the rest, here's an example:
--results:
exString ...
September 29, 2009 at 9:10 am
[ code] --a sql comment [ /code ] <-- with no spaces makes your code become syntax highlighted
--a sql comment
if you are using preceeding zeros, when you...
September 28, 2009 at 8:33 pm
a huge help, thanks for the layout!
try this query..it has all the defaults you were looking for. if the query works, uncomment the INSERT portion and confirm that that peice...
September 28, 2009 at 11:11 am
Greg Charles (9/28/2009)
September 28, 2009 at 9:22 am
bad form!
do not post the same question multiple times!
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts"...
September 27, 2009 at 5:15 pm
you cross posted across a few forums...the first being a SQL 2000 forum.
The MERGE keyword is for SQL 2008 only, but all the same process can be duplicated with INSERT...
September 27, 2009 at 1:03 pm
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
September 27, 2009 at 12:49 pm
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
September 27, 2009 at 12:49 pm
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
September 27, 2009 at 12:49 pm
it's the actual physical address: i think the format is [file_id]:[page_id]:[slot_id], so it's the true physical address on your server;
September 25, 2009 at 11:52 am
ar-727381 (9/25/2009)
so will...
September 25, 2009 at 10:13 am
ok here's a 2005 secret: there is a hidden row identifier in every table row named %%LockRes%%,
in 2008 they renamed the identifier to %%physloc%%
you can use that as part of...
September 25, 2009 at 9:33 am
as you know SQL backs up whole databases, so your options are:
-- a not "real" SQl backup: send the DDL and the data to a text file via BCP, so...
September 25, 2009 at 7:34 am
yes...because the test is HAVING COUNT(RT_MCP_Alarm_Text) >= 1, it probably sends for testing purposes...change it back to 30, and it won't until you finally have 30 or more messages and...
September 24, 2009 at 12:22 pm
that looks more like an error from running the script on the wrong database.
if the original SQL you pasted was valid, the rest should be valid too...
what you pasted is...
September 24, 2009 at 11:29 am
Viewing 15 posts - 10,471 through 10,485 (of 13,469 total)