Viewing 15 posts - 1,951 through 1,965 (of 13,469 total)
is the image datatype actually a text file or something stuffed into the column? what is in the image column? a real image? html rtf or something?
if the base type...
February 24, 2015 at 9:20 am
well, you can visualize the desired data with a join,
/*--results
name unit Lab
------- ----------- ------
abc 1 ...
February 24, 2015 at 9:16 am
by "damaged" or "corrupt", maybe it's permissions.
files under /user , like [my documents] and your desktop, are not typically accessible to OTHER users, unless they are admins/domain admins.
so if you...
February 24, 2015 at 8:06 am
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...
February 24, 2015 at 7:21 am
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 ...
February 24, 2015 at 7:06 am
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.
If you can install CLR...
February 23, 2015 at 12:31 pm
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...
February 23, 2015 at 12:06 pm
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...
February 23, 2015 at 11:58 am
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...
February 23, 2015 at 11:48 am
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...
February 23, 2015 at 11:42 am
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...
February 23, 2015 at 10:46 am
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...
February 23, 2015 at 8:40 am
SELECT TOP 100 a.name,
b.name,
...
February 23, 2015 at 8:34 am
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...
February 23, 2015 at 8:06 am
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?
February 23, 2015 at 7:14 am
Viewing 15 posts - 1,951 through 1,965 (of 13,469 total)