Hi experts,
what is the scope of # and what is the scope of @
create table #temp(COLUMN01 VARCHAR(500))
DECLARE @TEMP TABLE(COLUMN01 VARCHAR(500))
thanks in advance
Vinod
Even you learn 1%, Learn it with 100% confidence.
Hello,
I am trying to insert records in a table say "TableB"
from "TableA". If a record does not exist in Tableb
then and then insert record from tableA.
as of now my query is
insert tableB
select * from tableA
where id not in(select id from tableB).
I am working with about 200000 records. This query is taking too long. Does any one have a better suggestion.
Thanx for your time.
Hiku
Excuse me for not putting a better name to this but I cannot think of asuitable subject title!anyway, here's what I am trying to doAt work we have a fair amount of data that is to do with people and whatjobs they have completed and at what dateso for exampleJoe Bloggs did design work at 12/12/2004 and spent 5 hours on it.Now, we have a lot of jobs that people haven't put any hours down for atall,and I want to find all those jobs which have had no hours put to them sincethe 30/09/2004I had written a query like soSELECT name, job, dateFROM tableWHERE hours = 0 AND date >='30/09/2004'But this doesn't work as some jobs may come up which have had zero hours onsome particular dates but on some dates that job does have hours on.What I want is to show since 30/09/2004 any jobs which have had no hours atall booked to them consistently.So in effect all the jobs we know longer use and haven't since that date.How would I do that?I know you can probably only give me a vague idea as I have provided notable structure etc.. but I only want a hint really...ThanksJayne
View 2 Replies View RelatedWith out any BEGIN Transaction statement , i ran a update query.
I had to update just one record using the "Where field='abc'"
But i happened to miss that. Is there any chance of recovery? can i use the transaction logs to bring back the records before the update?
A quick answer is appreciated.
Sahel
If you put an index on an integer type column named 'test_column' in a table that had 1,000,000,000 rows in it, and you said select top 50 * from test_table WHERE test_column = 1 since 'test_column' has an index, that would perform extremly fast wouldn't it? Cheers
View 5 Replies View RelatedHow to build a powerful search capability in SQL Server 2005?TIA
View 2 Replies View Relatedhello.
How to do Search in the method which is done in MSDN library 2005 (local application)?
i.e enabling a search filter and then (most incredibly) as you type the criteria, the
list gets updated depending on the characters entered.
for eg. you type: loo
and obtain the following display:
Look in dialog box
Look tab
lookaheads
l
l
l
l
l
l
l
l
l
l
l
l
l
How to use this fast searching technique in vb.net 2005 and the items to be searched in
sql server 2005 express??
Hi,
I need to implement a search procedure for my site that is able to traverse so many tables for results but at the same time making sure not to expose information that is sensitive and I sort of need help to do this as I have not actually done one as big as this one. I need to go through data on Petitions, users, schools and so many other tables in my database to find strings that match the search criteria but I am also conscious that this may cause some security problems with the way I think of it now and i was wondering if any one has a better idea on how to write a search procedure to allow user's to search my site for information.
Thanks in Advance
I have an existing Access database that I need to transfer over to a more powerful back-end due to the need for larger size capacity. We need to be able to have a backend that can exist up to just about any size due to us scanning in documents by ODBC. With Access I know I was limited to about 4gb size and when split onto my current SQL server I have heard I will be stuck at 10gb? If so can you recommend a better backend, but my question is about the front end. I hear Windows WPF can be linked into SQL server but does this limit the size as well?
View 3 Replies View RelatedHi,
We have recently upgraded our production server from a dual pentium II 400mhz server with 384Mb of RAM to a triple 700mhz Pentium III system with 2gb of RAM . However, since switching over, all of our Access queries on the SQL7 databases are either running extremely slowly or not at all despite the DSN's being set up correctly . Does anyone have any ideas why, and more importantly, how I can resolve this???
Thanks
Pete Burton
(IT Support)
Durham Aged Mineworkers Homes Association