Sql Server Views Interview Questions
| Sql Server Views Interview Questions |
|
|
I connected a SQL Data Source to my GridView and want to Insert Update and Delete. I checked the boxes when setting up the source for the Insert,Update, Delete and Optimistic concurrency. One of the columns shows a date and for some reason when I try to update or insert a row I get the following error:
The version of SQL Server in use does not support datatype 'date'.
Any ideas what it could be?
|
|
|
|
as we know all tables information is saved in sys.objects system view in sql server 2005 ,
how we can select the table names and delete thieir there rows .
|
|
|
|
I made a temporary table query. And I want to save the results of the temporary table as a view dbo file in sql server 2005. But it doesnt let me save the results of the temporary database. I made a temp database, inserted data, then I call the data using select * from #temp database. I want to save it as a view, can it be done? What alternatives do I have to make it as a view?
|
|
|
|
what is materialized views in sql server/oracle
|
|
|
|
does MS SQL VIews consume storage area in the disk/database.
I know MS ACCESS Views consumes space because when I create views the file size increases.
Is this the same for MS SQL server?
|
|