Where are magic tables stored ? Is it in the same database
where it is created ?
Answer Posted / digvijay kumar singh
yes, magic table stored in current databse.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What are the reporting services components?
What is the difference between left and right outer join?
What is a Join and explain its types?
what is an index? : Sql server database administration
Explain different backup plans?
What is faster join or union?
How to query multiple tables jointly?
what is unique and xaml nonclustered index
What are the new features of sql server 2008 r2 reporting service?
What is difference between foreign key and unique key?
Explain transaction server isolation?
Can we insert data into a view?
Why variables called the most powerful component of ssis?