The basic script I am running is Select Max(Len(*)) I want to view all of the max column lengths. The error I get is Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '*'. What am I doing wrong? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-serv...more >>

I have a user trying to use the following code and he is getting duplicate rows back. I don't think he should but can't explain why it is not workig. has anyone else seen this before? SELECT DISTINCT LTRIM(RTRIM(<column name>)) FROM <table value function> He is getting 8 rows back one of ...more >>

Hi. I have a problem with UPDATE trigger and SQL 2005, when trigger calls update of the table. The sample environment, table 'test' with trigger: create table webdata..test(col int, help int) go insert into webdata..test values (1,1) go CREATE TRIGGER [ud_test] ON webdata..test AFTER ...more >>

Hi, I am trying to select some distinct pairs from a table. The table looks something like this; Username, partner Bill, Ted Ted, Bill Fred, Barney Barney, Fred Mike, John and I would like the output to be like Bill, Ted Fred, Barney Mike, John I have tried SELECT DISTINCT an...more >>

Hello, I have the following table: F1 F2 VALUE -------------- AA K1 5 DD K1 4 FF K1 3 GG K1 2 DD K2 3 SS K2 2 ZZ K2 1 I need a query to get the following result set: F1 | F2 | VALUE | ROW_COUNT ---------------------------- AA K1 5 1 DD K1 ...more >>

Hi, I've several tables, in hundreds, with columns not allowing NULL. Is there a good way to test the column and see if it is defined to allow NULL or NOT then execute ALTER TABLE dbo.mytab ALTER COLUMN c1 INT NULL; Thanks. ...more >>

Hi All, First, I need to convert the data that's in sql datetime format to unix timestamp format * 1000 then INSERT the unix timestamp values INTO a temp table for later use. After sometime searching, I found how to convert the sql datetime to unix timestamp but having trouble using i...more >>

I use a cursor that loops through each row in a dataset (rows in a table that meet certain criteria). It seems that it's a dead loop since it takes forever to run for such a small dataset. Therefore, I've added a few PRINT statements to see what is happening. FYI, below is the part of the s...more >>

Is it possible to delete all records in a table with Identity and reset Identity seed to 1? Currently I have to drop a table and recreate every time I want to reset the Identity. Thanks for your help! Bill ...more >>

Hi all, I have a table named Table1. It hase a primary key named TID with bigint type. Table1 has an INSTEAD OF INSERT trigger. This trigger computes maximum TID on current data in the table then increase it by one to compute TID for new row which is going to be inserted. One may assume this ...more >>

I'd like to create a stored procedure that adds an empty row to the table following, and return the ID of the newly added row (or the entire newly added row). How can I do this? -- Table schema CREATE TABLE [dbo].[Patient] ( [id_Patient] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL, ...more >>

Thanks to Hugo Kornelis, (blog: http://sqlblog.com/blogs/hugo_kornelis) I've made major progress toward creating a query that will take multiple LIKE clauses and return the records that match along with a custom column describing how many matches those columns contain. For example, I have a ta...more >>

When I have a timeout on invoking a stored procedure against SQL Server, I have an exception returned that looks like the following: {System.Data.SqlClient.SqlException} System.SystemException: {"Timeout expired. The timeout period elapsed prior to completion of the operation or the serve...more >>

hey all, when i'm working in osql from the command line is there a way to clear the screen. i know cls in dos but is there one in osql "query mode" (i.e. 1>clear screen) thanks, rodchar...more >>

I have SQL 2005 environment and I have set up Partition Table on it. I switch out existing partitions from it by moving the partition to blank table which works really well. However, when I try to move in a loaded table into an empty partition, I am getting following error which doesnt make an...more >>

hey all, i'm looking in sql books online at the backup database command and saw the following example: -- Back up the full AdventureWorks database. BACKUP DATABASE AdventureWorks TO AdvWorksData how do you tell it which instance of sql you would like to use? thanks, rodchar...more >>

I'm trying to build a database using scripts on a local drive. I'm doing this as part of an MSBUILD project. The MSBUILD uses a special task to execute ddl statements using a ExecuteNonQuery. When I try and create a function with a missing dependency it throws an exception : Cannot find ei...more >>

Hi, Can someone tell me where I can find a list with all the error codes and there meaning. TIA ...more >>

Hi, Our DB is abt 200GB data. and will use tempdb more .( sp and functions has @table variable and #temptables ) so temp db will grow more .Also my database log file too .As we dont need FULL backup. I used to run BACKUP LOG tempdb with NO_LOG and DBCC_SHIRNKFILE Is there any othe...more >>

I have a complex database structure from which I wish to create an excel like table with columns defined in the query (I pass in a string with the names of the columns in) and the rows filtered by more or less random criteria (which may require joins). For interest the source structure is e...more >>

Hi there, I have a problem, I have a masterTable to which I attach a trigger (update) as soon as rows are updated I want to update a second table (that has a completly different structure I only update parts of this 2nd table) further more I have to query the column name in the second table o...more >>

I need to create a column in a database from code. My application supports both MySQL and SQL server and Ive tested the following sql on MySQL without problems. string sql = string.Format("ALTER TABLE UsersCalibration ADD InductionDate DATETIME NOT NULL DEFAULT {0}" + " AFTER RangeLimit", ...more >>