Topics
Started by
Posts
Last post
All, what are all the new "Optimization Techniques" available in SQL 2012 which is not available in…
5 replies
On server A, create the following: create proc remotetest3 (@a int) as set nocount on select objec…
3 replies
Consider this Table : CREATE TABLE Test ( field_one nvarchar(10) ); DECLARE @i int; WHILE @…
23 replies
I was writing some code to check out the check_constraints of tables spread out accross multiple DB…
9 replies
Hi, I'm having trouble getting remote debugging working through SSMS 2012 and could use a bit of he…
2 replies
This code concats two strings, one that is 4000 chars and one that is 4025 chars. If I put a N in p…
2 replies
I know how to select TOP X random rows from a table using NEWID(). Separately, I know how to sele…
1 replies
I have a table with product sales by region for three years - 2010-2012 tbl1 prod region year reven…
6 replies
Hi, I'm trying to get the hang of recursive CTEs. In this test I am wanting to set a level for down…
5 replies
I have an application and database that I inherited, and am now trying to normalize the database fo…
5 replies
dear friends, I need to generate invoice number(s). To keep everything easy lets say I need to gene…
37 replies
I have a table with product, month and revenue data. But for some products, there is no data if the…
3 replies
I have two sets of tables - one has yearly data and another has monthly data. The only difference b…
2 replies
Hello everyone, This is Anibal from Taiwan, I found something interesting, but not sure if this is …
1 replies
How do I write a code that given a date range, prints the Year and Month for the months in that dat…
12 replies
Viewing 15 topics - 4,921 through 4,935 (of 4,979 total)
You must be logged in to create new topics.