I need to create a summary table for the combination of some fields in a SQL Server table. I have the combination field value and the source table name in one SQL table as a row value. I need to pick this value and then fire a query on a source table with extracted values [...]
Answer Question | February 19, 2009 6:34 PM
Dynamic SQL, SQL Server tables
I have accidentally updated all data in a SQL Server table according to one data source, and now all my data is a copy of that data. How can I make a command to allow all data in that table to search for other data and update, according to another reference table?
Answer Question | February 2, 2009 6:08 PM
SQL Server Data Validation, SQL Server databases, SQL Server tables
How can you dump a table in a SQL Server database and convert the script into text?
Answer Question | February 5, 2009 5:54 PM
SQL Server databases, SQL Server tables
How can I transpose a table using SQL Server Reporting Services in VB.NET?
Answer Question | January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, VB.NET
We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?
Answer Question | January 22, 2009 6:07 PM
SQL Server errors, SQL Server tables
I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?
Answer Question | January 22, 2009 5:59 PM
SQL Server tables, SQL Server triggers
How can I recover a truncated table on a SQL Server?
Answer Question | June 25, 2012 5:47 PM
SQL Server backup and restore, SQL Server recovery, SQL Server tables, SQL Server Truncated Table
I have a massive customer table. The ID is the primary key and thus SQL Server makes a clustered index on that. There is no other index on the table. Can I add an index on fields like age, country and gender to make the results faster?
Answer Question | January 15, 2009 5:18 PM
Primary keys, SQL Server index strategy, SQL Server tables
How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?
Answer Question | December 9, 2009 5:05 PM
Microsoft Access, SQL Server database, SQL Server tables
How can I decrease the unused space of a SQL Server table which is indexed?
Answer Question | January 15, 2009 4:57 PM
SQL Server index strategy, SQL Server tables
I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want [...]
Answer Question | January 15, 2009 3:29 PM
SQL Server, SQL Server Scripts, SQL Server stored procedures, SQL Server tables
I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = ‘<tablename>’ and column_name = ‘<columnname>’ Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?
Answer Question | January 7, 2009 4:41 PM
SQL Server 2000, SQL Server stored procedures, SQL Server tables
My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all [...]
Answer Question | January 7, 2009 4:44 PM
SQL Server 2005, SQL Server databases, SQL Server Table Migration, SQL Server tables
Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?
Answer Question | April 3, 2011 4:54 PM
SQL Server 2005, SQL Server stored procedures, SQL Server tables
What is the role of system tables in SQL Server 2005 and how do you update them?
Answer Question | December 13, 2008 4:20 PM
SQL Server 2005, SQL Server System Tables, SQL Server tables, SYSTEM TABLESPACE
How do I write a hidden trigger against a SQL table?
Answer Question | December 13, 2008 7:48 PM
SQL Server tables, Triggers
I am writing a simple report that displays records from our customer table, a table that has no corresponding records in our contacts table. My code entered in SQL Server 2005 is as follows: select contractor.name,acctstatus, statusDetail, sales_person, loggedInBy,loginDate, lastUpdateBy, LastUpdateOn from contractor where contractor.name NOT IN (Select company_name from leads_contacts) I keep getting an [...]
Answer Question | December 8, 2008 7:25 PM
SQL Server 2005, SQL Server tables
I have developed an order entry application in SQL Server for a client. One of its functions is to insert invoices into the relevant tables. The procedure only does the job 997 times out of 1000 on average. In a single day, that means that hundreds of invoices are incomplete. No errors are reported, no [...]
Answer Question | January 9, 2009 6:43 PM
SQL Server stored procedures, SQL Server tables
I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?
Answer Question | December 2, 2008 4:57 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server Express, SQL Server tables
I have a table in SQL Server named CustInfo that is as follows: table CustInfo ( startdate datetime enddate datetime CustomerCode int address nvarchar(200) ) I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For example: 2008-01-01,2008-10-27,11,’13 Lexington st’ [...]
Answer Question | December 2, 2008 4:44 PM
SQL Server tables, Stored Procedure Constraints, Stored Procedures