|
Yet another way to get a list of tables in an ADO.net-supported database:
System.Data.Common.DbConnection con =
this.command.Connection as System.Data.Common.DbConnection ;
if ( con != null )
{
System.Data.DataTable temp = con.GetSchema
(
"TABLES"
) ;
temp.DefaultView.RowFilter = "TABLE_TYPE='TABLE' OR TABLE_TYPE='BASE TABLE'" ;
temp.DefaultView.Sort = "TABLE_NAME" ;
|
|
|
|
|
yuvarajujogi wrote: How to check whether a database has a table out of that database
What are you going to do if it doesn't?
|
|
|
|
|
I want to create a table in that database similar to the table in another database.
|
|
|
|
|
try with this..
If Object_ID('dbo.MyTable') IS NOT NULL
PRINT 'MyTable Exists'
Else
PRINT 'MyTable Not Exists'
with regards
Karthik Harve
|
|
|
|
|
Hey,
What database are you talking about?
MySQL,
Microsoft SQL Server
ORACLE
....
|
|
|
|
|
|
Once Again, What version of SQL Server?
SQL Server 2000
SQL Server 2003
or What?
|
|
|
|
|
You can use this code to check if a table exists.
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyTable]') AND type in (N'U'))
PRINT 'MyTable exists.'
ELSE
PRINT 'MyTable does not exist.'
|
|
|
|
|
try with this..
If Object_ID('dbo.MyTable') IS NOT NULL
PRINT 'MyTable Exists'
Else
PRINT 'MyTable Not Exists'
with regards
Karthik Harve
|
|
|
|
|
If there is a view or stored procedure with the same name, this script will fail.
|
|
|
|
|
Hi,
I am trying to create this stored proceedure on mysql but getting the following error:
Quote: [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE sp_add_event_log
(
IN param_event_log_category varcha' at line 1
DROP PROCEDURE IF EXISTS `sp_add_event_log`;
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
IN param_event_log_category varchar(255),
IN param_event_log_reference varchar(255),
IN param_event_log_user varchar(255),
IN param_event_log_machine_name varchar(255),
IN param_event_log_os_version varchar(255),
IN param_event_log_windows_user varchar(255),
IN param_event_log_windows_user_domain varchar(255),
IN param_event_log_processor_count int,
IN param_event_log_stack_trace text,
IN param_event_log_working_set int,
IN param_event_log_tick_count int,
IN param_event_log_current_culture varchar(255),
IN param_event_log_date_time_format varchar(255),
IN param_event_log_number_format varchar(255),
IN param_event_log_language_name varchar(255),
IN param_event_log_text text
)
BEGIN
INSERT INTO students
(
event_log_category,
event_log_reference,
event_log_user,
event_log_machine_name,
event_log_os_version,
event_log_windows_user,
event_log_windows_user_domain,
event_log_processor_count,
event_log_stack_trace,
event_log_working_set,
event_log_tick_count,
event_log_current_culture,
event_log_date_time_format,
event_log_number_format,
event_log_language_name,
event_log_text
)
VALUES
(
param_event_log_category,
param_event_log_reference,
param_event_log_user,
param_event_log_machine_name,
param_event_log_os_version,
param_event_log_windows_user,
param_event_log_windows_user_domain,
param_event_log_processor_count,
param_event_log_stack_trace,
param_event_log_working_set,
param_event_log_tick_count,
param_event_log_current_culture,
param_event_log_date_time_format,
param_event_log_number_format,
param_event_log_language_name,
param_event_log_text
) ;
END
|
|
|
|
|
Just a guess, but shouldn't it be
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
...
...
)
AS <<== I don't see this in your SQL
BEGIN
...
...
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Then how can i say CREATE it if it does not exist and REACE if exist?
|
|
|
|
|
I think just the "AS" keyword is missing from your original code. The use of CREATE OR REPLACE is valid at anytime.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Hi,
How to access database of MS Access from SQL Server?
eg:
I have a MS Access database with empoloyees details. From SQL Server database i need to get the employees details from MS Access.
Thankyou,
YPKI
|
|
|
|
|
hi
Right-click on the database in SSMS object explorer, select TASKS --> IMPORT DATA
from the window follow the remaining instructions.
Rajesh B --> A Simple Programmer <--
|
|
|
|
|
There is no IMPORT DATA in TASK. I am Using 2005 SQL Server. Also i want to connect with ms access to retrive the employees details from a stored procedure when requried.
|
|
|
|
|
Try this link[^]
Go to the section that says Create an Access project.
|
|
|
|
|
Create a linked server[^], and copy the records over into a table in Sql Server.
Bastard Programmer from Hell
|
|
|
|
|
Use this
SELECT TestField1 as t1_from_C_Drive From OpenRowset('Microsoft.Jet.OLEDB.4.0',';Database=C:\temp\Test.mdb;',
'SELECT * from T_Test') as b
|
|
|
|
|
Dear All,
My requirement contains an windows application that can be installed any where over the world but the server will be in one place which will be accessed via internet.
Note : the same db will be accessed from web application also for reporting.
I plan to use MSSQL 2005 version and my db has image datatype also.
i am using the image data type in the db, when i try to query this it is taking more time for replying...
is it advisable to use the same? or is there any way to accomplish the same by using any other data types.. i tried usign varbinary (max) now the perfomance is little better than that.. but still slow.
Please guide me .
thanks in advance.
|
|
|
|
|
If your purpose is to store files in the database, I would suggest you store the files in the file system and just store the path to the files in the database in a varchar column.
Serving files from the file system is much faster than serving it from the database. The are pros and cons to both approaches. You may want to do some research and benchmarks before deciding which one to use.
|
|
|
|
|
Dear Shameel,
First of thank you very much for your time to reply.
Actually its not an file storage its an data storing.. say for example i want to store the details of an employe like name, age,sex ,address,... and his/her PHOTO... so here comes the image plays the role..
so this is the requirement. am bit confused to use the general MSSQL server to use it from internet as it will create problem by perfomance..or something.
thanks
|
|
|
|
|
Hi Hema,
Shameel is quite correct you can store in web server it self. But in security concerns it will not quite good but you can achieve that also by providing a user and giving read/write permission for that user and use it while storing it in web server.
If you still want to use it please put (nolock) while you are retrieving information of image or any thing as you said same db is using for reporting.
|
|
|
|
|
Information like name, age, sex, etc. can be stored using appropriate data types like varchar, int, etc.
Photos can be stored using two ways:
One is to store the photo as binary information in an image column.
The other is to store the photos as jpeg images on the file system and store their paths in a varchar column.
Each of these approaches have advantages and disadvantages of their own, you may want to explore these options further and see what works for your situation.
|
|
|
|