Forum Replies Created
Viewing 15 posts - 7,891 through 7,905 (of 13,460 total)
-
RE: plz provide the correct answer
homework question:
Auto commit has been turned off.
1- William logs into the database
2- Julianna logs into the database
3- William sees 12 rows in the TOYS table
4-...
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: Monitoring databases
you posted the same question in a SQL 2000 forum here:
http://www.sqlservercentral.com/Forums/Topic1080006-5-1.aspx
in that thread I had posted a link to aaron bartrands blog on how to read the DMV's to find...
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: Subquery returned more than 1 value.
your ttableB.Earlylate has more than one value...you might want the MAX date or the MIN date, depending on your logic, instead
update tableA
SET TableA.validateTime = (select MAX(tableB.Earlylate) from tableB
where tableA.ID =...
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: Divide by zero error
assumning if that field HF00340 is zero, you want to set that result to zero, else the calcualtion:
Update a
set HF56390 =
CASE
WHEN HF00340 = 0
THEN 0
...
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 Express, Windows 7
yes SQL Express will run on Windows 7 no problem.
Express, by default, does not set itself up for remote connectionsso users can't access it from other machines immediately... so...
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: Hierarchical List of All tables
actually, MS provides a stored procedure that will give you all objects(procs, views, tables, etc) in dependency order:
try this in SSMS:
EXEC sp_msdependencies @intrans = 1
if...
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: Need to change the colation of a existing database
vishnubhotla.uday your solution is changing the collation of the master database, and then the default collations of each of the databases...that's only 5% of the solution,and typically you need 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: Linked server error
i think you are abstracting stuff out, and leaving out critical details.
show us the EXACT command you ran. it really sounds like you say you did one thing, but actually...
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: Linked server error
'LinkedServerName' was the example...you never mentioned the name you gave that server, so all i could post was examples i thought would be intuitive enough that you knew you'd need...
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: select column1 of table1 that doesnot contain in column1 of table 2
that's the difference between a JOIN(INNER JOIN) and a LEFT OUTER JOIN
inner joins only show matches, where OUTER JOINS (LEFT and RIGHT) can show you where something doesn't match, if...
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: Storing HTML into a XML-field
In addition to what Sean said, a lot of out-of-the-box portal software, like Dot Net Nuke and Sharepoint store the html in fields in the database, for dynamic content; codebase...
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: Linked server error
you can set up the linked server so if a specific local user tries to use the linked server, it uses a different set of remote credentials instead:
the way 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: Linked server error
diagnose the linked server before using it in your code;
if you run EXEC sp_tables_ex 'LinkedServerName' do you get any results? in theory, it will return all available tables fo rthe...
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: same data/schema/indexes/statistics - different execution timings?
another pair of eyes can certainly help; can you post the execution plans from each server so we can see them too?
so many talented folks here, one person might see...
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: Small doubt in query.
your on the right track; a case statement can help you filter your resulting value;
it might not be obvious, but a CASE statement can have more than one test ,...
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 - 7,891 through 7,905 (of 13,460 total)