What is difference between inner join and join?
What is change tracking in sql server?
Is Sql non procedural query language?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What are the types of model in sql server and explain
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 is user stored procedure & it purpose?
What is @@error in sql?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Can you explain about buffer cash and log cache in sql server?
How can I get data from a database on another server?
What are the difference between “where” and “having” clause in sql server?
What are the types of table?