No announcements
Found 3231252 threads
-
0 VotesAdding 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 | 1927 Views | Created by Rachida - Saturday, March 17, 2012 12:42 AM | Last reply by Nadjib A. Bait - Saturday, March 17, 2012 2:11 AM
-
0 Votes
Check if Data is Already Exists Before Insert
Hi, With SQL2008, sql developers can use the new t-sql MERGE command You can find here a t-sql MERGE command example code for SQL Server ...Answered | 3 Replies | 13533 Views | Created by Learn4Develop - Friday, December 31, 2010 8:03 AM | Last reply by eralper - Friday, December 31, 2010 8:33 AM -
0 Votes
check table exists
Hi tsql_new, your script doesn't check in "SQL Server" but in the "current" database.Answered | 4 Replies | 3912 Views | Created by tsql_new - Friday, July 12, 2013 7:15 PM | Last reply by SDeering - Friday, July 12, 2013 8:10 PM -
2 Votes
Check if text from textbox already exists in Access Database using c#
0) { MessageBox.Show("Existed!Answered | 2 Replies | 6392 Views | Created by dokirt.2 - Sunday, December 17, 2017 6:48 AM | Last reply by dokirt.2 - Tuesday, December 19, 2017 7:27 AM -
1 Votes
Restore database without overwrite the existing data
What you can do is restore the database with a new name and then later merge the data you need.Answered | 3 Replies | 1959 Views | Created by miruan - Tuesday, August 6, 2013 6:42 AM | Last reply by Satheesh Variath - Tuesday, August 6, 2013 7:06 AM -
1 Votes
Check for existing of data file before loading
Whatever variables you create are added into the Dts.Variables collection and Contains method lets you check if this collection contains your variable you pass as string parameter.Answered | 6 Replies | 1230 Views | Created by Neilcse - Thursday, June 19, 2014 6:32 AM | Last reply by Samiullah Niazi - Monday, June 23, 2014 2:28 AM -
1 Votes
How do i check weather a trigger exists in a database?
-- T-SQL checking the existence of database objects IF EXISTS (SELECT * FROM sys.objects ...Answered | 6 Replies | 19890 Views | Created by code_warrior - Sunday, January 3, 2010 9:45 AM | Last reply by Sridhar Boyapati - Monday, January 4, 2010 6:05 AM -
0 Votes
Check that the object exists in the database.
My Sheet Name is "EFT"...it does NOT contain a "$"Answered | 5 Replies | 13269 Views | Created by PSULionRP - Thursday, August 14, 2014 6:47 PM | Last reply by SSISJoost - Monday, August 18, 2014 5:10 AM -
0 Votes
Check Database diagram at source database
Hi MVP_88, As per my understanding, the best method is we need to create database diagrams, drag and drop your tables and use the designer to create the ...Answered | 3 Replies | 1701 Views | Created by MVP_88 - Monday, May 18, 2015 12:57 PM | Last reply by Katherine Xiong - Friday, May 22, 2015 1:37 AM -
0 Votes
"Checking existing data against newly created contraints" throws
Hi Nate, Its not trying to add a check constraint, the constraint (which is actually a foreign key) already exists (probably created earlier in the publish).Answered | 1 Replies | 3222 Views | Created by BuildJedi - Thursday, February 14, 2013 4:04 PM | Last reply by Jamie Thomson - Thursday, February 14, 2013 4:59 PM -
0 Votes
C# check directory exists
string strFullpath = @"C:\Data\IFiles"; if (false == Directory.Exists(strFullpath)) { Console.WriteLine(String.Format("{0} does not exists", ...Answered | 3 Replies | 35497 Views | Created by wendy elizabeth - Wednesday, February 20, 2013 5:20 PM | Last reply by Sam Vishwas - Wednesday, February 20, 2013 5:42 PM -
1 Votes
how to check for existing files
If your application is shortly going to access the file after checking it exists, then you may as well just access it without ...Answered | 14 Replies | 1591 Views | Created by SLborn - Friday, March 29, 2013 8:22 PM | Last reply by SLborn - Thursday, April 4, 2013 5:50 PM -
0 Votes
Connect SQL Server Database Project to existing database
But the local DB will not have all my data.Answered | 5 Replies | 6269 Views | Created by Don--C - Monday, June 3, 2013 3:52 PM | Last reply by Kevin Cunnane [MSFT] - Thursday, June 6, 2013 12:54 AM -
0 Votes
Database consistency checks (DBCC) failed while checking the data segments
Something to do with the data?Answered | 3 Replies | 2984 Views | Created by VivDev - Tuesday, August 15, 2017 12:18 PM | Last reply by willson yuan - Monday, September 11, 2017 9:38 AM -
0 Votes
check UDF exists in DB ?
SELECT 1 FROM Information_Schema.Routines WHERE Routine_Name = 'sp_renamediagram' It will return a record if the routine exists, and no record if it does not.Answered | 2 Replies | 4472 Views | Created by cellulo madhu - Thursday, May 7, 2009 12:15 PM | Last reply by Brian Tkatch - Thursday, May 7, 2009 12:28 PM -
0 Votes
Create table in existing database
For subsequent schema updates, check that property and, if it's less than your current version, apply the necessary updates and set the property to the current version.Answered | 2 Replies | 1289 Views | Created by Stroud District Council - Tuesday, August 21, 2012 3:20 PM | Last reply by Stroud District Council - Wednesday, August 22, 2012 9:19 AM -
5 Votes
Database health check(corruption check)
Alex, To Check Database Health, run bellow command: DBCC CheckDB ('your database name') with NO-INFOMSGS, ...Answered | 9 Replies | 3741 Views | Created by alexsql - Friday, November 2, 2012 12:54 PM | Last reply by Markwillium - Monday, November 5, 2012 10:22 AM -
0 Votes
Check If File Exists
Hi, you can use the System.IO.Path.Combine() method to create the full filename and by using System.IO.File.Exists() you can check if the file exists.Answered | 1 Replies | 1270 Views | Created by Georges N - Wednesday, June 26, 2013 2:05 PM | Last reply by Heslacher - Wednesday, June 26, 2013 2:12 PM -
2 Votes
Difference between checking count(*) and if Exists
Exists() Check existence of any result but after preparing result , probably you have expensive column or index , you can use some thing like this: ...Answered | 10 Replies | 9306 Views | Created by Ranga1 - Friday, May 4, 2012 5:49 PM | Last reply by nanurahi - Sunday, May 13, 2012 12:15 PM -
1 Votes
Check if Tables Exist
Hi obrienkev, I am writing to check the status of the issue on your side, since I think BinaryCoder's post is very helpful on this case.Answered | 2 Replies | 3597 Views | Created by obrienkev - Wednesday, June 2, 2010 8:40 PM | Last reply by Michael Sun [MSFT] - Tuesday, June 8, 2010 1:19 AM
No announcements
