Not Clear About This Query

Jul 20, 2005

select *From titles

(18 row(s) affected)

Totally 18 records are there in Titles table.

When I query

select title,title_id From titles where title like 'T%' and title_id
like 'M%'

It is returning 2 records.

So,now if I introduce a not in 2 places also it should return 16
records.
Whereas it is returning 14 records. What is the bestway to understand
this.

select title,title_id From titles where title not like 'T%' and
title_id not like 'M%'

Thanks
Ganesh

View 2 Replies


ADVERTISEMENT

Query Plan In Clear Text

Dec 11, 2005

hi.coming from postgresql, i am used to textual references to most of thethings i do with the database. i feel a little lost with all the graphical.i have few questions regarding MS SQL 20001. what is the best (or easiest) way of getting a table definition in text?it could be either a CREATE TABLE sql-query or a just a definition,something like:TABLE thisTableidintegervaluevarchar(10)etc.etc.2a. how do i get a query plan and how do i get it in text.2b. are there planner modes that show more or less of what actuallyhappened, verbose mode perhaps?2c. if i ask for a query plan, will SQL server actually run the query orwill it only produce a plan. if the query is run, does it commit orrollback by default?stig

View 7 Replies View Related

Testing Query Performance - Clear Out Cache

Apr 3, 2006

I am trying to improve the performance of a query. No matter how badit runs the first time, it runs really fast the second time.So how can I tell if I've done anything to improve the query if italways comes back quickly after the first run? I assume thequery/data/plan is in cache - how can I clean it out for my session?Thanks in advance for any help you can provide -

View 4 Replies View Related

Still Not Clear

Jul 23, 2005

hi thank you for this solution Hugo (dutch?) and it's very handy, thankyou but my issue is that we created dozens of views with my function.This functions returns an integer of a date. This function has to give alowerlimit and higherlimit back when dates are out of Calendar range.But i want to read this from the Calendartable ONCE and store it in aglobal variable somewhere in SQL Server. I DON'T want to referencetables in my function. SO read once the lower- and upperlimit and usethis variable/property for referencing in my function!!GreetzHennie*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 11 Replies View Related

How To Clear Table?

Jul 10, 2006

Is there a way to clear all the records in a table in Microsoft SQL
Server Management Studio instead of selecting all the rows and delete?

View 12 Replies View Related

How To Clear Transaction Log

Sep 20, 2002

I'm trying to clear a database transaction log that has gotten much too large. I backed it up hoping that this would clear the "active" log, but now I just have two copies of a huge transaction log. How do I clear the active log?
Thanks in advance.

View 4 Replies View Related

Clear Errorlog In SQL 6.5

Sep 25, 2003

Hi....Does anyone know if there is a similar command to SQL2K's DBCC ERRORLOG.
I'm currently writing a preventative maintenance script and want to force archiving of errorlogs. Any help greatly appreciated.

View 3 Replies View Related

Help Me Clear The Cobwebs

Feb 10, 2006

It's been some time since I've written any SQL so I apologize if the answer to my question is obvious.

In pseudo-code here's what I want to do:
delete from table-1 all rows where the table-1.id = table-2.id and table-1.text = ""

Thanks in advance.

View 4 Replies View Related

How Do U Clear Cache In SQL

Dec 14, 2006

How do u clear Cache in SQL

if i run a query once it takes 10 seconds and if i run the same query again it takes 1 second because it is cached. So i want to know how i can clear it because i want do some benchmarking on a query that is in cache

View 5 Replies View Related

Clear List

Apr 8, 2008

does anyone know how to clear the sql "connect to server" popup server name list

View 13 Replies View Related

How To Clear The Logfile

Jan 15, 2006

Hello guys!

I would like to clear the logfile. Could anybody tell me how to do this?
What I would like most would be to run SQL-Server without any log-file (while development). But I suppose that this is not possible.

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 3 Replies View Related

How To Clear The Whole Databse?

Apr 7, 2007

Hi, my database i am working on is full of crab, who do I clear all the tables info?

View 3 Replies View Related

Clear Log File

Mar 3, 2008

what is the command using to clear the content of log file

View 2 Replies View Related

Clear DB Fields At Midnight

Apr 14, 2004

