Hi All, The above link is really good.As of now i understand 'Statistics are used by the query optimizer to estimate the selectivity of expressions,...
What I understand from differnet BOL ,,,when we run a sql query the query optimizer checks all the possible query plan and take that query which has...
Thanks It is working. Litu
declare @servervarchar[10] set @server='server x' @server.databasename.dbo.sproc It is not working.I need to give variable in place of server name in...
Yeah,I have SP4 and I have access on the c Drive. quote:Originally posted by satya I'm getting desired results at my end, hoping you have SQL 2000...
both server and client installed in the same m/c. running from the server. quote:Originally posted by satya Are you running from the server or...
I ran the following query: getting null result. exec master..xp_cmdshell 'OSQL.exe -E -dnorthwind -q"select * from sysobjects" -o"c: esults.txt"'...
Update t2 set salary=T1.salary from table2 t2 inner join (Select id,max(salary) as salary from table group by id) t1 on t2.id=t1.id showing syntax...
Thanks Satya/MohammedU Now I am able to decrypt using othe tool.. quote:Originally posted by satya See on that link Mohammed referred you on the...
Thnaks for your suggestion. The link is not opening http://www.microsoft.com/learning/exams/70-431.mspx can you send me some sample paper for...
Hello, I don't have exp about any Ms certified exam as of now. I am interested more in T-SQL programming. so which Exam should I do first? Plz...
Hi, Is there any exam need to be passed prior 70-441. rgds, Litu
I am getting the following msg while trying to decrypt.. Server: Msg 512, Level 16, State 1, Procedure sp_decrypt_sp, Line 7 Subquery returned more...
Update table2 set table2.salary=table1.salary from table1 inner join (Select id,max(salary) as salary from table1 group by id)table2 on...
I have 2 tables.. table1 and table2 table1 id salary ------------------- 11000 12000 23000 24000 32000 36000 38000 table2 id salary...
Thanks for ur information.But I did not get u. Can u plz tell me in more details. thanks, Litu quote:Originally posted by Haywood Most of the...
Thanks.But I am already having decrypt sproc ,by using that I was able to decrypt so many encrypted sproc.but in few cases while trying to decrypt...
Hi All, While trying to delete any encrypted sproc, It is getting deleted automatically.plz tell me how it is happend. plz show me the way so that...
Hi All, I wanna be a Microsoft Certified Sql sever 2005 database Programmer as well as Store procedure expert. Can anyone Tell me which exam would...
Thanks every one.Appreciate your help. Regds, Litu
Separate names with a comma.
