Viewing 15 posts - 76 through 90 (of 285 total)
Excellent article. We are struggling with how to protect personal information. This article is complete enough that I am going to circulate it around our org.
Thanks for taking...
December 9, 2002 at 8:33 am
I am currently suffering through an application where NO foreign keys are defined. Ya --- the data base is fast but we have bug city from broken pointers out...
December 9, 2002 at 8:31 am
quote:
However true 128-bit encryption would still take millions of years. 40-bit was still in a range where it could be brute forced...
December 9, 2002 at 8:27 am
There is no UI for changing passwords in SS2K. Generally, SS users are not allowed to change their own passwords. If you are using Windows security (ie. your...
December 9, 2002 at 8:20 am
You can create a new column w/o identity, copy the current values to it, then delete the IDENTITY column.
December 8, 2002 at 8:50 pm
Look at the doco for SET XACT_ABORT and see if that helps you with your controlling stored proc.
December 8, 2002 at 8:47 pm
Several scripts have been posted recently that do exactly this.
December 8, 2002 at 8:46 pm
You can create an "instead of" trigger, do your calculations there and follow it with an insert with your computed values.
December 8, 2002 at 8:45 pm
quote:
can I issue an alter table/column statement the cahnges an existing int to an identity column?
December 8, 2002 at 8:43 pm
There are several scripts and articles dealing with T-SQL and strings. A couple of them address this. Look over there for more info.
December 8, 2002 at 8:39 pm
try something like this in your trigger:
set/select @MyColumn = IsNull(inserted.Column, deleted.Column)
So you get a not-null value. You can also use The IF UPDATE (column_name) clause and/or the IF COLUMNS_UPDATED()...
December 8, 2002 at 8:36 pm
Since dates are actually stored in the data base a floating point numbers, i think the fastest way to get today's data for comparison would be something like
select *
from...
December 8, 2002 at 8:22 pm
Several functions have been posted that parse out a comma separated list of values and let you select/operate on all the rows identified by the keys. Check the scripts...
December 8, 2002 at 8:14 pm
Several functions have been posted that parse out a comma separated list of values and let you select/operate on all the rows identified by the keys. Check the scripts...
December 8, 2002 at 8:13 pm
Communication with client apps is via the request/response model. There isn't any real API to get unsolicited input from SQL Server.
December 8, 2002 at 8:08 pm
Viewing 15 posts - 76 through 90 (of 285 total)