We have SSN and bank account information in a table and are required to
encrypt the data. How can this be done? We prefer to encrypt just the columns
we need rather than the entire table. Thanks.

Here is what I have so far....
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

I'm new to the CTE thing, and I'm wondering why the following stripped
down example generates a syntax error ("near 'if'):
;with SearchSpace( myfield ) as
    (

The procedure does not use dynamic sql but does use temp tables a lot, the
temp tables are created in another stored procedure that then calls this
stored procedure.  This is taking up 2GB in pln cache.  Is the temp table
the cause of this?

After I do a DROP TABLE or CREATE TABLE, how do I check if the command
executed successfully, is there some error variable I can check? thanks.

I want to execute an existing SQL Server 2000 stored procedure from within a
user defined function. I am using this function within a view.
The stored procedure I want to execute returns a numeric value that
ultimately I want the function to return when it is called.

Have not been able to find an example despite extensive googling.
How do I set up a script to create my tables.
The part that I need is the part that drops the tables ONLY IF THEY
CURRENTLY EXIST.

First some context
Here is a stored procedrue (SP) that attempts to exercise the function we
will see further down:
====

I can use openrowset to insert records into table from excel file. However,
I'm having difficulty to eliminate those unknown columns saved with the file.
How to read the data without those columns.
Thanks so much in advance,

I have a question about joining tables and return data.
Below i have a simple query that returns data from lredd0010 where the
number 2440
exists in the redd0020 table.

I hope someone has the method to create the running calendar
there are same amount of days
the last date is today and start day (today - 6 month)
Please let me know about this running calendar

I am using the following SP (that I found on the net) for importing an image
file to my server DB.  And below that is how I call the SP, but it is not
importing the image file.  The SP uses textcopy.exe.  I am making the calls
from a remote workstation and not from the server.  ...

[I know thw subject isn't descriptive, but I couldn't think of what to call
this]
The following is the base setup
--

I have 2 tables:
Table1
...
LastModifiedDate DateTime

Can anyone see what is wrong with this vbscript? i get  the invalid
procedure call or argument destination on line 9
error
'  Copy each source column to the destination column