How to connect ms access to sql servers through odbc?
No Answer is Posted For this Question
Be the First to Post Answer
statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance
What are the restrictions that views have to follow?
what types of replication are supported in sql server? : Sql server database administration
how would you improve etl (extract, transform, load) throughput?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
define and explain the differences between clustered and non-clustered indexes.
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the order in which the sql query is executed?
hi i gone though satyam interview. what is Acid Properties?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers
What is the partitioning method?