Can SQL Server run in Linux? ...more >>

Hmmm... I wanted to play a little with clr and sql in vs 2005. However, the project templates referred to in this article (Project -> Database -> SQL Server) do not apoear... http://www.sqlservercentral.com/columnists/aAnajwala/simplesqlclrintegration.asp Can I somehow manually install them...more >>

HI all, I have created a table that store company group hierachy structure. I have used a combination of the adhjacency model amd materlialised paths with depth info and a few other things. ANyway, My question is hwat is the best method for building the tree that will fit into a treeview object ...more >>

I ran across this yesterday whilst trying to figure out why my search results were wrong: ---------------- create table #product ( datecreated datetime ) insert into #product (datecreated ) values (getdate()) insert into #product (datecreated ) values ('20050901') insert into #product (datec...more >>

Instead of using the sa account in my asp intranet pages, I'm trying to create a sql login account for our intranet users. The asp pages will have forms so users can add/edit records to the sql database. Which "Server Roles" should I grant the account? In SQL Logins, under the "Database Ac...more >>

Hi, I have collected SQL Trace events into a trace table by exporting the trace into a table. I have a table Trace1 with following columns: -RowNumber -ApplicationName -DatabaseName .. .. .. -StartTime -EndTime Clustered Index on RowNumber Column. NonClustered Index on StartTime Co...more >>

Hi, I currently have a website that was developed using Visual Studio 2003/ASP1.1 and SQL Server 2000. My hosting company is moving to SQL Server 2005 and I want to make sure that there is no impact on the website. Can I use SQL Server 2005 and Visual Studio 2003? I believe they use di...more >>

I remember reading somewhere that with the new SQL Server 2005, you could do the stored procedures logic using a .Net language instead of the Transact (at least I think thats what its called) SQL thing. If this true, could someone post a link where it talks about this new feature? Thanks...more >>

I am new to Oracle. If I have a simple Table lets say Employee withe EmployeeKey, EmployeeCode and I want to return this in a SQL server Stored Procedure I can just do this: CREATE PROCEDURE EmployeeSel AS Select EmployeeKey, EmployeeCode from Employees now that is very simple. Ple...more >>

Dear all, I got a fieldA which is datetime , when I check the value in query analyzer, the value returned is: 2003-10-27 10:55:00.000. When I get this field to a ADODB.recordset named rs_A, rs_A returns : 2006/4/26 =A4W=A4=C8 09:24:17 ,which is date time s...more >>

ASP.NET C#, SQL Server 2000 i have a webform that contains several DB rows from a single table that i can edit, how do i do a multiple update on these rows, ideally with a single call to a SP ...more >>

I have a table which has many columns but need to query it as rows. The UNION ALL does the trick My question is when we do a GROUP BY, is there a way we can generate a sequence number automatically for columns that are grouped by. Please see query below. i.e. If there are many rows f...more >>

Hi - I'm using the following Table and Stored Procedure below, to store and access a menu hierarchy. The recursive stored procedure is working perfectly and returns a text string outlining my current menu hierarchy. Currently the stored procedure returns the hiearchy in the order that the ...more >>

I want to create a user on SQL Server 2005 that needs to be able to create databases, logins, and users, as well as create stored procs, triggers, tables, etc. This user will be accessed from a vb.net application. Is there anything less powerful than the 'sa' user that will do the trick, or some...more >>

I'm using SQL Server 2000. I have an application that uses three databases. Currently, when a new user is added (Windows Integration), I go to each database, create the login then go to each spoc and give that user rights. Is there a faster more efficient way to do this? For example, I have...more >>

Is there any way to do this? Say I have SELECT MyCol FROM MyTable MyCol is a nvarchar field, but instead of coming back like this in a table ItemA ItemB ItemC I want it to come back as a stingle string like this ItemA, ItemB, ItemC is this possible in T-SQL? thanks! ...more >>

I'm trying to save images stored in our SQL Server database as image files (jpg, gif). I posted a question last week and was told to try textcopy.exe. I installed the full version of SQL Server and tried textcopy but received the following error: SQL Server '<server name>' Message 4004: Unicod...more >>

Is it possible to execute a SPROC from within a view? If so, will the query slow the SPROC any lower than it normally would run? I use excel pivot charts based on sql views a good bit. As far as I know, I don't think pivot charts can be based on SPROC's. I've run into a database that is ver...more >>

Just a Quick Question.. I have a query that is similar to this Select colA , colB , colC , colB + colC as ColD From myTable Say I wanted to Join 'ColD' to 'myOtherTable' to a column called myOColA Is that possible? I'm not sure how to Reference ColD at all in a query.. I'v...more >>

Hello, How can I use SQL-DMO to get list of all the columns that are part of an index? I am able to determine if the column is primay key. Thanks...more >>

So, I use the rand function to generate some strings and it works great, but I would like a way to do alpha-numeric instead of just numeric. So, does anybody know of a function to do alpha-numeric random string generation or some way to get that functionality out of the built-in functions? Tha...more >>

