Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
3 4706How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
2 4890statement (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
1 3275can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
1 9141what is package configuration variable?How to change file name in folder dynamically?Plz help me
1 3274
How to use values from other tables in update statements in ms sql server?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Sql server reporting services vs. Crystal reports.
Which is the main third-party tool used in sql server?
What is the name of reporting services config file and what’s it’s used for?
what is the system function to get the current user's user id? : Sql server database administration
Explain what is the purpose of sql profiler in sql server?
What is the use of sign function?
How are the exceptions handled in sql server programming?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the default server name for sql server?
How to delete existing rows in a table?
How do I clean up sql server transaction log?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is inner join in sql server joins?