jkp2311 (6/25/2011)

---

Hi Bitbucket

I find another solution...

declare @vint int

declare @vcount int

declare @vintnew varchar(200)

declare @vintnew1 varchar(200)

set @vint = 1

set @vintnew = cast(@vint as varchar(200))

while @vint < 5

begin

set @vint = @vint...

LutzM

And no, I don't think the solution Ron (bitbucket) posted is helpful to the community, since it shows the 2nd best option in almost any case. (@Ron: no personal...

Here it is as a WHIE loop

SET NOCOUNT ON

DECLARE @s-2 INT

DECLARE @P VARCHAR(20)

DECLARE @X VARCHAR(20)

SET @X = ' '

SET @s-2 = 1

WHILE (@S < 10)

BEGIN ...

Read this for a guide to accomplish want you desire to do.

http://technet.microsoft.com/en-us/library/ms189858.aspx

Looking forward to it.

A rather obvious answer. Come on Gail make your next QOD more difficult.

Check out the following and determine if these might assist you.

SQL Server 2005 Log File Viewer at:

http://www.mssqltips.com/tip.asp?tip=1021

or:

http://decipherinfosys.wordpress.com/2008/04/02/log-file-viewer-in-sql-server-2005/

Now both use SSMS and some manual labor, but just might suffice for this...

SQLRNNR (6/23/2011)

---

Gianluca Sartori (6/23/2011)

---

Jayanth_Kurup (6/23/2011)

---

I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system...

Nice question on fundamentals .. thanks

winston Smith (6/22/2011)

---

your question has no context and is not phrased very well.

If you could explain your question a little clearer, and give some context ( in the form of...

skynet_si (6/22/2011)

---

so basically I need this :

SET DATEFORMAT DMY

before every insert queery.

I dont really care how the server stores my data as long as I enter it

correctly....

I tried and...

Does this help:

CREATE TABLE #MY_TABLE (TYPE VARCHAR(5),START_DATE DATETIME,END_DATE DATETIME,RATE VARCHAR(4))

SET DATEFORMAT DMY --Note this setting

INSERT INTO #MY_TABLE (TYPE,START_DATE,END_DATE,RATE)

VALUES('DBLMS','01.03.2011','16.04.2011','104');

SELECT TYPE, CONVERT(VARCHAR(10), START_DATE, 103) AS [DD/MM/YYYY]

FROM #MY_TABLE

Result:

TYPEDD/MM/YYYY

DBLMS01/03/2011

Remember that:

Values with the datetime data...

Will this make you happy?

SET DATEFORMAT ymd;

GO

DECLARE @datevar DATETIME;

SET @datevar = '1998/12/31';

SELECT @datevar AS DateVar;

GO

-- Result: 1998-12-31 00:00:00.000

--Will this make you happy?

SET DATEFORMAT dmy;

DECLARE @datevar DATETIME;

SET @datevar = '31/12/1998';

SELECT @datevar...

WayneS (6/21/2011)

---

Stefan Krzywicki (6/21/2011)

---

I spent the weekend visiting friends in Richmond. House prices down there are really low, but I don't know that there's enough of a market down there...

You are more likely to have someone assist you if you post your table definition, some sample data (which you have but not in a readily useable format).

May I suggest...