Forum Replies Created

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

  • RE: how to download yukon 2005

    To get the full SQL Server 2005 (ex Yukno) you need to have an MSDN subscription or be on the official Beta Program. You could try having a play with...

  • RE: INSTALLING DATABASE WITH OSQL

    It looks like you are using SQLExpress - if this is the case then this uses the sqlcmd.exe utility, it has a similar syntax to osql 

  • RE: storing image

    BOL says up to 2 GB in a single value. But note that if you are using the MSDE version of SQL Server the max size of the DB is...

  • RE: Outer Joins

    I would not use the =* *= syntax; BOL states that syntax may not be supported in a future version of SQL Server. Instead use the ANSI SQL-92 syntax LEFT OUTER JOIN...

  • RE: Insert, Delete locking

    You can add the "with(ROWLOCK)" to the inserts and deletes. I always add this to UPDATES, INSERTS and DELETES and the "with(NOLOCK)" to SELECT statements. Also I have noticed in...

  • RE: Calling SQL-scripts

    Hi,

    you can call another script from within an osql script (like oracle @) by using the osql !! command to call another instance of osql.

    e.g script1.sql

    !!osql -d -U  -P -S -n -i...

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