Forum Replies Created

Viewing 15 posts - 4,321 through 4,335 (of 13,460 total)

  • RE: Concatenating Rows to create WHERE clause.

    something like this?

    i need an anchor for the outer query, so i used the columnName;

    your real table might have a queryId or something, i would guess, if you are testing...

    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!

    November 27, 2012 at 9:11 am

    #1562743

  • RE: Not sure why PIVOT returns a single row?

    fixed a syntax issue, and create the DDL for the CTE;

    i got far enough to duplicate the one row issue before i ran out of gas...building the CTE took...

    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!

    November 27, 2012 at 8:47 am

    #1562731

  • RE: Regarding stored procedure

    Eugene Elutin (11/27/2012)

    You may find some less perfectionists around who will not refuse to help you with this...

    ouch! i resemble that remark!

    anyway, even with the caveats we mentioned, and...

    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!

    November 27, 2012 at 7:57 am

    #1562696

  • RE: How do I lock Queries

    what does locking queries mean to you?

    preventing queries?

    reuse the same queries?

    encrypt queries or values?

    you'll definitely have to explain, in much more detail, and preferable with an example query.

    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!

    November 27, 2012 at 7:47 am

    #1562690

  • RE: Transfer Data from Table to TextFile

    bcp.exe is a command line utility for importing and exporting to text.

    it supports using a query, so you can construct a query that uses a WHERE clause that limits your...

    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!

    November 27, 2012 at 6:56 am

    #1562661

  • RE: Regarding stored procedure

    boobalanmca07 (11/27/2012)

    I am using two sql statements in stored procedure,

    the two sql query is update and alter.

    in some times i need to execute update query only,at that time how to...

    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!

    November 27, 2012 at 6:23 am

    #1562639

  • RE: user permission

    i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ; 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!

    November 27, 2012 at 5:58 am

    #1562628

  • RE: New login & Access to DB

    runal_jagtap (11/27/2012)

    Hi Friends,

    i have asked to perfrom a task to create a New login & then provide the access rights to a particular DB..

    I did it with no time 🙂

    After...

    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!

    November 27, 2012 at 5:52 am

    #1562627

  • RE: How to do a full copy of a database onto the same server with a different name

    ok sorry...

    you can restore a database that doesn't exist yet.

    in the object explorer in SSMS, you should be able to expand the server and see the Folder for databases...it may...

    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!

    November 26, 2012 at 2:46 pm

    #1562435

  • RE: How to do a full copy of a database onto the same server with a different name

    back and restore is the absolute fasted.

    lets assume that a FULL backup exists for a given database on a certain server...if it doesn't exist, create one with copy 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!

    November 26, 2012 at 2:10 pm

    #1562418

  • RE: Default connections in instance de Sql Server

    a bit o translation help from Google Translate

    I want to do something programmed to monitor the connections of an instance of SQL Server 2008 R2 Standard Edition. But I 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!

    November 26, 2012 at 12:32 pm

    #1562371

  • RE: acid properties

    was google down?

    explanations you should google yourself; specific questiosn are ideal for the forum.

    http://stackoverflow.com/questions/999394/whats-a-real-world-example-of-acid

    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!

    November 26, 2012 at 11:37 am

    #1562339

  • RE: SSMS with a hosted sql server database

    i use ihostasp.net[/url]

    for some shared hosting, which also includes a SQL2005 database. You can connect to it via SSMS with a name, port schema (ie.server04.ihostasp.net,14430)

    you can use MySQL as well...

    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!

    November 26, 2012 at 11:34 am

    #1562338

  • RE: How to find the database size from a full backup?

    one of the more obscure RESTOre commands can help you:

    this command will present a row of data showing you the size and maxsize of the database, which is almost...

    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!

    November 26, 2012 at 10:02 am

    #1562293

  • RE: VB script error

    those two dll's, java.util.zip.dll? and java.io.dll? need to be in the same folder as the script you are calling.

    they probably are not,and i'm not sure how to insert them...

    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!

    November 26, 2012 at 8:48 am

    #1562265

Viewing 15 posts - 4,321 through 4,335 (of 13,460 total)