No announcements
Found 851361 threads
-
0 VotesTable Structure
This is not a table; it has no key and cannot ever have a key.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
-
0 Votes
Regarding table structure?
WITH ( au_id VARCHAR(11), au_lname VARCHAR(20), au_fname VARCHAR(30) ...Answered | 4 Replies | 3743 Views | Created by Tridip - Wednesday, July 28, 2010 1:37 PM | Last reply by Tridip - Friday, July 30, 2010 6:30 AM -
0 Votes
Table structures
A simple answer is: CREATE TABLE Regions (RegionName nvarchar(50) PRIMARY KEY, Disaster int, High int, Average ...Answered | 1 Replies | 4088 Views | Created by samuel du pont - Monday, July 11, 2011 4:33 PM | Last reply by SQLWork - Monday, July 11, 2011 8:22 PM -
0 Votes
Update order by in the table structure?
If so, you can only do this in SSMS designer and behind the scenes it creates a new table with the new structure and adds your data there.Answered | 3 Replies | 5838 Views | Created by SQLGuido - Thursday, July 22, 2010 6:19 PM | Last reply by Naomi N - Thursday, July 22, 2010 6:36 PM -
0 Votes
Table structure changes by itself...
And structure changes happens only when you import data by package and not when you doing it manually?Answered | 6 Replies | 5255 Views | Created by Bharathi Morusu - Tuesday, April 27, 2010 6:43 AM | Last reply by Vinay Thakur - Tuesday, April 27, 2010 12:58 PM -
0 Votes
creating table structure
USE some.dbf EXCLUSIVE MODIFY STRUCTURE This also works compiled.Answered | 7 Replies | 589 Views | Created by yanyee - Monday, April 7, 2014 12:47 PM | Last reply by yanyee - Tuesday, April 8, 2014 3:02 AM -
4 Votes
Copying a table structure
cheers, that's definetely a useful little tool, but in this instance unfortunately I only need to copy about 10 tables out of a DB containing hundreds (plus my customer ...Answered | 6 Replies | 6622 Views | Created by iGGt - Tuesday, July 14, 2009 2:50 PM | Last reply by iGGt - Wednesday, July 15, 2009 8:03 AM -
0 Votes
table structure
I agree with Visakh, but you might want to make these changes: CREATE TABLE dbo.Project_Itemtest ( ID int IDENTITY(1,1) NOT NULL, PID int NOT NULL, Item ...Answered | 2 Replies | 774 Views | Created by emaak - Wednesday, July 30, 2014 3:26 PM | Last reply by Patrick Hurst - Wednesday, July 30, 2014 5:48 PM -
6 Votes
Optimal structure for large audit table?
What is the structure of the information you intend to capture and how will it be used?Answered | 3 Replies | 2202 Views | Created by scott_m - Friday, October 25, 2013 1:28 PM | Last reply by Ch. Rajen Singh - Wednesday, October 30, 2013 4:34 AM -
0 Votes
How to Normalize the table structure
Why not having product code table and sub code table with one -to -many relationship....Why do need 0 or 1?Answered | 8 Replies | 1799 Views | Created by BaskaranR - Tuesday, March 11, 2014 2:00 PM | Last reply by Louis Davidson - Wednesday, March 19, 2014 6:55 PM -
0 Votes
3 level authorization table structure
Hi , I have an application, I want add a feature of maker,checker and authorize for every record in a table.Answered | 1 Replies | 2441 Views | Created by Saswat Mohanty - Tuesday, September 2, 2014 11:15 AM | Last reply by Uri Dimant - Tuesday, September 2, 2014 11:44 AM -
0 Votes
Table Structure For Calculator
Much better table structure thank you @davidbaxterbrowne.Answered | 15 Replies | 607 Views | Created by RonPaulWearsRedSocks - Wednesday, September 14, 2016 3:46 PM | Last reply by Tim Konecky - Wednesday, September 14, 2016 7:17 PM -
0 Votes
Table structure or form design question
I suggest that you could refer about Database design basics to create a properly designed database In addition I suggest that you could ...Answered | 4 Replies | 332 Views | Created by Kevin Waddle - Tuesday, June 28, 2016 2:30 PM | Last reply by David_JunFeng - Wednesday, June 29, 2016 5:24 AM -
0 Votes
Table Structure
> i need to represent in Access table.Answered | 10 Replies | 653 Views | Created by KhurramKZ - Friday, August 28, 2015 4:36 AM | Last reply by Edward8520 - Thursday, September 3, 2015 3:17 AM -
0 Votes
SQL Azure table structure
: Designing tables in Azure SQL Data Warehouse You are going to want to use a hash-distributed table approach or partitioned ...Answered | 2 Replies | 787 Views | Created by jwh2 - Tuesday, March 19, 2019 1:48 PM | Last reply by jwh2 - Monday, April 8, 2019 8:54 AM -
0 Votes
Amending Table Structure Using Metadata Table
You can use system tables or views to find these metadata information.Answered | 3 Replies | 470 Views | Created by RishiRauli - Thursday, March 10, 2016 8:20 PM | Last reply by Benjamin Kettner - Thursday, March 10, 2016 8:46 PM -
0 Votes
Synchronize mutiple tables with complex structure
I don't want to do traditional table to table updates because this will cause problems in UI.Answered | 6 Replies | 12157 Views | Created by Tero-T - Friday, April 24, 2009 10:35 AM | Last reply by Tero-T - Monday, July 6, 2009 5:57 AM -
5 Votes
Table structure advise
What you call Client table is in fact the table I named ClientImage, this from that table where I should be able to get all other information so how can I ...Answered | 5 Replies | 690 Views | Created by wakefun - Tuesday, July 17, 2018 8:08 PM | Last reply by wakefun - Wednesday, July 18, 2018 9:27 AM -
0 Votes
How to update the DB Table structure?
Can you try the below code $instancename='abcd' $dbname='PowerSQL' $tablename='Orders' $column='testcol' $len=100 $s = new-object ...Answered | 1 Replies | 1635 Views | Created by Renziglov - Wednesday, September 3, 2014 8:58 PM | Last reply by Prashanth Jayaram - Wednesday, September 3, 2014 9:23 PM -
0 Votes
The structure of the sessions table?
I meant what are you trying to do with the internals of session table.Answered | 4 Replies | 5975 Views | Created by code_warrior - Thursday, December 2, 2010 1:52 AM | Last reply by Shamik Ghosh - Thursday, December 2, 2010 3:22 AM - Items 1 to 20 of 851361 Next ›
No announcements
