Viewing 15 posts - 57,766 through 57,780 (of 59,048 total)
I don't have access to SQL Server right now so I couldn't test this... I think it may work...
select
OrderDate,
ShipCountry,
ShipCity,
Freight,
/* how do I get...
August 26, 2006 at 12:21 am
Ok... I get it... David Burrows beat me to the punch... take a look at his posting... I think that may be what you want. When you re-import, you'll probably...
August 23, 2006 at 10:09 pm
Yep... copy and paste error... the cascade rename should look like...
--====== Cascade rename the tables.... (takes about 65 milliseconds) TRUNCATE TABLE dbo.INV_Barcodes --Saves log space because is not logged DROP TABLE...
August 23, 2006 at 10:01 pm
That won't help either (the Created_by) because it is not automatically updated during an update unless you have a trigger to do that... and, as you pointed out, even that...
August 23, 2006 at 7:36 pm
Move all DECLARE's to the beinning of the function where they belong.... you cannot include DECLARE's in a WHILE LOOP.
August 23, 2006 at 7:16 pm
There is no "modify date" for schema changes in SQL Server 7, 2000, or 2005. You can however, add a new database trigger in SQL Server 2005 that will allow...
August 23, 2006 at 7:10 pm
Nope, sorry Gopi... Serqiy has it right (once you correct the typeo) and you have it wrong... here's the proof... run this in the grid mode so you can "see"...
August 23, 2006 at 7:06 pm
Hmmmm... that just made me realize that we're all forgetting something.... none of the SELECTs, so far, expose the Primary Key.
August 23, 2006 at 6:54 pm
I thought you said you have an app that will do the encryption of new data that goes into the table... I thought that maybe you could "trick" it into...
August 23, 2006 at 5:30 pm
Yep... that would do it... that was the only 1 of the 3 that I did look at. Thanks, David.
August 23, 2006 at 6:53 am
Step 1, I think, (normally not so adamant) would be to make sure that whoever designed this mess needs to be identified, captured, disemboweled in public, and have his/her...
August 23, 2006 at 12:17 am
Ok... so why can't you use the application to encrypt the data on a "one time basis"? Sorry, Dinakar, I just don't understand why this is a problem.
August 22, 2006 at 11:14 pm
What ever are you talking about? There is no ISINTEGER function in MS-SQL Server....
IsNumeric allows anything that can mathematically be converted to a numberic value including scientific notation (e), decimal...
August 22, 2006 at 11:02 pm
Viewing 15 posts - 57,766 through 57,780 (of 59,048 total)