Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 601223
Diffrences between sql server 2000 vs 2008
please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
how can we know that how many users are connected in perticuler server??????2 3770
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?1 2346
how to insert the values in 5 table at a time Using any single statement ?6 7765
hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.963
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?1 3204
Do you know nested transaction?
What are the advantages of paper records?
Does an index slow down updates on indexed columns?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Can we add a cpu to sql server?
What are “lost updates”?
What are the recovery models for a database?
What are the types of stored procedures in an sql server?
What are “phantom rows”?
Difference between Sql server reporting services and Crystal reports?
Explain activity monitors
How can I create a report based on a query? : sql server management studio
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is dknf in normalization form?
Explain cursor as data base object?