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...
set @server='server x'
It is not working.I need to give variable
in place of server name in...
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...
Is there any exam need to be passed prior 70-441.
I have 2 tables.. table1 and table2
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...
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
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?
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.