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

Database

 
Questionhelp me please Pin
loscalibros9-Jul-08 0:08
loscalibros9-Jul-08 0:08 
AnswerRe: help me please [modified] Pin
meeram3959-Jul-08 0:41
meeram3959-Jul-08 0:41 
QuestionSending XML as input to Oracle stored procedure Pin
kalyan_vb8-Jul-08 23:48
kalyan_vb8-Jul-08 23:48 
Questiondefault settings SQL Server does not allow remote connections. Pin
Amit Agarrwal8-Jul-08 23:19
Amit Agarrwal8-Jul-08 23:19 
AnswerRe: default settings SQL Server does not allow remote connections. Pin
subai9-Jul-08 2:59
subai9-Jul-08 2:59 
QuestionHow to find the Table exists in a Data Base Pin
pallaka8-Jul-08 22:16
pallaka8-Jul-08 22:16 
AnswerRe: How to find the Table exists in a Data Base Pin
Ashfield8-Jul-08 22:47
Ashfield8-Jul-08 22:47 
GeneralRe: How to find the Table exists in a Data Base Pin
TheFM2349-Jul-08 4:46
TheFM2349-Jul-08 4:46 
Another way to do it is (just replace your object names in the carrots):

If Object_Id('<database>.<schema>.<table>') Is Not Null
Begin
Create Table...
End


Which is pretty much the same as posted above, it's just using a system function. It can also work with temp tables:

--Assuming that #table is the temp table name.
If Object_Id('tempdb..#table') Is Not Null
...

QuestionChanging between mssql and access through connection string Pin
Y_R8-Jul-08 22:10
Y_R8-Jul-08 22:10 
AnswerRe: Changing between mssql and access through connection string Pin
Mycroft Holmes9-Jul-08 17:36
professionalMycroft Holmes9-Jul-08 17:36 
GeneralRe: Changing between mssql and access through connection string Pin
Y_R12-Jul-08 21:40
Y_R12-Jul-08 21:40 
GeneralRe: Changing between mssql and access through connection string Pin
Mycroft Holmes13-Jul-08 12:39
professionalMycroft Holmes13-Jul-08 12:39 
GeneralRe: Changing between mssql and access through connection string Pin
Y_R13-Jul-08 22:53
Y_R13-Jul-08 22:53 
QuestionHow Can I Do This Select Statment Pin
Zeyad Jalil8-Jul-08 20:58
professionalZeyad Jalil8-Jul-08 20:58 
AnswerRe: How Can I Do This Select Statment Pin
Ashfield8-Jul-08 21:58
Ashfield8-Jul-08 21:58 
GeneralRe: How Can I Do This Select Statment Pin
Andy_L_J9-Jul-08 0:39
Andy_L_J9-Jul-08 0:39 
Questionnormalization terms Pin
Pankaj Garg8-Jul-08 19:18
Pankaj Garg8-Jul-08 19:18 
AnswerRe: normalization terms [modified] Pin
leoinfo9-Jul-08 4:08
leoinfo9-Jul-08 4:08 
QuestionMS Access Connection String Pin
kadkir8-Jul-08 17:41
kadkir8-Jul-08 17:41 
AnswerRe: MS Access Connection String Pin
Jack Brando8-Jul-08 19:19
Jack Brando8-Jul-08 19:19 
GeneralRe: MS Access Connection String Pin
kadkir8-Jul-08 19:35
kadkir8-Jul-08 19:35 
GeneralRe: MS Access Connection String Pin
Mycroft Holmes9-Jul-08 17:44
professionalMycroft Holmes9-Jul-08 17:44 
QuestionMS SQL Server Multiple Roles per User Pin
Jack Brando8-Jul-08 17:34
Jack Brando8-Jul-08 17:34 
AnswerRe: MS SQL Server Multiple Roles per User Pin
Ashfield8-Jul-08 22:03
Ashfield8-Jul-08 22:03 
QuestionCommunicating via Windows Service object Pin
Richard Blythe8-Jul-08 5:07
Richard Blythe8-Jul-08 5:07 

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.