Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Writing Dynamic Stored Procedure

    I suppose I may be confused, but I prefer to write this type of query with isnull...

    where isnull(@Gender,Gender) = Gender

    and isnull(@age+1,age)<=age

    gives the same results as the nested...

  • RE: How to copy and rename database

    Here's what I would do:

    1) detach your datafile (right-click database name -> tasks -> detach). This makes the .mdf file available for copy/rename.

    2) copy & rename your .mdf file...

Viewing 2 posts - 1 through 2 (of 2 total)