SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Monday, April 29, 2013
Verifying Foreign Keys in MS SQL Server
›
Today I was checking one Demo database and surprised to see that foreign key columns contained some values which were not stored in the ref...
Tuesday, April 23, 2013
The database cannot be opened because it is version 706. This server supports version 661 and earlier
›
Today I was trying to Attach a database in SQL server 2008 R2. I got below error while attaching database: This is because the data...
Monday, April 22, 2013
Get the list of parameters for Stored Procedure
›
You can get the list of parameters for Stored procedure in two ways: Solution 1 SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPEC...
Monday, April 15, 2013
Cannot insert an explicit value into a timestamp column. Use INSERT with a colimn list to exclude the timestamp column, or insert a DEFAULT into the timestamp column
›
You will get below error while inserting data into table with TimeStamp column: Cannot insert an explicit value into a timestamp column. ...
Monday, April 8, 2013
Error Message 3241
›
You may get below error message on your screen during SQL server database restore: “An exception occurred while executing a Transact-SQL st...
3 comments:
‹
›
Home
View web version
