well, if it's displayed as html, CRLF do not show up!

html does not respect whitespace... you need {BR} markups to do that!

(replace curly braces with LT/GT..forum doesn't like real HTML...

the carriage returns are still there...are you looking at the data in SSMS in grid mode? grid mode hides CrLf.

in SSMS, hit Control T, then re-run your query.

your data should...

SQL has a case statement so you can say exactly that...when somestring then ...

only caveat is all the values returned by the case statement must be the same data type.

but...

what result are you getting?

create table #test(

testid int identity(1,1) not null primary key,

stuff varchar(30) )

insert into #test

select 'one' union all

select 'two' union all

select 'three' union all

select 'four'

select * from...

yeah, you are mistaken. the reseed value assigns the next value, not next+1.

your command reset the Id to zero...if you want, you could DBCC CHECKIDENT('sometablename', RESEED,-999); and the identi would start at -999, and work it's way towards zero and beyond

I assume...

We had a similar situation...Developers were givien full access because an important project needed to be updated to production as soon as the developers finished a module.

the problem was, because...

there is no built in, easy way.

the procedure sp_fkeys [YourTableName] will report all the tables that have a FK relationship with your table, but there is no way to get...

yes it's fixed...my original posts had only single line that stretched a million characters....Steve's all over it apparently.

it sounds like if Field 2 is supposded to be a part of field 1, it should either be a calculated column instead, or have a check constraint.

create table #example(exampleId...

try this from my saved snippets::

it's a proc someone asked for so they coupd capture sp_who2 throughout the day:

CREATE PROCEDURE PR_CAPTURESP_WHO

AS

BEGIN

SET NOCOUNT ON

IF NOT EXISTS (SELECT...

i would simply create a view, rather than insert into a new table.

the view would always be correct, where the table would need to be updated every time table2 got...

thre's a difference between "log" files created by some application, and SQL's log files...i think dmc was thinking the log files you are talking about are SQL's.

if you have an...

if you declare a char(50), and put a single character in it, because of it's datatype it will add 49 spaces on the end.

that's the expected behavior.

Varchar(50), on the other...

omg Adi great minds think alike. paraphrased but verbatim answers