Topics
Started by
Posts
Last post
Hey folks . . . I've set up a simple trigger, using the syntax as follows: create trigger [some tr…
2 replies
This PK has lots of foreign key constraints so I would like to not have to drop and recreate anythi…
9 replies
HI, I have two date columns in table , startdate and enddate .Enddaet column is null currently .Now…
17 replies
i want the date differece to be showed as 05 days, 04 months, 04 year and my code is declare @d d…
5 replies
Is there a sql command that displays a table defintion ? Ie columns and data types.... TIA
1 replies
We have data in our SQL Server database that we need to export into an XML file to submit to a vend…
1 replies
I have a table with the following: [start_time] --datetime ,[end_time] --datetime ,[duration] -- in…
2 replies
My query runs fine when I just run it in a query window in SQL 2008 mgmt studio, but if I try to us…
5 replies
Hi There, Does anyone know how to list SQL Servers in multiple domains? I have a query which lists…
8 replies
I have a table with 5 columns CERATE TABLE #tmpMatrix(a bit, b bit, c bit,d bit,e bit) and wants to…
4 replies
I am looking for a script that i can provide to a user so that he can search for a string the word…
2 replies
Add this to the thousands of FK questions that have been asked! Here's the deal. I have an existin…
11 replies
Can someone explain this strange behavior to me? When I run this query: IF OBJECT_ID('tempdb..#Tab…
2 replies
[font="Verdana"]if i have non-ansi syntax query as SELECT A.COL1, B.COL1, A.COL2, B.COL2 FROM A, B…
4 replies
Hi there, I've been searching the web and the forums for an answer to this problem, but can't seem …
6 replies
Viewing 15 topics - 9,571 through 9,585 (of 10,647 total)
You must be logged in to create new topics.