What is INTVAL( )and where we use Plz any body help me1 4182
What is the difference between a stored procedure and a user defined function in sql server?2 5299
could u plz explain about joins and views?2 2659
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver20053 2855
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)1 4634
Anyone please explain me the concept of Serialization?3 2753
can any one please send sql quries most used in applications.2 2228
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;13 12091
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
your distribution database is full what will u do
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Why do you want to join software field as you have done your BE in Electronics?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Scalability, Availability, Integration with internet, etc.)?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is Lock table in SQL?
what is checksum in sql server.........???
how can u get last observation in an unknown dataset ?
What are the dis_advantages of stored procedures, triggers, indexes?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
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 A
ow to bring suspect mode datbase online from scratch
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.