I am new to 05 and I am searching for a way to add uniqueness to two fields that are not the PK. I am searching for a built in way to add uniquness that doesn't require writing a trigger or use the primary key. ...more >>

Does anyone know how to how to performance case-insensitive search on XML data type in SQLServer 2005? Or I have to convert all the xml data to lower case before I store it? Thanks in advance. John ...more >>

Would like to know if this is even possible to do - using SQL Server 2000. I am creating a procedure that truncates a table then inserts one row of data. In the third field I need to insert the count of another table. I thought that this would work: @DetCount int = SELECT Count(*) FROM Table...more >>

that I just detached. But, now I can't access EM because of the logins that are associated w/the detached db. Please help! ...more >>

How do you report errors from a stored procedure? For example, if the stored procedure is trying to insert something into a table and the database is full, how can the stored procedure return an error string to the caller? ...more >>

Gurus. I do not know if it is possible, but here is what I want to do. I want to allow user to page the SQL result, so he could decides to return from row 10 to row 20, or row 100 to 200, without returns the whole resultset. Every time he sends another request, I do not mind to hit the database...more >>

Here is my ORDER BY Clause, and based on the @Option parameter, I do different order by. This works fine since the order is set from just one column. ORDER BY CASE @Option WHEN '1' THEN IsApproved ASC WHEN '2' THEN CompletedDate WHEN '3' THEN Priority END The problem is tha...more >>

I am creating a site where users can create blogs and upload photos etc...I just realized that my hosting account with GoDaddy has a 100 MB limit on the SQL Server database...due to that I decided to store all photos on the server and just store the file path in the database...is that a good i...more >>

Hi all, I need some help with the following ---- In my db I have two tables – 1. Current data - 2. Previous data my goal is to do two things First I would like to update the current data table with data from the Previous data table. Second I would like to do a calculation on the...more >>

I think my hosting company changed something on SQL Server, but I don't know what. Suddenly, all OUTPUT parameters from ANY SPROC return NULL. The funny thing is, the values are in the variables within the SPROCS (see the PRINT results on the SPROC example below) The behavior is the same in Qu...more >>

Hi, In terms of performance what's more preferable using ignore duplicate key on the table index to ignore any duplicate rows that are being inserted, OR before you insert into the table you check that you are not inserting any duplicate rows. The ideal is if you know your data are not ...more >>

I have a udf that takes a zipcode and a miles parameter. It returns a table containing all of the zipcodes within that range. I am calling this function from a sp but am getting an error: Msg 245, Level 16, State 1, Procedure proc_PublicSearchPeople, Line 76 Conversion failed when conver...more >>

I am trying to use a trigger to capture text data that is being deleted and put it into an audittrail table. I use the same logic for the insert trigger(using inserted instead of deleted) and it functions as it should, however when I do a delete, this trigger seems to be overlooked as no ins...more >>

I am trying to write a query to show column dependencies. I want to write a query that will show me everything effected by changing a column in a table. I want something where I can give it a table and column name and it will show me which tables/views and the columns that are dependent on t...more >>

Hi Can you please explain the difference between Text and nText data type in SqlServer and at what situation we have to use this. Siva....more >>

Hi all, What settings has to be made in (SQL Server 2005) Server level & Database level to accept UNICODE characters ? Thanks, Karthik ...more >>

I am using this code to output data to file DECLARE @cmd VARCHAR(2048) SET @cmd = 'bcp "EXEC database.dbo.spname ''20060101 00:00:00'',''20060331 23:59:00''" queryout' + ' c:\outfile.csv -c -t' + ' -SLOCALHOST -E ' EXEC master..xp_cmdshell @cmd The data is 59K rows an...more >>

Dear all, I got a fieldA as datetime (length 8). When I select in query analyzer, it shows the following value : 2003-10-27 11:36:27.640 now I get fieldA into a ADODB.recordset in VB with fields rs_A("fieldA") And I try to update another table w...more >>

I have the following fields in table A: Date | Descrip | Amt Dr ---------------------------------- 01/02/2006 | 740240 |(2,400.00) 14/02/2006 | 740241 |(3,000.00) 15/02/2006 | 41142 | 1,800.00 20/02/2006 | 41142 | 2,700.00 25/02/2006 | 740245 | 5,200.00 ...more >>

hello, in a table i have a field of type bit which allows NULL. if a new record is created and the field is not set a NULL value is created. Now my question: if the field was set to the value 0 or 1 how can i reset that field manualy to NULL. Can i use some key STRG + ....? thanks ...more >>

I have this sql select statement SELECT 'http://PartnerLink.Artifacts.StockMovement.Schemas.StockMovement_BTSQL' As [StockMovement!1!xmlns], Delivery.DeliveryID, DeliveryType, DeliveryDate, DeliveryInfo, ReceiveStore, ReceiveCountry, ReceiveCurrency, SenderStore, SenderCountry, SenderCurre...more >>

SQL Server 2000 BOL says: The COLUMNS_UPDATED function returns the bits in order from left to right, with the least significant bit being the leftmost. The leftmost bit represents the first column in the table; the next bit to the right represents the second column, and so on. But in ...more >>