Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail data.
Answer Question | December 21, 2010 9:42 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
I’m interested in creating a web form that will deposit information into a SQL Server database. What’s the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.
Answer Question | July 1, 2010 12:12 PM
Forms Design, SQL Forms, SQL Server 2005, SQL Server 2005 Database, T/SQL
Can anyone tell me the best way to query Active Directory in SQL? I’m using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I’m not sure what the best way to do this is.
Answer Question | June 22, 2010 12:15 PM
Active Directory, Active Directory query, LDAP, SQL Server 2005, SQL Server Management Studio 2005, T/SQL
Hi. I’m running into an issue performing a bulk insert. I’ve taken the following steps: Created a table Created a schema file with a .fmt extension Created a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file “g:USB06182010.txt” could not [...]
Answer Question | June 21, 2010 3:46 PM
SQL INSERT, SQL Server Management Studio 2005, T/SQL
I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel
Answer Question | April 11, 2010 9:22 AM
SQL Multithreading, T-SQL, T/SQL
Is it possible to alter a column definition to remove its identity property?
Answer Question | February 6, 2010 3:26 PM
SQL Column Headings, SQL Server 2008, T/SQL
Hi everyone, My database table has a time field called [time], Data Type of “Numeric” length of “9″ with a Precision of “14″ a Scale of “0″. The query below produces the following output : 2009-10-14 00:02:42.000 2009-10-28 20:15:10.000 Query : select DATEADD(ss,CAST(Left(min(time),10) AS INT),’01/01/1970′),DATEADD(ss,CAST(Left(max(time),10) AS INT),’01/01/1970′) from tblTest Which is fine it has given [...]
Answer Question | November 3, 2009 2:22 PM
Date Time, Selection Criteria, SQL Server, T/SQL
Does a list of Transact SQL statements, that cannot be used within transactions, exist please? Is it available on the Web?
Answer Question | August 25, 2009 5:19 PM
SQL Server administration, T/SQL, Transition Packsaction
If I want to return null values in a query that has “Where Field1<>’test’ is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES (‘test’) INSERT INTO myTable VALUES(‘test2′) INSERT INTO myTable VALUES(null) GO Select * From myTable Where Field1<>’test’ –Only returns test2 and not the null [...]
Answer Question | July 24, 2009 2:09 PM
ANSI, NULL, T/SQL
I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For example Column A Column B 1 Boyd 1 Honaker 2 Steel I need the row to be 1 Boyd, Honaker 2 Steel I can get the name column [...]
Answer Question | September 25, 2008 2:37 PM
How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?
Answer Question | July 29, 2008 4:18 PM
SQL Server 2005, T/SQL
I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks
Answer Question | June 18, 2008 9:44 PM
SQL, SQL Server 2000, T/SQL
Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don’t want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don’t [...]
Answer Question | April 23, 2008 5:34 PM
SQL Server, SQL Server 2005, T/SQL, Triggers
In t-sql, I want to store the date from the getDate() function in GMT time instead of local time.
Answer Question | April 21, 2008 6:42 PM
convert, getDate(), GMT, SQL, T/SQL
Hello, I’ve been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I’m hoping else has seen these. Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL Native Client. Permissions are the same, just [...]
Answer Question | April 10, 2008 6:43 AM
SQL Server, SQL Server security, T/SQL