Click here to Skip to main content
15,867,771 members
Home / Discussions / Database
   

Database

 
GeneralRe: INSERT trigger - how to stop the insert from happening. Pin
Werries17-Apr-08 9:56
Werries17-Apr-08 9:56 
GeneralRe: INSERT trigger - how to stop the insert from happening. Pin
SimulationofSai17-Apr-08 21:22
SimulationofSai17-Apr-08 21:22 
GeneralSystem.Data.OleDb.OleDbException: Unspecified error Pin
tom8317-Apr-08 3:35
tom8317-Apr-08 3:35 
GeneralRe: System.Data.OleDb.OleDbException: Unspecified error Pin
Kschuler17-Apr-08 10:37
Kschuler17-Apr-08 10:37 
Generalline 18 is getting error near ''this codes(mysql) Pin
srinivassam17-Apr-08 0:53
srinivassam17-Apr-08 0:53 
GeneralRe: line 18 is getting error near ''this codes(mysql) Pin
R. Giskard Reventlov17-Apr-08 1:16
R. Giskard Reventlov17-Apr-08 1:16 
GeneralCopy from one table into another Pin
.NET- India 17-Apr-08 0:52
.NET- India 17-Apr-08 0:52 
GeneralRe: Copy from one table into another Pin
pmarfleet17-Apr-08 1:57
pmarfleet17-Apr-08 1:57 
.NET- India wrote:
How to copy database design of a table into another table without copying its values


If you want to do this manually, you can do this through Management Studio by right-clicking a table and selecting 'Script Table As... -> CREATE TO'.

If you want do do it in code, you could use SMO[^] to obtain metadata for a particular table and create another table based on this metadata.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


GeneralRe: Copy from one table into another Pin
SimulationofSai17-Apr-08 3:04
SimulationofSai17-Apr-08 3:04 
Generalmysql provider problem Pin
srinivassam17-Apr-08 0:28
srinivassam17-Apr-08 0:28 
GeneralERROR:40 Pin
A-MEN16-Apr-08 22:02
A-MEN16-Apr-08 22:02 
GeneralRe: ERROR:40 Pin
R. Giskard Reventlov16-Apr-08 23:36
R. Giskard Reventlov16-Apr-08 23:36 
GeneralConvert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 21:47
subbu.sk16-Apr-08 21:47 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
pmarfleet16-Apr-08 22:18
pmarfleet16-Apr-08 22:18 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 22:37
subbu.sk16-Apr-08 22:37 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 22:37
subbu.sk16-Apr-08 22:37 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 22:37
subbu.sk16-Apr-08 22:37 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
Paddy Boyd16-Apr-08 23:23
Paddy Boyd16-Apr-08 23:23 
GeneralView verses Table-Values Function Pin
Werries16-Apr-08 19:53
Werries16-Apr-08 19:53 
GeneralRe: View verses Table-Values Function Pin
Ashfield16-Apr-08 21:03
Ashfield16-Apr-08 21:03 
GeneralGetting Top 5 from table of same category Pin
honeyss16-Apr-08 19:23
honeyss16-Apr-08 19:23 
GeneralRe: Getting Top 5 from table of same category Pin
ChandraRam16-Apr-08 20:08
ChandraRam16-Apr-08 20:08 
GeneralRe: Getting Top 5 from table of same category Pin
honeyss16-Apr-08 22:38
honeyss16-Apr-08 22:38 
GeneralRe: Getting Top 5 from table of same category Pin
ChandraRam17-Apr-08 1:33
ChandraRam17-Apr-08 1:33 
QuestionSql Query Pin
~V~16-Apr-08 1:44
~V~16-Apr-08 1:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.