one of my tables got around 160-200 fields, 80%of them are nvarchar(50) Some said it is very poor design for the table / Does any doc/specificatoin can let me know "a better way to design table "?? Thanks a lot ...more >>

If I have a statement in a Stored procedure such as: CREATE PROCEDURE GetRecord @ID Int As SELECT Name, Address, Salary, ID FROM Candidate WHERE ID = @ID I want to actually setup this procedure to see all records regardless of @ID (in which I would pass ID as 0) or only records which...more >>

I have been scrounging around in here and BOL for some specific table design advice and figure it's finally time to just come out and ask my question: I am wondering if it is reasonable and, if so, how can I design a table that has a key column value that represents 'all others'. The watered do...more >>

Hi Can you help me with a Select statement? It should be simple, but I am lost. It should be something quite opposite to the JOIN statements, as they will allways give me NULLs for non matching values, but I actually want nonmatching values. I have two tables. How to query the two tables (belo...more >>

I'm on a shared server with no DTS capabilities. Is it possible to use a stored procedure to export data from an SQL recordset into an XML file on a remote server? i.e. I would need to create http://mydomain/myfile.xml Anyone have sample code? thanks ...more >>

Hi, Is there a way to extract a tables xml schema, for client input validation? Thanks. -- Sharon. ...more >>

I need to use C# to generate the data files for BCP. Which C# data type I should use to generate the data columns for SQL money money? ???? money; FileStream fs = new FileStream("test.txt", FileMode.CreateNew); BinaryWriter bw = new BinaryWriter(fs); ...more >>

Hello all! I'm trying to build a string using the ' character. As this character is used to delimiter the strings, how can I write it inside a string? Tanks in advance, Hugo Madureira...more >>

Hi all, I need modify one column name of my table. How I can do this? Thanks ...more >>

Hi, I am trying to bulk insert data with UNICODE characters into a table using a format file. I am using SQL Server 2000 with all the latest SPs. When I try to bulk insert the data I get the following error. "Bulk Insert: Unexpected end-of-file (EOF) encountered in data file." What am I ...more >>

Hi, Is there any way to execute sp_addlogin stored procedure to create a new sql server login from a login account who has minimum privileges on database. (He is not a member of either sysadmin or security admin). My problem is I need to create new sql ser...more >>

sp_help only list out the field name in the table, I want to know the total length in that table. thx ...more >>

Hi, I am writing a stored procedure which needs to select different tables based on different parameters. I used to use 'CASE' to select different columns, so I tried to use following statement like "select * from CASE @id WHEN 0 then 'EMPLOYEE' END". It doesn't work. What i need to achieve ...more >>

Hi all, I created a table with an autonum field, with a stored procedure to insert new record to the table. however I found that the autonum will keep increase when some unique constraints is voliated. I tried to use Begin Transaction, and rollback when there's error during the insert ...more >>

Hello, In MS Access a primary key can be created from 2 (or more) non-unique columns which would comprise a unique column --- as follows (from these 2 repeating columns) using the Indexes dialog box in table design and this places a Key symbol on the respective columns: col1 col2 1 ...more >>

Got a table with fields CreatedBy and CreatedOn I set its Default Value or Binding to Suser_Sname() and Getdate() respectively. Testing inserting new records from my VB.NET user interface I find that neither default values get populated, yet I have a trigger for insert or delete that poluates...more >>

Hi, I have a Auto Increment field in a table. here i want to capture the auto incremented value, format it and insert into another field/table. for example: if my auto increment value is 10, i want to format it like CHDOCREF_10 and insert to another field. please help...more >>

is there a way to determine the size of an sql select query accurately that runs over the network ? thanks... ...more >>

Is there a way to run an SSIS package via a stored procedure? I haven't found anything in BOL. I am currently doing this by running a job that executes the package, but was wondering if there's a new sp for this. Thanks, and happy new year, TomT...more >>

Hello, I Hope one of you can help me with the following: I try to join three fields from a table into one output field: month, day, year ==> date. And I can't get it tow work right. The datatype of the fields is numeric. Since this query is nested into another one the datatype of the outpu...more >>

Hi Guys, I've a problem regarding transaction log, i have a databasse which is to be accessed very rairaly inspite of that after few days it shows warning as: APPROACHING RESOURCE LIMIT MSSQL Quota DB: ABCD_database has used 66 MB out of 80 MB limit whil...more >>

I have, in stored procedures in SQL2000, used the TSEQUAL-function when doing updates. example: table test is defined like this(id int,description varchar(100),t_stamp timestamp) create proc test @id int,@description varchar(100) @ts varbinary(8) as update testtable set description = @descr...more >>