Click here to Skip to main content
15,940,680 members
Home / Discussions / Database
   

Database

 
AnswerRe: CreateQueryDef() pause needed Pin
DQNOK10-Oct-07 5:32
professionalDQNOK10-Oct-07 5:32 
GeneralThere has got to be a more elegant way to do this... Pin
new_phoenix10-Oct-07 10:13
new_phoenix10-Oct-07 10:13 
QuestionHow to query all of the tab_name in the same database Pin
nibabug10-Oct-07 1:16
nibabug10-Oct-07 1:16 
AnswerRe: How to query all of the tab_name in the same database Pin
Krish - KP10-Oct-07 1:21
Krish - KP10-Oct-07 1:21 
AnswerRe: How to query all of the tab_name in the same database Pin
Virendrak10-Oct-07 2:25
Virendrak10-Oct-07 2:25 
AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 5:21
professionalGuyThiebaut10-Oct-07 5:21 
QuestionRe: How to query all of the tab_name in the same database Pin
nibabug10-Oct-07 14:11
nibabug10-Oct-07 14:11 
AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 21:16
professionalGuyThiebaut10-Oct-07 21:16 
Hi,

The first example is what is called a "user defined function".
This is a means for SQL to process data based on parameters passed to the function and then return a value(or a table).
In this case the function takes an object and object type as input.
The object type, in the bottom piece of code, is "u" which means that the function only looks for tables.

The advantage of a function is that you can create this code once and reuse it many times by just calling it with dbo.DoesObjectExist('tablename','u').

In terms of creating a SQL table in C++ I'm sorry to say that I cannot help you with that yet as I am learning C# at the moment.
What I can recommend is google and searches with strings such as "create SQL table with C++" and "SQL create table".
As a tool google is invaluable and has proved to be just this in my work - as there is always going to be an example somewhere out there of what you are trying to do.

Good luck.

You always pass failure on the way to success.

Questionproblem in page indexing in Grid View Pin
ahmed_fci200610-Oct-07 0:44
ahmed_fci200610-Oct-07 0:44 
QuestionLast value in a Table Pin
BINOVAR10-Oct-07 0:18
BINOVAR10-Oct-07 0:18 
AnswerRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:32
Aavesh Agarwal10-Oct-07 0:32 
GeneralRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:36
Aavesh Agarwal10-Oct-07 0:36 
AnswerRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 0:56
Paddy Boyd10-Oct-07 0:56 
GeneralRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 1:11
Paddy Boyd10-Oct-07 1:11 
GeneralRe: Last value in a Table Pin
BINOVAR10-Oct-07 1:09
BINOVAR10-Oct-07 1:09 
GeneralRe: Last value in a Table Pin
pmarfleet10-Oct-07 2:12
pmarfleet10-Oct-07 2:12 
QuestionQuery regarding Trigger Pin
Aavesh Agarwal9-Oct-07 23:37
Aavesh Agarwal9-Oct-07 23:37 
QuestionSwap the columns values [modified] Pin
Aavesh Agarwal9-Oct-07 22:55
Aavesh Agarwal9-Oct-07 22:55 
AnswerRe: Swap the columns values Pin
Joe9-Oct-07 23:26
Joe9-Oct-07 23:26 
GeneralRe: Swap the columns values Pin
Aavesh Agarwal9-Oct-07 23:28
Aavesh Agarwal9-Oct-07 23:28 
Questionproblem in a tipical query(plzzz help me) Pin
Arihant rathi9-Oct-07 20:57
Arihant rathi9-Oct-07 20:57 
AnswerRe: problem in a tipical query(plzzz help me) Pin
joemonvarghese9-Oct-07 22:32
joemonvarghese9-Oct-07 22:32 
GeneralRe: problem in a tipical query(plzzz help me) Pin
Arihant rathi10-Oct-07 0:28
Arihant rathi10-Oct-07 0:28 
GeneralRe: problem in a tipical query(plzzz help me) Pin
pmarfleet10-Oct-07 1:55
pmarfleet10-Oct-07 1:55 
GeneralRe: problem in a tipical query(plzzz help me) Pin
joemonvarghese10-Oct-07 3:46
joemonvarghese10-Oct-07 3:46 

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.