No announcements
Found 3231347 threads
-
1 Votes
Checking if the Data is Existing in the Database
There is no code for checking the username exist or not.Answered | 2 Replies | 2705 Views | Created by mvbnet - Monday, July 18, 2011 2:45 AM | Last reply by Kee Poppy - Friday, July 22, 2011 7:16 AM -
1 Votes
Check if DataBase Exists
I can't get the SQL Server Management Studio to let me have permission to do anything like add a database, attache a database, check databases, etc.Answered | 13 Replies | 23673 Views | Created by DeHXX - Sunday, November 28, 2010 10:52 PM | Last reply by DeHXX - Sunday, December 12, 2010 10:18 PM -
0 Votes
Check if value exists on database LINQ
Hi, you can check for your solution ...Answered | 1 Replies | 10743 Views | Created by MrNow - Saturday, February 26, 2011 8:44 PM | Last reply by Mitja Bonca - Saturday, February 26, 2011 9:02 PM -
0 Votes
Checking if check box value exists in database
According your description, just disable the control if the data in database is 1 (suggested by Sygrien) seems to be a solution.Answered | 5 Replies | 2721 Views | Created by nirvana.r - Tuesday, January 17, 2012 2:42 PM | Last reply by Mark Liu-lxf - Friday, January 20, 2012 7:42 AM -
0 Votes
Publish Database with existing Data
I think I have my question answered.Answered | 10 Replies | 2446 Views | Created by L Vu - Friday, November 4, 2011 1:11 PM | Last reply by L Vu - Monday, November 7, 2011 2:19 PM -
1 Votes
How to check the existence of an OLAP database?
What ConnectionType should I use in the Execute SQL Task in order to run this check?Answered | 5 Replies | 6804 Views | Created by EricLBI - Monday, July 12, 2010 7:10 PM | Last reply by petr_cz - Monday, June 27, 2016 9:11 AM -
1 Votes
how to check if file exist OR Database name
If you are only interested in verifying the existence of database files, a safer and more robust method would be to avoid high privilege procedures, such as: xp_fileexist, ...Answered | 3 Replies | 10312 Views | Created by gpspocket - Tuesday, December 22, 2009 1:19 PM | Last reply by Arnie Rowland - Tuesday, December 22, 2009 5:25 PM -
3 Votes
How can i Check if data exists in MS Acess Database Column
okay i understand, well i removed my ("textbox")); this is what it looks like now, it stil doesnt work, is there another way without using a textbox... i just want it to ...Answered | 8 Replies | 6985 Views | Created by Hefff - Tuesday, August 14, 2012 8:54 AM | Last reply by Hefff - Monday, August 20, 2012 2:32 PM -
0 Votes
Check if database exists and return a value
Chuck's answer will return nothing if the row doesn't exist - is it what you wanted?Answered | 8 Replies | 2750 Views | Created by ardmore - Monday, June 11, 2012 1:40 PM | Last reply by ardmore - Tuesday, June 12, 2012 11:57 AM -
0 Votes
How to check database weather already exist with C#
The query that you would to determine if database exists before creating it is as follows if not exists(select * from sys.databases where name = ...Answered | 2 Replies | 9737 Views | Created by leoliuqx - Friday, June 12, 2009 4:28 AM | Last reply by John C Gordon - Monday, June 15, 2009 11:21 PM -
1 Votes
Append text to check if the database object exists
Well, When I write the create script to the file I would like to add the check for "if object exists drop object" right before the create.Answered | 3 Replies | 2893 Views | Created by CSharp Enthusiast - Wednesday, August 17, 2016 3:54 PM | Last reply by Albert_ Zhang - Monday, August 29, 2016 10:03 AM -
1 Votes
check existence of a database principal inside a stored proc
Here is (in my opinion) a prettier version of Dan's procedure.Answered | 5 Replies | 853 Views | Created by udhayan - Tuesday, October 16, 2018 10:03 AM | Last reply by udhayan - Wednesday, October 17, 2018 5:05 PM -
0 Votes
Checking database
There is a difference if a database has data or that a database exist.Answered | 7 Replies | 684 Views | Created by Habib ur rehman - Monday, August 11, 2014 10:33 AM | Last reply by Habib ur rehman - Tuesday, August 12, 2014 4:48 PM -
0 Votes
check file exists
For example, if the file does not exists or exists, Script Task returns a flag, and store this flag value into a variable.Answered | 4 Replies | 1680 Views | Created by MTL2014 - Tuesday, October 4, 2016 3:09 AM | Last reply by Nik - Shahriar Nikkhah - Wednesday, October 5, 2016 3:44 AM -
4 Votes
Check If Data Already Exists Before Insert
In that case I would suggest you to create a stored procedure which checks if the data exists or not and then performs the insertion.Answered | 7 Replies | 7352 Views | Created by IndigoMontoya - Thursday, March 19, 2015 6:27 PM | Last reply by Syed Shakeer Hussain - Thursday, March 19, 2015 7:34 PM -
3 Votes
How to check if a database exists in SQL Server or not.
The best method, in my opinion, is to use SMO.Answered | 6 Replies | 9611 Views | Created by Praveen Kumar Sirohiwal (Parv) - Monday, December 12, 2011 10:49 AM | Last reply by CoolDadTx - Monday, December 12, 2011 3:17 PM -
0 Votes
Adding existing tables to internal database [Application Data]
Why do you want to add your tables to LS Internal Database, why not import them as a external Datasource?Answered | 1 Replies | 1901 Views | Created by Rachida - Saturday, March 17, 2012 12:42 AM | Last reply by Nadjib A. Bait - Saturday, March 17, 2012 2:11 AM -
1 Votes
How to check if a table exists in any of the databases in a server ?
; if exists(select * from INFORMATION_SCHEMA.tables where TABLE_TYPE=''BASE TABLE'' and TABLE_NAME=''DB_BACKUP_LOG_T'') begin print ''exist in '' + db_name() ...Answered | 7 Replies | 13130 Views | Created by The db baby - Monday, November 14, 2011 7:02 AM | Last reply by Kalman Toth - Sunday, November 27, 2011 4:40 PM -
1 Votes
check if record exists in SQL database ?
Im trying to check if a record in database already exists.Answered | 1 Replies | 18156 Views | Created by wartmignef - Friday, November 7, 2008 9:57 AM | Last reply by mynkow - Friday, November 7, 2008 11:35 AM -
0 Votes
SQL Programming, check if multiple values exist in database
My blogAnswered | 9 Replies | 26808 Views | Created by Mindy Zhao - Thursday, February 17, 2011 12:11 AM | Last reply by wBob - Thursday, February 17, 2011 5:01 PM - Items 1 to 20 of 3231347 Next ›
No announcements