Spatial Data

RE: Getting day of week from datetime value

• by timingskey

• SQLServerCentral.com

• Reply

Thanks!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-28

RE: QOD Cheats

• by Ritch

• MSSQLTips.com

• Reply

If people were cheating to achieve something I think it would be a different matter entirely, but how much are they going to truly learn by copying the answers. And at the end of the day thats what it is all about, learning. What satisfaction they gonna get, 'woohoo I can copy and paste'! *I […]

2003-07-25

1 reads

RE: Recursive instead-of-delete triggers

• by rprice

• MSSQLTips.com

• Reply

Had very similar problem. We have a workflow app where tasks can have several layers of child tasks. Child rows have a reference to the parent id. Had to write code (delete trigger) which created a temp table to collect all the ids for the child rows. Then scaned throught the temp table and deleted […]

2003-07-21

1 reads

RE: SQL Newie needs help

• by Frank Kalis

• SQL Server Performance

• Reply

Hi Jigman, quote: Ok, back to SQL Server. Say I have a table populated with around 50 items. The primary key is their ID (eg 1-50). If I get a new item that I want to chuck in the database at say position 25, is it possible to do this without deleting position 25? For […]

2003-07-18

2 reads

RE: SQL Newie needs help

• by JigMan

• SQL Server Performance

• Reply

Ok, back to SQL Server. Say I have a table populated with around 50 items. The primary key is their ID (eg 1-50). If I get a new item that I want to chuck in the database at say position 25, is it possible to do this without deleting position 25? For example can I […]

2003-07-17

1 reads

RE: SQL Newie needs help

• by Frank Kalis

• SQL Server Performance

• Reply

Hello Jigman, quote: I think I will create an application in C++ Builder that will allow the entering of the data, this will be saved into the database, when a client views the web page their desired information is grabbed from the database. really going down C++ road? While, from my point of view, certainly […]

2003-07-16

RE: what is the best way to search between tow date fd

• by jpipes

• SQL Server Performance

• Reply

Then you need more parentheses. I think this is what you are looking for: WHERE ( (dbo.mainb.tarih >= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND (dbo.mainb.tarihb <= CONVERT(varchar, DATEADD([day], 1, GETDATE()), 112) + ' 16:00:00') ) OR ( (dbo.mainb.tarih <= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND (dbo.mainb.tarihb >= CONVERT(varchar, DATEADD([day], […]

2003-07-14

1 reads

RE: Simple Query

• by rehook2003

• SQL Server Performance

• Reply

It worked great! Thank you! Rick

2003-07-14

RE: If PK is a GUID, what index type is best?

• by pjotrb

• MSSQLTips.com

• Reply

Thanks all for the great replies! I will try again to convince our DBA to revise some of his methods. If I understand correctly, a datapage which becomes full does not mean that all data has to be moved, just the data from that page is split in two pages. So the overhead of a […]

2003-07-11

RE: If PK is a GUID, what index type is best?

• by Frank Kalis

• MSSQLTips.com

• Reply

quote: Antares: I forgot to mention that your demonstration was exceptionally exhaustive and nice 🙂 yes it was indeed ...and proofed what Brian Kelley mentioned in another thread NOT to rely only on one single source of information! Cheers, Frank

2003-07-11

1 reads