Forum Replies Created
Viewing 15 posts - 8,746 through 8,760 (of 13,460 total)
-
RE: select boolean resultvalue based on column value
you'll want to use a case statement:
select
CASE
WHEN thumbid=0
THEN 'false'
ELSE 'true'
END as...
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! -
RE: Deleting Old backup files in SQL Server 2008 is NOT working
i've been lucky, not having to do vb6 for a while as we switched over to .NET, so this is untested.
i think your issue is an error is raised (file...
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! -
RE: Table constraints
interesting use of a check constraint to make a table read only;
could there be a trigger on the table that is also preventing your modifications? depending on the loging in...
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! -
RE: Exporting Image data to local hard drive
in that case, if you cannot access the server's C:\Temp folder as in your example, you'll have to use some intermediate item...a vbscript, your own program, etc to connect 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! -
RE: MS SQL Server Monitor
for SQL 2005, you'll need to open the SQL Server Configuration Manager, i think:(not the Surface Area Config)
from there, you can assign which port the instance will listen to in...
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! -
RE: Exporting Image data to local hard drive
the server thinks C:\ drive is it's own drive....
to write to your PC, you need to use a UNC path:
\\YOURPCNAME\c$\ImageFolder
that might not work if the account that the SQL Service...
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! -
RE: SQL Error
as suggested,
don't assign the id until the end of the registration process....if they don't complete it, you don't save to the database; use a placeholder like ID: Pending if you...
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! -
RE: Replacing Triggers
well, stating the obvious, it depends on what the trigger does;
triggers that are jsut sending emails because a new record was added can be replaced witha job that...
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! -
RE: Export/Import entire database using bcp
i agree with Vivek; if the goal is to copy everything, there are easier ways to do it;
if the goal is to increase your experience with bcp, just as a...
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! -
RE: Winzip use in SSIS
Brandie
It's been a while, but i thought at one point only the registered version fo WinZip has command line options? or is it a seperate application that comes with...
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! -
RE: Changing from INSERT INTO...SELECT (with a UNION) to SELECT INTO
====edit====
where is my jump to conclusions mat? i read like the first few words and made an assumption, sorry...
looking at your post in detail now...now i see it's why the...
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! -
RE: Change Font/Color print error_message() inside cursor?
nope, the font is not dynamically exposed either, even though a richtextbox is being used to display the data;
about the only thing you could do is use a try catch,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! -
RE: Change Font/Color print error_message() inside cursor?
if you are talking about the color of the results in the message panel in SSMS, the only thing you can change is the font size and font type; the...
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! -
RE: Date Conversion to YYYYMMDD
the convert finction has an optional parameter when you convert to varchar specifically for formatting things to dates;
you want to use the 112 format stype:
SELECT CONVERT(VARCHAR(35),@date,112)
in your specific example, it'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! -
RE: Help With Modifying this Code
I am deeply relieved that I'm still able to do college level homework for people. We got an A!Sometimes, in the dark of the night, I second guess myself...
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!
Viewing 15 posts - 8,746 through 8,760 (of 13,460 total)