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 answer2 2194
Comment,Datatypes are unlimited
What is dataset and its uses2 2035
How 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 2421
syntex of insert7 2835
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 balance1 1508
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?1 6922
what is package configuration variable?How to change file name in folder dynamically?Plz help me1 1453
How to truncate a table first before running a package?1 1970
How you trouble shoot when any job fails
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
System variable and temporary variables
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Scalability, Availability, Integration with internet, etc.)?
application server is slow what may be the problem
which backup strategy you are following at ur company
What is data modeling and Reterminal integrity?
What is RMS migrations?
how can you attach more than 20 ldf files in sql server
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
tell me the disaster recovery plan
How can we call UDF(User Define Function) using C# code in ASP.net ?
You are doing log shipping due to some reasons it is failing. How you will proceed from there