Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 13,459 total)

  • RE: How are these unique keys generated ?

    mar.ko (2/24/2015)

    Thanks.....

    How does the newid() function work ?

    How does it know to create a unique value for a particular table ?

    Why use a GUID vs. Autonumber/Sequence ?

    well GUID is Globally...

    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!

    February 24, 2015 at 7:21 am

    #1779580

  • RE: How are these unique keys generated ?

    they look like guid/NEWID to me, that have dashes stripped and then lowercased. exactly 32 characters, same as a GUID without dashes.

    /*--results

    PlainOldGuid ...

    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!

    February 24, 2015 at 7:06 am

    #1779574

  • RE: Extract pdf file from a sql db

    certainly possible, but you probably need a bit more information.

    this example here, you could adapt, and is assuming there is an identity/primary key to the table.

    http://stackoverflow.com/questions/26541068/how-can-i-bcp-queryout-with-filename-from-table

    If you can install CLR...

    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!

    February 23, 2015 at 12:31 pm

    #1779385

  • RE: replacing string

    do you want to get just whatever is to the right of the last slash, or just remove /user/?

    /*--results

    Samp1(No column name)

    advisoryadvisory

    Peter/ParkerParker

    Harry/OsbornOsborn

    Mary/Jane WatsonJane Watson

    John/Jonah/Jameson Jr.Jameson Jr.

    */

    create table #MyData

    (

    id int identity(1,1),

    webpage varchar(max)

    )

    insert...

    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!

    February 23, 2015 at 12:06 pm

    #1779376

  • RE: Remove the double quote

    kennyhuang0108 (2/23/2015)

    Thank you Lowell.

    Is there anyway i can eliminate the double quotes from my script?

    thank you.

    there are no double quotes generated in the SELECT statement you posted. there are...

    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!

    February 23, 2015 at 11:58 am

    #1779371

  • RE: Remove the double quote

    whatever you are exporting with has got the text qualifier turned on; just turn it off./ set it to a blank string.

    if you were exporting from SSMS via the export...

    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!

    February 23, 2015 at 11:48 am

    #1779364

  • RE: Resolving Data Drift

    To a degree, it probably depends on the requirements;are the other data centers also gathering data, or are they read only? that kind of decides what methodology to consider. sql...

    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!

    February 23, 2015 at 11:42 am

    #1779363

  • RE: SQL Server 2008 - Stored Procedure that triggers another stored procedure

    you can call a procedure within a procedure.

    you have a logical error in your RETURN statmenets; there can be onyl one return:

    CREATE PROCEDURE Adjust_Salary @EmpID INT = NULL, @LatestSalary INT...

    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!

    February 23, 2015 at 10:46 am

    #1779339

  • RE: SQL Agent job not failing when Powershell script errors

    i use powershell + robocopy to copy files, and the format i use will return an error when it occurs; this ight help:

    $SourceLocation = "D:\SQLBackups\";

    $DestinationLocation = "\\gdc-bak-p01\SHARE\CRITICALBACKUPS\HOL\SQL-BACKUPS\HOL-SQL-CL01" ;

    #/E copy directories...

    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!

    February 23, 2015 at 8:40 am

    #1779284

  • RE: How do I get the column type and length. SQL help needed

    SELECT TOP 100 a.name,

    b.name,

    ...

    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!

    February 23, 2015 at 8:34 am

    #1779282

  • RE: Lost access to database

    the full error message would help; my first google for SQL server error 17 seems to imply

    SQL Server does not exist or access denied.

    i'd just assume it's time 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!

    February 23, 2015 at 8:06 am

    #1779269

  • RE: SPLIT A FILE DYNAMICALLY

    why wouldn't a ForEach loop, that dynamically created a folder based on the FileID work?

    then whether it's 10 or 100 FileId's processed, they all go in the logical folder/bucket?

    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!

    February 23, 2015 at 7:14 am

    #1779251

  • RE: Reset all SQL Native passwords across an enterprise

    i don't think you'll find an existing product that does EXACTLY what you are after, but it's a trivial request to do via TSQL.

    there's a zillion examples of random strings...

    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!

    February 23, 2015 at 5:40 am

    #1779230

  • RE: Importing excel file stored in sharepoint into SQL

    can you use a script task to grab a COPY of the file to stick in %temp%, and toggle it's attributes to not be readonly? i had to do something...

    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!

    February 23, 2015 at 5:28 am

    #1779227

  • RE: New SQL Server Express Installation

    In that case, if both iis and sql are blocked, its probably te wi dows firewall. Add two differen exceptio s, one for port 1433 and another for port 80...

    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!

    February 21, 2015 at 10:50 am

    #1779123

Viewing 15 posts - 1,951 through 1,965 (of 13,459 total)