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 60
1533please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
TCS,
1 5465how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?
1 2712hi ..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
IBM,
2373Hi, 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.
1232If 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 3763
What are policy management terms?
Can another user execute your local temporary stored procedures?
What is the xml datatype?
What is checkpoint process in the sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is the difference between functions and scalar functions?
What does the on update no action do?
How to add the custom code in Report?
Which are the new data types introduced in sql server 2008?
How to filter records of table in SQL SERVER?
What is the difference between varchar and varchar types?
What are the approximate numeric data types?
Why do you need a sql server?
How to create a new login name in ms sql server?
How do I find my localdb version?