No announcements
Found 4091779 threads
-
0 VotesCreate table in all databases
In this case, your SQL Statement only run in the default database inside OLEDB Connection, so it only create the table in master table.Answered | 5 Replies | 705 Views | Created by SANTHOSH_DBA - Sunday, August 21, 2016 7:31 AM | Last reply by SANTHOSH_DBA - Monday, August 22, 2016 11:08 AM
-
3 Votes
How do i create an xml from a table?
From SQL 2005 onwards you can use FOR XML PATH: USE tempdb GO drop table ...Answered | 3 Replies | 4251 Views | Created by code_warrior - Sunday, September 26, 2010 4:01 AM | Last reply by wBob - Sunday, September 26, 2010 7:27 PM -
0 Votes
Create Table in database on the fly
This as nothing to do with the ADO.NET Entity Framework.Answered | 2 Replies | 610 Views | Created by Vaibhav Bhatia - Friday, June 3, 2016 1:24 PM | Last reply by DA924x - Saturday, June 4, 2016 4:19 PM -
2 Votes
Empty tables in ReportServer database
In ReportServer database, DataSets table stores the list of the shared datasets available.Answered | 2 Replies | 1392 Views | Created by Vincent (dutch) - Thursday, January 21, 2016 4:33 PM | Last reply by Charlie Liao - Friday, January 22, 2016 2:58 AM -
7 Votes
How do I create a fact table?
I must be missing something here because Fact Tables are mentioned everywhere in relation to Powerpivot and data models, however there isn't a single place that I can find ...Answered | 6 Replies | 4702 Views | Created by Maracles - Tuesday, August 20, 2013 3:57 PM | Last reply by Ronald Pihlgren - Wednesday, August 21, 2013 3:43 PM -
0 Votes
Create a new table from existing table
Exactly that, a warning indicating that certain uses of THE aggreagation functions do not take NULL in mind.Answered | 9 Replies | 4437 Views | Created by Badpig - Friday, April 3, 2009 2:50 PM | Last reply by Hunchback - Friday, April 3, 2009 10:07 PM -
0 Votes
Created read-only table
Hmm if you are allowed to CREATE TABLE that means you are the owner, so what do you mean by READ ONLY?Answered | 7 Replies | 5135 Views | Created by Kenrav - Monday, July 25, 2011 11:56 PM | Last reply by Dan Guzman - Tuesday, July 26, 2011 12:07 PM -
0 Votes
Deleting a Table from Database (MS Access)
Indeed I am making a transition from MS Access to C#.Answered | 8 Replies | 4477 Views | Created by edwardlee007 - Friday, May 29, 2015 3:47 PM | Last reply by kumar visakhapatnam - Saturday, May 30, 2015 6:58 AM -
4 Votes
Copying a table structure
Unfortunately whilst it works at my end (SQL express 2005), I think my customer may be using an older version as they have a program called 'Enterprise Manager v.8' ...Answered | 6 Replies | 6624 Views | Created by iGGt - Tuesday, July 14, 2009 2:50 PM | Last reply by iGGt - Wednesday, July 15, 2009 8:03 AM -
0 Votes
Programmatically create database table
I have already found that website, but I have no clue how to get "Server" and "DataBase" classes into C#.Answered | 4 Replies | 10850 Views | Created by Mitja Bonca - Sunday, August 15, 2010 11:32 AM | Last reply by Dan Guzman - Sunday, August 15, 2010 2:02 PM -
0 Votes
How to create a table dynamically
Do you really need to create the target tables at run time?Answered | 5 Replies | 3864 Views | Created by Nagaraju.Padala - Tuesday, January 15, 2013 10:38 AM | Last reply by Gavin Campbell - Friday, February 1, 2013 3:47 PM -
0 Votes
Can I create a database without accessing model database tables?
, Thanks for your reply When i am trying to create a new database it automatically created with the MODEL Database ...Answered | 5 Replies | 1004 Views | Created by Rajendra Boyapati - Saturday, September 27, 2014 2:05 PM | Last reply by Satish Kartan, MCITP - Sunday, September 28, 2014 3:57 AM -
1 Votes
How to grant Create table permission in tempdb?
Users need permissions the table schema in addition to database level CREATE TABLE permissions.Answered | 10 Replies | 12267 Views | Created by Julie Elizebeth Sam - Tuesday, June 7, 2016 7:17 AM | Last reply by Erland Sommarskog - Wednesday, June 8, 2016 9:05 PM -
0 Votes
dynamically creating and populating tables
If I could get the data into the database, I could easily write some dynamic SQL to stage it over.Answered | 4 Replies | 3782 Views | Created by JustinRush - Friday, February 19, 2010 2:06 PM | Last reply by JustinRush - Friday, February 19, 2010 4:10 PM -
0 Votes
Table Structure
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements ...Answered | 7 Replies | 3614 Views | Created by Kapil.Kumawat - Friday, March 15, 2013 9:51 AM | Last reply by Kapil.Kumawat - Sunday, March 17, 2013 4:56 AM -
1 Votes
Create Time Dimension From Existing Table
However, the issue with the existing server time dimension cannot be addressed by creating a table in the database and then creating a ...Answered | 4 Replies | 1970 Views | Created by ansonee - Thursday, November 17, 2016 2:12 PM | Last reply by ansonee - Thursday, December 8, 2016 1:32 PM -
0 Votes
Creating table in expression blend
if you need to create a table structure from GUI then also you can use gridview.Answered | 4 Replies | 6972 Views | Created by GerDa-zHen - Friday, January 2, 2009 6:44 AM | Last reply by GerDa-zHen - Monday, January 5, 2009 1:34 AM -
0 Votes
Create Create table statement dynamicallly
Hi SSAS_5000, If you don't care about the constraints,dependency on the Table Employee and what you'd like is the table structure, you ...Answered | 4 Replies | 783 Views | Created by SSAS_5000 - Wednesday, March 4, 2015 8:19 PM | Last reply by Eric__Zhang - Thursday, March 5, 2015 12:25 PM -
3 Votes
add new table in an access database and copy all content from an existing table to new table
If there is a way to directly export a DataSet/DataTable as a new table in a Microsoft Access database I am not aware of it.Answered | 8 Replies | 3128 Views | Created by johmolan - Sunday, August 30, 2009 11:40 PM | Last reply by jwavila - Monday, August 31, 2009 6:31 PM -
0 Votes
Creating LookUp Tables
I use Kalman's method and then create views for each type in order for it to make sense to users with direct access.Answered | 3 Replies | 2217 Views | Created by Ryan0827 - Thursday, November 15, 2012 7:54 PM | Last reply by Tom Phillips - Thursday, November 15, 2012 9:10 PM
No announcements
