Topics
Started by
Posts
Last post
Hi everybody, I found a heavily fragmented table so I ran alter index all on mytable but after it w…
6 replies
we have migrated from 2000 to 2005 .if i change the text column to varchar. rowsize goes over 10000…
1 replies
Hi All, I have been told to use [font="Courier New"]DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE SET S…
6 replies
Hello, I am trying to get the average time out of a datetime column. I am able to get the average …
10 replies
I have two tables, say TableA with col A and TableB with col B. I want to find all records in Table…
10 replies
Hi, In sql server 7.0 - a simple select statement can be assigned to a shortcut key (ctrl+). In sq…
1 replies
Hi All there, Let me explain you the scene... I have one Table-Valued function dbo.fn_GetChild wh…
7 replies
hi, Can you please help me in this issue? create table #check ( cno int , sal int default(200) ) …
5 replies
Is it possible to call a web service from a stored procedure? We are looking to access google maps…
10 replies
Hi all, Does anyone know of a command or function that returns the username that runs it? I'm tryin…
3 replies
Hi All, I just wanted to update different columns from multiple Table. I execute the below script, …
22 replies
CREATE PROC Reg_Get AS BEGIN EXEC master.dbo.xp_regenumkeys ‘HKEY_LOCAL_MACHINE’,'SOFTWARE\ISS\CPE’…
2 replies
say you run this sql: DECLARE @fl AS FLOAT SET @fl = 789512385 SELECT CAST(@fl AS VARCHAR(50)) it p…
4 replies
Hi There, I have a requirement of knowing the user who is executing a query/stroed proc.let me be m…
3 replies
I have a table with two columns that I received by UNION. Steps 1 and 28 are roots. from_step_id …
10 replies
Viewing 15 topics - 11,431 through 11,445 (of 12,234 total)
You must be logged in to create new topics.