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?)

669

How you trouble shoot when any job fails

629

If the job running very slow what is the action you do

663

what exactly sql injuction.how to overcome.....

1262

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1096

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.

315

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?

816

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

317

How to convert a table data in XML format in sql server?

1350

your distribution database is full what will u do

907

Working with TLogs

640

how many no of arguments can be passed in procedures and functions

3421

last function used in MS Access to convert sql what function will use in sql

807

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.

1217

What are the dis_advantages of stored procedures, triggers, indexes?

902