What is a trigger?4 3972
What is a view?6 4890
What is the basic difference between clustered and a non-clustered index?9 30732
What are cursors?8 5274
Which TCP/IP port does SQL Server run on?2 7527
From where can you change the default port?3 4298
Can you tell me the difference between DELETE & TRUNCATE commands?15 14649
What is the use of DBCC commands?4 5562
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.1305
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?2 2435
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?11 20460
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?)
How you trouble shoot when any job fails
If the job running very slow what is the action you do
what exactly sql injuction.how to overcome.....
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
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.
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
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
How to convert a table data in XML format in sql server?
your distribution database is full what will u do
Working with TLogs
how many no of arguments can be passed in procedures and functions
last function used in MS Access to convert sql what function will use in sql
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.
What are the dis_advantages of stored procedures, triggers, indexes?