Can anyone explain difference between Database, Data warehouse and Data mart with some example?````4 3467
how to get max salary with employee number by using one select query and max function ??3 4215
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 2147
Write a query to get all details of employee who has maximum salary from employee table8 9366
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 6703
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 5477
what is the difference between table and view1 1496
plss anybody specify tha constrian management system in dbms821
How to genrate automaticlly empid like gt0014 2531
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?3 4058
Does any body please help me what question's have asked for SSRS in the interview?
How we create SQL Server 2005 Reporting Services ? Give me Sample
what exactly sql injuction.how to overcome.....
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
SQL Server Architecture ?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Tell about MOM Tool(Microsoft Operator Manager)?
Delete duplicate rows without using rowid.
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
System variable and temporary variables
wat wil hapn if we give the both read and deny read permission to user?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
where the connection string store in the database
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it