I have a dataBase named pricesDB. I would like to clear all the prices column everyday at midnight.
How should i do that???

View 1 Replies View Related

Log Dump Does Not Clear Log Space

Oct 25, 2000

When I backup a my transaction log and then run DBCC SQLPERF(logspace) the log shows 12% space used. The backup was run at night long after any transactions had been executed so there should be no active transactions. In SQL 6.5 you could run DBCC CHECKTABLE(syslogs) to clear up the usage inaccuracy is there a similar command in 7.0 to fix the space usage inaccuracy?


--Buddy

View 4 Replies View Related

Clear Log Shipping History

May 18, 2008

I practiced log shipping in my home PC. It works fine. But there are 3 error dialog box populated for every 15 minutes. I enclosed screen shot.

1. DW20.Exe Application Error
2. Visual Studio just-in-Time Debugger
3. Sqllogship.exe Application Error

I got this error every 15 minutes. I delete everything such as maintenance plan jobs, replication, log shipping, mirroring in my SSMS. I can't find out the solution for this error. I didn't know, how to resolve this problem.

Please advice. :eek:
Thanks
Jayasri

View 5 Replies View Related

Clear Server List

Apr 8, 2008

Hi is there a way of clearing the server names from the management studio?

i found the below on the net but i do not have this file to delete?

“All you have to do is delete C:Documents and Settings<user>Application DataMicrosoftMicrosoft SQL
Server90ToolsShellmru.dat.�

View 5 Replies View Related

How Do You Clear Tables Of All Data?

Feb 28, 2006

What is the best way to empty out a table to reset its identity field back to 1?

I was going to do "Generate SQL Script" for all the tables I wanted to reset and then drop and re-create each table. Is there a better way to empty out all of your tables?

View 20 Replies View Related

Clear Data In A Table

Apr 5, 2006

hi
I would like to clear all data in a table called ... How do I do that - and before I do it I'd like the data copied to a another table as a backup .... Please guide me .....
Thanks in advance .....

View 3 Replies View Related

How To Clear The Transaction Log Of Tempdb?

Feb 13, 2007

Hi

How to clear the Transaction Log of Tempdb?(Other than Restarting the SQL server)

Thanks in Advance

Regards
Magesh

View 2 Replies View Related

How To Clear SQL Authenication Username?

Oct 16, 2007

Hi,

I had deleted the login and user in my SQL 2005 database. However, each time when i connect to my database using the SQL enterprise manager, I can still see the deleted username under the login. It seems that the username is stored or cache somewhere after the first time that I have login. Does anyone know how to clear it? I am using SQL 2005 authenication method on 2003 Server machine. Thanks.

Regards,

View 14 Replies View Related

Need Help : SQL Server And Clear Case

Aug 25, 2005

Environment1)We are using VBA,MS Access 2000/2003 and SQL Server 2000 in ourproject.2)We need to use Rational clear case as the SCM tool.Our WorkOur work primarily falls in developing SQL Server stored procedures,functions and few VisualBasicForAccess(VBA) code.Technical Help sought1) Does SQL Server 2000 provide any inbuilt capabilities of SoftwareConfiguration Management(SCM)?Not that I am aware of other thanextending it with other DM management tools like BMC,A&G,VERITAS etc.2)If not, Is there any plug-in available in SQL Server environment thatcan be installed on SQL Server so that any code developed [Storedprocedures/functions etc] can be managed in Clearcase.[I am looking forEclipse plugin's kind of plugins which would enable you to check in andcheck out from Eclipse after the initial configuration is done onEclipse]?3)If plugins are not available then the option we have is, manual andexternal check in and check out the code bits in to Clearcase.Can someone point me to concise and relevant user manual on this.

View 2 Replies View Related

Clear All The Tables Of A Database

Oct 5, 2006

Is there a simple method to clear all the tables in a db or to make a copy of the mdf file without the datas ?

I tried to use TRUNCATE TABLE but it doesn't work with foreign keys ?

Thanks.

View 1 Replies View Related

How Do You Clear/ Empty The Transaction Log

Dec 5, 2007

We want to back up our test db (new application) and then put it back on the box. The transaction log is pretty full (600mb), can I clear this file or delete the data in it -- we do not need it since this is all testing data.

Thanks,
anke

View 1 Replies View Related

How To Clear Or Reset A Microsoft SQL Database?

Sep 30, 2006

I'm writing a web application that saves data to a Microsoft SQL database.  As I build my application, I continually dirty my database with test data and refine my data schema.  Is there a tool that can quickly remove all of the data from 4 of my 5 tables?  Right now I'm using MS SQL Server Management Studio Express to open each table and manually deleting the rows of data and it's a pain in the ass.  Playing around with the Management Express, I was able to generate a create SQL script (I'm afraid to test it though) that looks like it will rebuild my table.  The problem is, one of my tables is a list (index?) of types...and I'd need that data saved
ebuilt each time...but I cannot figure out how to tell SQL that the rows in this table needs to be rebuilt (and is not really data per say).How do you guys "clear" or reset your database during development?-=STZ=-

