sql - Timer-based event triggers

sql - Timer-based event triggers

I am currently working on a project with specific requirements. A brief overview of these are as follows: Data is retrieved from external webservices Data is stored in SQL 2005 Data is manipulate…


sql server - Tables with no Primary Key

I have several tables whose only unique data is a uniqueidentifier(a Guid) column. Because guids are non-sequential(and they're client-side generated so I can't use newsequentialid()), I have made a…



Boolean Field in Oracle

Yesterday I wanted to add a boolean field to an Oracle table. However, there isn't actually a boolean data type in Oracle. Does anyone here know the best way to simulate a boolean? Googling the subjec…


Searching for phone numbers in mysql

I have a table which is full of arbitrarily formatted phone numbers, like this 027 123 5644 021 393-5593(07) 123 456 042123456 I need to search for a phone number in a similarly arbitrary format(e…


sql server - Use Float or Decimal for Accounting Application Dollar Amount?

We are rewriting our legacy Accounting System in VB.NET and SQL Server. We brought in a new team of.NET/ SQL Programmers to do the rewrite. Most of the system is already completed with the Dollar amo…


What datatype should be used for storing phone numbers in SQL Server 2005?

I need to store phone numbers in a table. Please suggest which datatype should I use? Wait. Please read on before you hit reply.. This field needs to be indexed heavily as Sales Reps can use this fie…


Unable to receive JSON from JQuery ajax call

I have determined that my JSON, coming from the server, is valid(making the ajax call manually), but I would really like to use JQuery. I have also determined that the "post" url, being sent to the…


Can you reliably set or delete a cookie during the server side processing of an Ajax(XHR) call?

I have done a bit of testing on this myself(During the server side processing of a DWR Framework Ajax request handler to be exact) and it seems you CAN successfully manipulate cookies, but this goes…


sql - `active' flag or not?

OK, so practically every database based application has to deal with "non-active" records. Either, soft-deletions or marking something as "to be ignored". I'm curious as to whether there are any radi…


How do I alter the precision of a decimal column in Sql Server?

Is there a way to alter the precision of an existing decimal column in Sql Server?…




data type how sql example column server mysql table with