How to store pdf file in sql server?
CarrizalSoft Technologies, College School Exams Tests, TATA,
1 6006please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
1 2711create 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
3 3963need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
1 4370How to get employee name from employee table which is the fiveth highest salary of the table
20 23146hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
IBM,
3 5494
Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How can I create table in mysql?
Write a query to find 5th highest amount paid from the customer table.
What are the advantages of partitioning?
Why do we need mongoose?
what are null values? : Sql dba
How to use online Backups?
What is normalization process?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How can triggers be used for the table auditing?
Can a formula column referred to columns in higher group ?
What is variable and how many types of variable?
What are the various Database states.
Can we do dml on views?