Forum Replies Created

Viewing 15 posts - 1 through 15 (of 529 total)

  • RE: Save Your Password

    Nice article. Certainly something that is forgotten all too often.

    Two things to bare in mind :

    1. PwdEncrypt is not a very strong encryption method. So to store very sensitive passwords,...

  • RE: Question of the Day for 04 Mar 2004

    Obviously, there is no record inserted. But hey, then again, you could get an error because the dboHistoryTable does not exist... Or maybe the dbHistory user is not present, or...

  • RE: Is there a way to retrieve the count of all records in a database?

    Don't think this is included. You could the (undocumented) SP_msForEachTable stored procedure to automatically loop through all the tables, getting the count and storing it in a temp table.

    After that,...

  • RE: Stuck on a tricky query ... please help?

     

    I can imagine you're getting confused. So am I, while reading your post...
     
    If I understand you correctly, you want to get the last 20 stories, all from different news_entity_id's....

  • RE: What is a DRIDefault?

    There is no real difference. The DRIDefault object (in DMO) allows you to control the Default constraint you add to a column.

    The difference with the Default property of the column...

  • RE: How do you duplicate a record in Stored Procedure

    Definitely go for the Audit table.

    I cannot think of a solution to not build a list of fields.

    I can imagine this is cumbersome, but have a look in the Scripts...

  • RE: .NET class call from SQL2K Stored Procedure

    Ooooh, and to answer your question

    Don't think it is possible to call a class directly (not from SQL2000 anyway). Yukon promises this, if...

  • RE: .NET class call from SQL2K Stored Procedure

    It is not entirely clear to me what you are trying to achieve...

    I would store the encrypted password in the database (unless you need it for something else, of course)....

  • RE: FIRST NAME,MIDDLE NAME AND LAST NAME

    This is possible, I think...

    Try using the CHARINDEX function to get the position of a space. With that value and the SUBSTRING function, you can get a part of a...

  • RE: compare lastyear vs. thisyear SQL

    You have two possibilities :

    1. Use the CASE construct in the SUM statements. Using it, you can say to only add the quantity or sales if the date is in...

  • RE: Parameters to scripts

    Don't think it is possible.

    The only way I see is to use a table somewhere to store the values before calling the script.

    In the script you can fetch the values...

  • RE: Query returning last 13 weeks

    To get the number of sales reports for each of the countries, by week, is not too difficult...

    SELECT Country, DatePart(w, SalesReportDate) As Week, Count(SalesReport) As NumReports
    FROM TableSalesReports
    GROUP BY Country, Datepart(w,...

  • RE: Global Sequencer

    If you're looking for a unique identifier, you could go for a GUID column. That is Globally Unique, so across tables, databases and servers.

    Obviously, it is not a 'sequence' number,...

  • RE: How to connect to Analysis Services using HTTP

    It shouldn't be too difficult to use Pivot Tables inside a browser. You'll need the ActiveX installed on the client, and it probably only works properly using IE.

    Obviously, you'll need some...

  • RE: how to tell if 2 resultsets are identical

    Have you checked the use of CHECKSUM_AGG?

    With it, you can calculate a checksum over a complete table or a column. Don't know if it is possible to calculate one over...

Viewing 15 posts - 1 through 15 (of 529 total)