What will be the maximum number of index per table?
What is 3nf normalization?
what is differencial backup?how to work?Anybody explai it?
How to list all user names in a database?
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
What is the difference between stored procedure and functions?
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
what is macro?
5 Answers Excel, Global Innovation, Wipro,
What is optimization and its types?
What is dbcc?
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
How to create a login account in ms sql server to access the database engine using "create login" statements?
What area unit the various kinds of info compression introduced in sql server 2008?