how can i store resumes in database?
Answers were Sorted based on User's Feedback
Answer / raghu
use xml datatype in sql server 2005
If still working in sql server 2000 use ntext datatype
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / prajakta salvi
we can store file name with full path in the database. And
when retrieve we can cal the same. It is then possible to
store any file with any extension.
| Is This Answer Correct ? | 0 Yes | 3 No |
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
How to end a stored procedure properly in ms sql server?
What all db objects can be found in MSDB database of a SQL Server instance?
What is difference between oltp and olap?
Define cursor locking
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
Do you know clustered and non-clustered index?
Explain important index characteristics?
How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?
What are the features of Embedded SQL
What is normalization? Describe its different types.
What is compound operators?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)