Topics
Started by
Posts
Last post
Hellowww!! Any way to avoid updates on a field? I'd like to do it WITHOUT USING TRIGGERS …
2 replies
I'm just curious about this theoretical situation: Let's say I've got a table like so... CREA…
4 replies
I have several tables that have an ID of 0. These are here to help with referential integrity…
11 replies
I want to create a procedure to query my tables to identify all of the Indexes. The informatio…
6 replies
Can you control the order of the cursor return? e.g. Fetch 3,2,1 (data) Can I fetch 1 first the 2 t…
1 replies
This SQL: select dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1, 0)) As MonthEndDate Re…
5 replies
Hello, I was trying to run the following procedure, I'm not getting the output, I'm not sure if the…
6 replies
One of my script log the events in a smalldatetime filed. But some reason it is not writing seconds…
3 replies
Does anyone have a script that can find duplicate entries in a table? Example: Da…
42 replies
Hi I do not know if it is possible but, I need find how to split a fleld in SQL server. I need to m…
4 replies
We have this fine procedure here, that builds a dependency list of the tables contained in the data…
1 replies
I've got a bulk insert command that works when I use the bcp utility (either from the command windo…
3 replies
I have a query designed to identify records with a birthdate more than 3 years +- the med…
4 replies
I would like to check if there is data being currrently saved to a table or database. I thought tha…
6 replies
I found this script creating primary key and index on the same columns. Is the index needed?…
3 replies
Viewing 15 topics - 8,431 through 8,445 (of 17,082 total)
You must be logged in to create new topics.