Topics
Started by
Posts
Last post
I am unable to Create Index on a View Since one of the Tables was Created using ANSI_NULL off. Is t…
5 replies
In SQL2000, how can I redirect the output of a query to a file with the data being ; delimited?
8 replies
Is there a syntax for SELECTing INTO a table where the new table has a clustered index? Instead of…
1 replies
Greetings. Consider the code below. Removing the COl1 from the select and group by returnes the des…
3 replies
I am trying to speed up a query. I am looking for an alternative to a 'NOT IN'. Example: I have a t…
6 replies
Anybody any ideas how to achieve anything like this... Table1 id | domain ---------------------…
6 replies
Hi folks, I am wondering what is the best way to cascade changes to related tables. eg, I have 2 ta…
4 replies
Suppose I had a table CREATE TABLE JustTestParam ( TestDate DATETIME DEFAULT GETDATE(), TestInt I…
3 replies
Hi, I administer an SQL server database with an Access front end. The main table has 6000 directory…
9 replies
I have a select statement that calls this udf (create function udfNextBusDayYr (@vDate smalldatetim…
2 replies
hello i am working in an application that needs logging at every stage now i am trying to write a s…
6 replies
How to add a sequence number in select clause? for example select name,Sex from stuent name sex and…
4 replies
Is there any case statement limit bcz when i use this simple T-SQL i receive UPDATE DBO.DIM_BOOKING…
3 replies
I have a list of numbers seperated by commas. Is there are way to run a stored procedure like the o…
3 replies
I created a tabel like this: Create table tableA( order identity(int,1,1), a varchar(20), b varchar…
7 replies
Viewing 15 topics - 14,071 through 14,085 (of 17,082 total)
You must be logged in to create new topics.