View 2 Replies View Related

Can I Have SQL Server Clear A Value After A Certain Amount Of Time?

Apr 5, 2004

I have an application that allows users to "reserve" a certain time and location for practice sessions. I want them to look at a web form that shows which times are available and then allows them to select an open slot and then submit this form with some personal information. My problem is that as soon as they select an open slot, other users should see that this slot is no longer available. On the other hand, if someone selects an open slot and then takes too long to type in their personal information, I want it somehow to kick them out and re-open this slot back up.

I know that I can create a field called 'status' in my database that gets turn to something like 'pending' as soon as the first user clicks on an open slot, but how would I turn this field back to the 'open' state if the user took too long to enter their data?

Any help would be surely appreciated.

Cheers,
AzF

View 1 Replies View Related

Clear SQl Server Logs By Run Xp_cmdshell

Nov 3, 2004

how i can clear sql server logs by run xp_cmdshell stored procedure.
(my user in sql server is a admin).
i don't want use enterprise manager . i want write a query and use at xp_cmdshell .
befor thx.

View 1 Replies View Related

How Do I Clear Sql 7 Logs They Are Full And I Am Stuck?

Jun 2, 2000

how do I clear sql 7 logs they are full and I am stuck?

thanks you

View 3 Replies View Related

How Do I Clear Out Available Restore Points For MSSQL Db's?

Aug 14, 2006

I was messing around with backup strategies today at work while contemplating my other db issues.

In doing so, I've made a list of backups that don't truly exist anymore (I deleted the 'backup device' (bleh.bak).

Here's an image, stolen from technet's articles.

http://www.microsoft.com/library/media/1033/technet/images/prodtechnol/sql/2000/maintain/ppc1106_big.gif

See that list of restore points? Mine is full of restore points that have absolutely no meaning in them for a DB I made to test out (testDB).

Is there a way to clean those out?

View 1 Replies View Related

Clear Data Out Of Multiple Tables.

Mar 14, 2007

I need to load a database with new data, from an existing parallelsystem, but the database schema has changed and I did not make a script to do the changes. Sure wish I had. So, now I would like to copy the data from the existing parallel system into the new SQL database that has the correct schema. I have built the new database from the existing changed database. Now I would like to know if there is an easy way to clear the data out of all the tables, then copy all the data from the old schema into the new schema's tables.Thanks!Vic

View 7 Replies View Related

SQL 2012 :: Backup To Clear Transaction Log

Jan 29, 2015

Looking at the recovery model on MSDN - was under the belief from it that if you set your database to use the simple recovery model, then when you preform a full back up it would truncate the transaction log file but this doesn't seem to be the case?We aren't looking to do a point in time recovery for this particular databse.

View 7 Replies View Related

Easy Q: Clear Data In Tables

Jan 4, 2008

I am sorry to post this simple question here but I could not find a right category thread to post this.

I am learning SQL Server 2005 and I have a very simple question.
I have already set up several tables and setup relations between them and have loaded data into tables.
How do I clear all the data in tables ?

View 9 Replies View Related

Unable To Clear Grouped Report

Mar 16, 2007

I had an SSRS 2005 report that had the lowest level grouped instead of printing a detail line (the reports display summary tables that have all the necessary grouping already applied). Every time I tried to clear the grouping, the report designer crashed. In the end I created the report again from scratch.

Should I have been able to clear the grouping or is the conversion from a detail line to grouping, a one-way process?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved