Topics
Started by
Posts
Last post
Hi there. Is there a way in which I can delete all the data in all the tables in a given database.…
9 replies
I’m trying to figure out how to do the following without a cursor. I have a Table as follows:…
7 replies
Is there a way to know who is executing a stored proc from within that proc? We want to log activit…
9 replies
Hai I have a table with auto number in Sql Server. Is that possibl…
8 replies
I have added these tables to my database (for example): CREATE TABLE dbo.Departments ( DeptID INT I…
5 replies
Hi, I have a requirement to create a view with data from a query. The issue I am stuck with is how…
21 replies
I have a query that is looking at two dates, Case when Date A > Date B, Date A, Else B. Th…
4 replies
Hello, I have a UDF Table : Create Function getData(@id uniqueidentifier) returns @retResults TABLE…
6 replies
How do you activate debugging in query analyzer - SQL 2000 - SP3a? The client is running Wind…
3 replies
I am trying to implement a file management system for images, but also for other data types. I wa…
3 replies
So in my expirience I've found that the most accurate and fastest way of taking '2006-11-21 13:00:0…
9 replies
Hi! We have a proc that is called from a .NET client within a transaction. The client is responsibl…
21 replies
In other words... Are these select statements equivalent (logically, performance-wise, etc.)? #1: s…
1 replies
Hi All, I have two Database, one is in SQL Server 2005 and Another one is in Oracle. Both DB have s…
2 replies
The following SQL pulls data from a multiple-valued column, in which the data represents key/value …
9 replies
Viewing 15 topics - 5,626 through 5,640 (of 17,082 total)
You must be logged in to create new topics.