Forum Replies Created

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

  • RE: Which IDE?

    I just got back from a Microsoft conference and I heard the following:

    - Use RS on VS 2003

    - it will installon VS 2002 without any error, but it won't work

    So...

  • RE: Changing Columns to Upper Case

    SELECT LOUD_COLUMN1, LOUD_COLUMN2, LOUD_COLUMN3

    FROM LOUD_TABLE

    WHERE LOUD_COLUMN1 = "SOME LOUD DATA"

    Don't you think this is how code was written, say 20 years ago? And beside lower visual functionality, it's just plain...

  • RE: DatePart Function

    Don't ever manipulate date through varchar without using a defined style, because it depends on the regional settings. This way it may or may not work on different servers.

    Do it...

  • RE: VSS support

    This is not a commercial, but check out mssqlXpress at http://www.mssqlxpress.com.

    It's a great IDE for SQL Server with tons of goodies Microsoft will never implement. It also has it's...

  • RE: Generate Next Numbers with SQL Server

    While briefly reviewing your code I saw something funny. You are using varchar for date variable. This may work, but you mus be aware that SQL Server has to do...

  • RE: DB application off of a DVD

    Maybe this will help a bit: I have seen instructions on how to attach a read only database to SQL Server, but I don't remember the details.

    So you could...

  • RE: DateTime parmater for sp and debug

    I have found out that SQL Server does a correct implicit conversion from varchar to datetime if you use XML date format:

    'yyyy-mm-ddThh:mm:ss' (note the letter T between date and...

  • RE: FK to a View

    Instead of insert trigger works only when inserting new records. I won't do anything about UPDATE.

    Doing constraints with UDF is easy. Just make a scalar UDF with one or more...

  • RE: How to prevent simultaneous SP execution

    You may use SQL Server's internal locking semaphores by using sp_getapplock and sp_releaseapplock. This way you can delay second execution of SP. You can even set a timeout to wait...

  • RE: Naming Conventions

    Naming convention depends on the aspect, the way you "see" your objects through your code.

    If you have an IDE that doesn't differentiate between table, view, sp, function, you have to...

  • RE: PROCEDURES ENCRYPTION

    I have a rule to allways create objects with encryption, but in development it is commented out: /*WITH ENCRYPTION*/ AS

    At deployment time I just do a replace /*WITH ENCRYPTION*/ with...

  • RE: Transactional Backups for archived data

    Talking about Mission Impossible.

    Data in the database is usually linked and dependant and any change affects it.

    How do you think you can bring archived data back without affecting existing...

  • RE: Worst Practice - Defining Rows that Exceed The Max Length

    I agree that using lots of varchar(8000) for field definitions is generally bad. But I have some configuration or other special purpose tables where varchars may get very long, but...

  • RE: Bypassing Triggers

    Interesting article.

    I just started using context_info a while ago when I found about it in the forum. I developed a UDF that I use in trigger to check for bypass....

  • RE: Temporary Stored Procedures

    My argument against it would be: you have to give the user permission to create objects. Do you want to do that?

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