Forum Replies Created

Viewing 15 posts - 11,476 through 11,490 (of 13,460 total)

  • RE: String comparisons Am I going Mad?

    for varchar strings, the = comparison operator strips out ending whitespace.

    that is different fromt eh LIKE operator...if you do LIKE 'phrase %', that would not find the item because of...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 4, 2009 at 11:17 am

    #953447

  • RE: restoring a backup from sql server 2008 to 2005

    compatibility level just decides which syntax rules will be applied against any queries hitting the database...it does not change the behind-the-scenes way the database is stored/saved.

    that's why you can switch...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 4, 2009 at 11:12 am

    #953440

  • RE: CASE Statement

    all minor syntax stuff; i found three things:

    the higher case statement for a.staff said case a.staff andf then had WHEN a.staff...; should be one syntax or the other...

    second...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 4, 2009 at 8:22 am

    #953244

  • RE: Revoke Access to Groups

    it'd be something like this:

    --kick everyone off no matter what!

    ALTER DATABASE [YOURDATABASENAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    GO

    --make sure it's really just for me

    ALTER DATABASE [YOURDATABASENAME] SET SINGLE_USER

    GO

    --do...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 4, 2009 at 7:16 am

    #953163

  • RE: Search "substirng" in each columns of table

    your question reads like it came straight from a problem in a textbook...telling us what the required results are...are we doing your homework?

    what have you tried so far?

    I can tell...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 4, 2009 at 7:07 am

    #953146

  • RE: Revoke Access to Groups

    i'd just set the database to single user mode, do my work, and then change it back to multi user;

    no fiddling with groups, and you'll know you are the only...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2009 at 6:19 pm

    #952811

  • RE: Aggregate Function / Group By

    if you use GROUP BY, then every column that is not using a SUM() or AVG() or other grouping operation MUST be in the GROUP BY Statement...so your query would...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2009 at 3:44 pm

    #952764

  • RE: Relationships between tables

    you must create the tables with the PK's and FK's...otherwise what you stated....inserting 5 into the child table without checking that the 5 exists in the parent table could occur...that's...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2009 at 11:13 am

    #952614

  • RE: SQL Server Transactions

    it depends on the locks that the update and insert will demand.

    if your update is fiddling with, say, a single row of data, then the update will get a shared...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2009 at 11:09 am

    #952610

  • RE: Relationships between tables

    i guess more information is needed...

    nothing gets handled automatically for you as far as PK/FK's go....you might not be doing things in the right order of operation.

    did you add new...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 3, 2009 at 8:31 am

    #952443

  • RE: Developing query to identify individual days and count them between dates

    there is a real good artical called "calculating work days"[/url] by Jeff Moden here on SQL Server Central that explains the concept and also has a function at the end...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 2, 2009 at 6:17 pm

    #952189

  • RE: Speeding up updates that use STDEV (standard deviation)

    can you show us the execution plan when you run the update? that will tell us exactly what the update is doing, and allow us to offer suggestions like indexes...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 2, 2009 at 4:34 pm

    #952172

  • RE: How to find out when a table was dropped, and by which user?

    there's a script contribution that would load the default trace into a table for review:

    Load All 5 Default Trace Files[/url]

    maybe that will help

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 2, 2009 at 5:04 am

    #951764

  • RE: CURSOR READ SP_WHO2

    there you go Jeff; Call Microsoft and tell them that the premiere RE-BAR avoidance specialist is offering to rewrite any of their 194 stored procs at the everyday low price...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 1, 2009 at 10:04 am

    #951604

  • RE: Tables List not displaying

    very wierd;

    I have half a dozen DotNetNuke installations either locally, for friends, or on my hosted web site;

    if you are in as sa or admin you should see everything;

    when i...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 1, 2009 at 7:50 am

    #951595

Viewing 15 posts - 11,476 through 11,490 (of 13,460 total)