Forum Replies Created
Viewing 15 posts - 8,551 through 8,565 (of 13,460 total)
-
RE: You'd think I'd have learned...
clicking "Debug" instead of "Execute" more times than I can count.
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: Extract Binary *.doc Files from a table
since you mentioned textcopy, here's pair of procedures to help you use it a little easier. I had this saved in my snippets.
In TSQL, you will have to loop thru...
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: Staying on top of CUs and SPs
Kwisatz78 (10/18/2010)
Hi all - Can anyone tell me how I can be informed about new releases for my versions of SQL. I am wanting to stay on top of...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: How to OPTIMIZE the following
lots of things to change there;
get rid of the old ansi join syntaxes...
get rid of the deprecated *= joins
adding the logic to split the string into a table
minor syntax...
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: Delete record without using Delete keyword
GilaMonster (10/16/2010)
Why on earth are you looking for this? This has all the signs of someone trying to get around a keyword blacklist, maybe SQL injection, maybe code standards, etc.Why...
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: Delete record without using Delete keyword
jaffrey (10/16/2010)
Hai guys,Is it possible, Delete a record without using Delete keyword?
a single record? no...the TRUNCATE TABLE [TABLENAME] command will delete all records in a table. so that deletes records...
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: Can we restore SQL2000 database BackUp to SQL 7
no you cannot. backups are forward compatible, but not backwards compatible...meaning SQL 7 could restore a backup from version 6.5, but not any backups from 2000/05/08.
instead you'll want 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: I want to create primary key after inserting foreign key.
i think your confusing parent-child relationships;
businesswise, the students and the table associated to them are the key/primary table.
information about the parents may or may not be available, so the table...
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: Delete certain backups from a file
Bhuvnesh (10/15/2010)
What does it mean?when you do a backup that does not include the WITH INIT clause, the new backup is appended to the same physical file. So after two...
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: The need to back up system databases?
I'm nearly the same winston; the only info that is in the master database that is special to me is logins, and I've created a script that pulls those out...
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: Silly PRINT question
AFAIK there is no issues with leaving print statements in place; I've never seen or heard of an application suffering due to print statements.
even from an application you can read...
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: Index not getting used when where clause uses variable, index is getting used when value is hard coded.
this is inside a procedure, right?
is @TodaysDate a parameter with a default of NULL?
if that's true, I'm thinking parameter sniffing is the problem, and a bad execution plan is being...
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: Arranging table output
your query is good, all you need to do is change the ORDER BY in order to get it in the desired visual representation.
order by category,price desc;
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: Database Mail Configuration
I've gotten a Gmail account to work just fine; they use an alternate port for SMTP, but the rest was a typical setup:
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: transaction logs full in simple recovery mode?
in simple mode, the log would only have uncommitted transactions in it, right?
could there be a developer or some process that is starting a transaction, but never issuing the COMMIT?...
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,551 through 8,565 (of 13,460 total)