Viewing 15 posts - 991 through 1,005 (of 2,008 total)
prashant-507002 (12/9/2011)
Are there any session point like oracle database to which we can rollback?
They are there but you have to define them in transactions. It's called save points.
SAVE TRANSACTION (Transact-SQL)
December 9, 2011 at 6:41 am
prashant-507002 (12/9/2011)
This is vertically data storageI can not put the hard code fieldname bcz user can add more field name in it.
You answered my question indirectly. Is there any good...
December 9, 2011 at 6:38 am
prashant-507002 (12/9/2011)
I have run the update query in ssms without doing begin transaction.Are there any way to rollback the updated data?
If you already ran the statement there is no way...
December 9, 2011 at 6:35 am
Table Name :- DocumentLog
Id FieldName FieldValue
1 Name John Lucas
2 DOB 12/11/1990
3 Amount 5000
4 Name Dev
5 DOB 06/06/xx
6 Amount 0000
Just one question. I added few rows in your table....
December 9, 2011 at 6:31 am
GilaMonster (12/9/2011)
Pradyothana Shastry (12/9/2011)
More Awaited....What??? Got a question?
Que: How to connect SQL Server in single user mode?
Opt: 1 to 4
December 9, 2011 at 6:23 am
haivenki3 (12/9/2011)
@dev: If we split the data, then we might encounter constraint issues, right?
Not necessarily. If you can logically group few tables which are not connected with others with foreign...
December 9, 2011 at 6:11 am
I assume it's going for Index Scan (if table has any index on that field). Your query requirements can be satisfied with Index Seek.
Try field = 10, it will...
December 9, 2011 at 6:07 am
Dhirju (12/9/2011)
which types of backups will be perform, and what is strategy for all sys db
Considerations for Backing Up the master Database
http://msdn.microsoft.com/en-us/library/ms191488.aspx
Considerations for Backing Up the model and msdb Databases
December 9, 2011 at 5:49 am
Lavanyasri,
I am very much confused. In such a case I can’t debug the issue. Also, I am not sure if you have missed on any misc. setting that might be...
December 9, 2011 at 2:47 am
Koen Verbeeck (12/9/2011)
So now I have...
December 9, 2011 at 1:52 am
mhike2hale (12/9/2011)
Thanks for your cooperation!...
December 9, 2011 at 1:32 am
Divine Flame (12/9/2011)
pallavi.unde (12/8/2011)
If i take a back up of database from SQL Server 2008 and trying to restore it in MSSQL 2005 then it shows error that it is...
December 9, 2011 at 12:51 am
I am a programmer that have been assigned the task of building our database infrastructure.
I am sorry to say it's not your specialization & you are taking toooo many responsibilities...
December 9, 2011 at 12:46 am
Sure. What all you tried for it? Where are you stuck?
December 9, 2011 at 12:15 am
Viewing 15 posts - 991 through 1,005 (of 2,008 total)