Can anyone explain difference between Database, Data warehouse and Data mart with some example?````4 3320
how to get max salary with employee number by using one select query and max function ??3 3903
Why foreign key column allowing null values even a parent tables reference key column not having null value..
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....3 2001
Write a query to get all details of employee who has maximum salary from employee table8 8993
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s5 6335
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.1 5240
what is the difference between table and view1 1345
plss anybody specify tha constrian management system in dbms757
How to genrate automaticlly empid like gt0014 2346
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?3 3909
How you trouble shoot when any job fails
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
how to use DTS package in 2000,2005,2008 in sql server
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.
what is difference between view and Dip.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
1 01 101 01010
How to trouble shoot if unable to connect SQL Server
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How we create SQL Server 2005 Reporting Services ? Give me Sample
Why we need to use secondry database file? though, we can do same work using primary database file also.
You are doing log shipping due to some reasons it is failing. How you will proceed from there
what is the Ticketing tool used in Wipro technologies at Bangalore...???
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