What happens if you insert a duplicate key for the primary key column in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between stored procedure and function?
What are exact numeric data types in ms sql server?
What is trigger and different types of Triggers?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
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 analysis service repository?
What is difference between inner join and full join?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is service broker?
How to see existing views in ms sql server?
What are the differences between stored procedure and view in sql server?
if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition