|
sometimes people just don't get it even when you are very clear about what you want. Could you please tell what Sql queries do someone has to send?
Regards
- J O N -
|
|
|
|
|
Check your Answer 
SreejithAchutan wrote: Subject:Re: SqlQueries
SqlQueries[^]
SreejithAchutan wrote: sql queries for programming
sql queries for programming [^]
 B Specific and Clear About Your Question 
|
|
|
|
|
Use Google
enjoy with Googling.... you will get everything
Pavan Pareta
|
|
|
|
|
if i run my view in the Designer at hte Enterprise manager i get that error message.. but if i run it through the SQL analyzer it's fine it wont have any errors.. 
|
|
|
|
|
You are Using any field which is keyword
so use all field name with [] ex//
Select name,group from employee
Select [name],[group] from [employee]
Best Regards,
Chetan Patel
|
|
|
|
|
ei tnx so much..
at least now i got a hint cause i dont know where to start fixing that error..
|
|
|
|
|
In a transaction block if any error for insert or update occures (e.g. caused by foreign key-primary key constraint violation) does the transaction automatically rolls back or do we need to manually roll it back ?
|
|
|
|
|
Syntax will go like this:
<br />
Begin Try<br />
Begin Transaction<br />
--Your Line of code<br />
Commit Transaction<br />
End Try<br />
Begin Catch<br />
RollBack Transaction<br />
End Catch<br />
--Your line of code<br />
You will have to call commit or rollback for your transaction.....
|
|
|
|
|
Does such syntax really exist ? I am using SQL Server 2000. and I get error when runnig such code.It doesn't know TRY keyword.
|
|
|
|
|
It will rollBack "autopmatically" if you will say so.
E.G.
BEGIN TRAN
your code
if @@error <> 0 goto err
-- more code
if @@error <> 0 goto err
At the end:
commit tran<br />
return 1<br />
<br />
err:<br />
rollback tran<br />
return 0
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
Am developing a online shopping website.I need to develop a search engine that would search items based on its catogery(example i want to search any particular book such as ASP.NET or C# from book catogery).So i want information on what are the search engines available that would best suit to my project.Please help me out..
Thank you...
sandeephs
|
|
|
|
|
do you want to desgin search engine for your site only? means will search only your site content?
kindly explain !!!!
|
|
|
|
|
Hallo;
I would Like to know how to select last insert id from one table so as i can insert it to another table on the same event holder using SQL SERVER 2000 /2005
I am able to do the same using Mysql using the last insert Id function but cannot do the same for SQL server.
briogene
|
|
|
|
|
with the help of
@@identity
and
u can use this query as well
select max(id) from tablename
After the insertion of values
I hope this will work for u
Regards
Avesh
|
|
|
|
|
thanks for this avesh it works
briogene
|
|
|
|
|
Your Welcome...
Regards
Avesh
|
|
|
|
|
You really shouldn't do either of these, as they are both pretty bad practice. If you do a select on @@identity, you get the last inserted identity column regardless of scope. So, suppose you insert a record into your table and there is a trigger behind there that inserts into another table with an identity column on it, @@identity returns the id of the trigger insert and not the main table.
SELECT max(id) only works if there aren't multiple people posting into your tables at the same time.
The simple solution is to use:
SELECT @ID = SCOPE_IDENTITY() This returns the identity of the inserted item on the main table, even if you have lots and lots of trigger inserts going on.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Select scope_identity()
-- modified at 5:31 Monday 22nd October, 2007
Best Regards,
Chetan Patel
|
|
|
|
|
Hi Everyone,
I have a file named as "File1.txt" from "MachineA" that is under shared folder only. But my SQL SERVER 2000 is in "Machine B". I am doing sending from SQL Server 2k using Jmail.
I want to access the network file "File1.txt" from "MachineA".
If, I give machine name or ip. it doesn't take. simply it skips the attachment file and it sending only mail. If i stored the "File1.txt" in "MachineB" then its sending correct.
Please give me some idea.....
Thanks & Regards
Kumaran
|
|
|
|
|
Remember that your JMail job is running as the user that runs the SQLAgent service. I'd check to make sure this user can access the UNC you are referring to.
Try logging into the console as your SQLAgent service account and running the job interactively.
Hope it hlps.
/*
Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA
*/
|
|
|
|
|
Hi all!
I am wondering how can I do this; here's my situation...
"I would only want to retrieve the first 5 records from the query that was executed... so lets say there is 100 records matching the query expression, but i wouldnt want them all but only retrieve the first 5..."
Thanks in advance!
Regards,
Jensen
|
|
|
|
|
SELECT TOP 5 *
FROM YourTable
|
|
|
|
|
Works like a gem!!
This make me wonder, is it possible then to display the next 5? after the first 5?
Thanks in advance!
Regards,
Jensen
|
|
|
|
|
Here is a "quick and dirty" offer of a solution:
<br />
select top 5 productid into #temp1<br />
from table1<br />
<br />
select top 10 productid <br />
from table1<br />
where productid not in<br />
(select productid from #temp1)<br />
-- modified at 9:29 Monday 22nd October, 2007
You always pass failure on the way to success.
|
|
|
|
|
If they've got identity columns and you've ordered them based on the identity then:
SELECT TOP 5 ... FROM MyTable WHERE <<Criteria>> AND ID > @ID If you pass in 0 to @ID the first time, you'll get the first 5 records. If you pass in the ID of the last record from the first select, you'll get the next 5, and so on.
Deja View - the feeling that you've seen this post before.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
