Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Request Friendship



Upload Image

My Sections

Marc Jellinek
96 · 2% · 586

Marc Jellinek's Home

My name is Marc Jellinek. I blog at .
  • Where clause

    Marc Jellinek Commented 3 Years ago through Ask
    If your IDs are in a continuous range, consider using BETWEEN SELECT id, name FROM employee WHERE id BETWEEN 1 AND 4 You can even parameterize and use variables: DECLARE @start int, @end int SELECT @start = 1, @end ...
    mannu2010
    598 · 0% · 61
  • No Batch separator in Dynamic SQL

    Marc Jellinek Commented 3 Years ago through Blogs
    There is no concept within the T-SQL language of a "batch separator". This is a "feature" of the client tools (SQL Server Management Studio, sqlcmd) to separate a string into batches. SQL Server never sees "GO" (of whatever you are using as a batch se...
    Madhivanan JR
    2 · 40% · 13039
  • #0305 - SQL Server - Myths - UNION and UNION ALL - need same name, number, sequence & data-type of columns

    Marc Jellinek Commented 4 Years ago through Blogs
    Here's another interesting item: While the column names will come from the first resultset, it appears that the data type will come from the largest datatype for a given column. DECLARE @table_1 TABLE ( [id_1] [int] ) DECLARE @table_2 ...
    Nakul Vachhrajani
    4 · 36% · 11648
  • EncryptBy Key and DecryptByKey

    Marc Jellinek Commented 4 Years ago through Ask
    I'm not sure what your question is. From the statement "I am stuck at the part where I call the SP with parameters in clear text", are you having problems calling the stored proc from your ASP.NET code?...
    raghu1
    1441 · 0% · 15
  • Efficient filtering on Datetime column

    Marc Jellinek Commented 4 Years ago through Blogs
    Another option: Alter the original table to create two persisted, calculated columns based on MONTH([sales_date]) and YEAR([sales_date]), then create an index on both. The index will be small, compact and very easy to search. Now you can directly...
    Madhivanan JR
    2 · 40% · 13039
  • #0287 - SQL Server - Database Design - Can a Computed Column be used as a Primary Key? [Msg 1711]

    Marc Jellinek Commented 4 Years ago through Blogs
    In most cases, this is a horrible idea. Using a computed column as a primary or candidate key violates the rules of normalization. By definition, a computed column is dependent on the data used in the calculation. By definition, a key shoul...
    Nakul Vachhrajani
    4 · 36% · 11648
  • Len function doesn't count trailing blanks of words

    Marc Jellinek Commented 4 Years ago through Just Learned
    @Vipul, the thread is about strings, not ints. As you note, an int is always going to take up 4 bytes, there is no reason to use LEN() or DATALENGTH() on an int....
    Alok Chandra Shahi
    70 · 3% · 810
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.