T/SQL Questions

1

Sample Test Data from Production in SQL Server 2008
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
asked by:
15 pts.

I’m interested in creating a web form that will deposit information into a SQL Server database.
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
asked by:
175 pts.

Can anyone tell me the best way to query Active Directory in 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
asked by:
175 pts.

Bulk Insert Problem in SQL Server Management Studio 2005
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
asked by:
175 pts.

Multithreading 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
asked by:
5 pts.

Alter Column Drop Identity in 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
asked by:
60 pts.

Date Time SQL Selection Criteria
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
asked by:
5 pts.

SQL Server transactions TSQL question.
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
asked by:
25 pts.

Eliminating Nulls in tSQL
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
asked by:
85 pts.

Concatenate
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
Concatenate, T/SQL
asked by:
5 pts.

Converting data field into hours, minutes, seconds.
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
asked by:
5 pts.

T-SQL how to identfiy tables that have dulicate roaws
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
asked by:
25 pts.

How to prevent SQL update trigger from firing on insert?
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
asked by:
5 pts.

Convert time to GMT time
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
asked by:
5 pts.

Potential over & under security issues with SQLNative Client ?
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
asked by:
5 pts.

1