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...
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...
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 have 2 tables.. table1 and table2 table1 id salary ------------------- 11000 12000 23000 24000 32000 36000 38000 table2 id salary...
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...
emp(name varchar(10),age integer) is a table declare @var varchar(20) select * from emp I want to print the above query result through @var...
emp is a table name in sql2000 sqlcmd -q "select * from emp" -o" C:c.txt" showing error: incorrect syntex near q
the foloowing table is emp table name salary X 10000 Y 20000 Z 2000 SELECT 'The SAL is VERY LESS' + CAST(SAL AS...
If I want to save the output of "select * from <table>" in C:/file.txt then what will be the store procedure? Thanks, Litu
When I execute any select statement, output should be saved in a file specified in a store procedure.How to write this type of store procedure.
Separate names with a comma.
