Topics
Started by
Posts
Last post
Hi friends, I have a table called op_registration where every visit of out patient(op) will …
4 replies
Hi I have a requirement like below. I have to give the flavours to the application.We have thousand…
4 replies
Ok, so this has no real bearing on my application but I'm curious. Given the following: select len(…
12 replies
Hi, I have set the identity columns to -1,1 but I want remove the number zero from the identity seq…
6 replies
Using SQL Server 2008 R2, but also have access to SQL Server 2012 I have this sample data. ItemNo …
7 replies
Troubleshooting queries like this are always fun, this definitely isn't one of the worst I've seen,…
8 replies
SELECT * FROM DocketTB,WorkshopTB WHERE DocketTB.Docket_Date = WorkshopTB.Date_Raised order by Dock…
1 replies
Hi all i have this data: DECLARE @data table (id int,name varchar(max),parent_id int,node_type_id …
2 replies
I do not understand why the exists() tests are not working. I'm using SQL Server 2008 R2. Here's t…
5 replies
Hi, the following Script builds a perfect SQL-Statement to Truncate multiple Tables. Print shows th…
13 replies
SELECT SUM(ISNULL(ord_totalweight, 0)) AS Expr1 FROM dbo.o…
1 replies
hi this is my table CREATE TABLE [dbo].[emp_new]( [empid] [int] NULL, [primary1] [varchar](20) NU…
6 replies
Hi, Here is the code that I have written and its working fine. But now I have to put a condition wh…
10 replies
Never really got to grips with Transaction log size in Simple Recovery mode. I originally had a MER…
3 replies
Hi Friends, Let us assume I have 2 logins XXX & YYY. XXX-->sysadmin YYY-->all databases…
3 replies
Viewing 15 topics - 3,121 through 3,135 (of 10,647 total)
You must be logged in to create new topics.