quote:

---

I have stored my data my using insert into table1(password) values (encrypt('mypassword')). Now how can I display this password field onto the...

quote:

---

This solution from liya_kats is probably the best one. If this is SQL Server 2000, you could convert this to a user-defined...

quote:

---

Does anyone know how add or sub time data types.

I have to count how long an employee has been at work that...

You can use this SQL trick to copy the table structure but not any data toa new table

select *

into anewtable

from sometable

where somecolumn=a and somecolumn != a

This will duplicate the...

quote:

---

I am writing some stored procedures and want to encrypt the code. I am using the "With Encryption" command. Are...

http://www.microsoft.com/xml/ has some examples of this now. Better late than never.

If you are calling a stored proc recursively, you an define a parameter as an OUTPUT parameter and include it on all subsequent calls. When the outermost proc completes,...

No. SS created the compiled plan based on the 1st execution of the proc. Your queries will for tables 2 and 3 (depending on order) will use the...

Usually you don't want to do this. Instead consider using a fully qualified data base name on your stored procs. If you need to build and send a...

There are several scripts on this site that do exactly this. Most of them create and populate a table you can join with your base table on the ID...

See recent posting in scripts area for a scripts to decrypt encrypted data base objects.

A script has been posted recently that lets you decrypt the statements used to build the view. Check the scripts area for details. I voted for it!...

This is the old 'SQL Injection' bug. You can avoid the possibility by doing a CLng(ID) in your VB code. Anything that is not numeric will fail the...

This is the old 'SQL Injection' bug. You can avoid the possibility by doing a CLng(ID) in your VB code. Anything that is not numeric will fail the...

This is the old 'SQL Injection' bug. You can avoid the possibility by doing a CLng(ID) in your VB code. Anything that is not numeric will fail the...