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...

    Teguma15 pointsBadges:
  • 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.

    Eabouzeid175 pointsBadges:
  • 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.

    Eabouzeid175 pointsBadges:
  • 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 tableCreated a schema file with a .fmt extensionCreated 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...

    Eabouzeid175 pointsBadges:
  • 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

    Rajeevraina5 pointsBadges:
  • Alter Column Drop Identity in T/SQL?

    Is it possible to alter a column definition to remove its identity property?

    Jagoodie60 pointsBadges:
  • 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...

    Backpedal5 pointsBadges:
  • 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?

    Fdemid25 pointsBadges:
  • 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...

    TJay85 pointsBadges:
  • 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 to concatenate but I get one large line. I can't figure out the...

    Musiclover5 pointsBadges:
  • Converting data field into hours, minutes, seconds.

    How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?

    Tonya5 pointsBadges:
  • 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

    Techzon1225 pointsBadges:
  • 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 want to use a...

    Leo W5 pointsBadges:
  • 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.

    Apinto5 pointsBadges:
  • 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...

    WarwickW5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following