Topics
Started by
Posts
Last post
how do i update the datetime column in every two or three hours from the sql. i want to create a jo…
4 replies
I have a table function that, for some unknown reason, refuses to complete execution. In trying to…
21 replies
I was hoping that the following code: declare @end_date as datetime set @end_date = '2008-03-10 02:…
2 replies
I am writing a sql trigger where i need to update the time in every 2 hour in following table idSc…
2 replies
Is there any way to find out the max number of characters the datatypes varchar(max), nvarchar(max)…
10 replies
Folks, I've been racking my brains to find a solution to this. Here, Saturdays are counted as work…
1 replies
I have three tables: CREATE TABLE [dbo].[Item] ( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvar…
21 replies
Hi, I have a stored procedure located on SQL2005 that call by "openquery" stored procedure from Ora…
9 replies
Hi, I appolize if this question get duplicated as i lost the id when i was posting and tried to che…
14 replies
I have a date1 field in the format: 2000-11-19 20:58:38.870 and I have a comments field with value …
1 replies
Hi I have included Active Directory as a linked server to SQLserver 2005. when I execute the follow…
2 replies
I understand there's a pretty big passion when it comes to the whole cursor versus set-based argume…
17 replies
I have 2 projects requiring assistance with set up of an SQL view to capture crosstab data Project#…
2 replies
I have a UDF craeted through following code USE [AdventureWorks] GO CREATE FUNCTION [dbo].[Calcula…
4 replies
We have an automated job scheduled at clients’s databases on Sql Server 2005. The job runs some val…
1 replies
Viewing 15 topics - 7,411 through 7,425 (of 12,230 total)
You must be logged in to create new topics.