thanks a lot..<img src='/community/emoticons/emotion-1.gif' alt=':)' />
Hi all, I wanted to ask for the naming conventions in SQL SERVER.as in case of pl/sql server we have ..name_of_package.name_of_procedure thats how...
i have some idea like this : CREATE TABLE NewTable ( something here to copy just column names) ON [MyFG1] usually when column names are sfpecfied...
Hi all,<br /><br />this is my problem :<br /><br />SELECT * INTO Sales FROM Sales1 WHERE 0=1 ON [MyFG1] <br /><br />So if anyone can help, i'd like...
Yeah i noticed that...and can u tell me y is it like that????n in wat all cases we have to use ALIASES instead of table name?? Regards, Shuchi.
GREATTTTTTTTTTTTTT Madhivanan!!!!!thanks a lotttttttt....[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]..it worked...
if i m just writtin UPDATE L then it says: Cannot insert the value NULL into column 'PRICE', table 'EXTRAS.dbo.LINKS'; column does not allow nulls....
Yeah thats exactly wat i was writtin before....the query that u sent before was givin other errors so,i wrote: UPDATE LINKS SET L.PRICE = Case when...
Thanks for your reply..but unfortunately it doesnt work....<img src='/community/emoticons/emotion-6.gif' alt=':(' /> it says :<br />The multi-part...
Hi all, my question is just if i have two update commands then how can i join them...here is my update: UPDATE LINKS SET PRICE = 999 FROM LINKS L...
Thank you very much Madhivanan and Adriaan....that was a lot of help...thanks a lot...it worked finally [<img...
i dont want to export result...the purpose is just to check the functionality of my procedure...if it works fine or not...if its showing me the...
i just want to show the data only on the executed screen....i mean the QUERY WINDOW...just when i will execute: ---------------------- USE [Telbill]...
oh thanks for pointin this mistake....i was just wondering y is it showing SE only again n again...but still it didnt solve my problem <img...
hi,i m not able to c the table data....i mean my procedure looks like this:<br />-- =============================================<br />ALTER...
Hi, Thanks a lot druer..i will try on monday if it works...n Madhivanan thanks for the suggestion n there r millions of data there...how to use...
hi, now regarding the same question..i have another problem...now i have to make a function in which the input parameter is a select statement i.e....
oh THANK YOU SOOOOOOOO MUCH...!!!it works...<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />regards.
Hi all, i have a task that whenever i will write a select query then when the result comes then i should be able to write a column that should write...
hi, thanks a lot for your reply..but i tried the following way..n it worked as well.... In SQL Server Management Studio do the following: 1. Right...
Separate names with a comma.
