1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.369
what is checksum in sql server.........???
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it327
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A383
What is Lock table in SQL?283
Can we call a function that has out parameter in select statement101
Call by value and call by reference in procedure and function, with NOCOPY.164
If we delete pack Spec what will be the status of pack Body ?190
Delete duplicate rows without using rowid.208
how to find 6th highest salary169
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
If the job running very slow what is the action you do
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
System variable and temporary variables
How you trouble shoot when any job fails
can any body tell me how to know the password of current user in sql server
what is the Ticketing tool used in Wipro technologies at Bangalore...???
on line cluster can we make if yes tell me the procedure
If we delete pack Spec what will be the status of pack Body ?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
what is the sql equivaent of the dataset relation object ?
New concepts of sql server 2005 use in your project.
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
how to take backup bcp out for a column in table in sql server?
SQL Server Architecture ?