SQL Server database programming

Hi! Would it be possible to use encryption in SQL Server 2005 and make it impossible for the sysadmins (incl. 'sa') to decrypt the data? We thought of certificates protected by a password, but we would then have to pass the password as a parameter to our stored procedures and all ...

Hi, I need to pass back multiple selection from an asp.net app datagrid and update a table. How should I handle this? I get the values by looping he datagrid, but, do I execute the update stored procedure on every iteration? ...

I have two apps (with two databases) that have user accounts that are identical to the base username in SQL Server (minus the domain) and I've written a procedure that combines them into one list. Then I tried to use ...

I am trying to use a REPLACE function to replace '<br />' in a text field with CHAR(13) but it fails and I'm not sure why.  My statement is REPLACE(activity_note, '<br />', CHAR(13)) ...

SELECT     CategoryName FROM         ads_categories WHERE     (adnum = 12) returns 3 rows:       Catering       Cleaning       Concierge ...

Hello there, I need your advices/comments. After in-place upgrade to SQL Server 2005, we've noticed some strange query optimizer behavior when executing an INSERT SELECT query. There were absolutely no performance problems with this query in MSSQL2k ...

Hi Everyone Is it possible to use a CASE statement, instead of an IF statement in a UDF. The current IF UDF is as follows: ALTER FUNCTION dbo.ClassBusiness_NU_IncomeAnalysis (@ProductCode AS VARCHAR(6),@Sectiontype AS VARCHAR(10)) RETURNS VARCHAR(10) AS ...

I have been searching for the solution to a problem, I know there must be an easier way but I have been unable to solve this problem without using a cursor. Here is the example.  Using the NorthWind Sql Server Database ...