Topics
Started by
Posts
Last post
Hello All, Again, I am a Newbie currently polishing up on my freshly completed training. Below is …
1 replies
Hi All, This should be simple but I seem to be playing with my mental blocks today. In the followin…
7 replies
Hi, I want to change multiple column datatypes in a single query. If any one knows the answer, plea…
4 replies
Given the same textual data, is an inner join to a VARCHAR(MAX) any less efficient than the same jo…
1 replies
Morning all, I'm importing server event logs into a database, then using sp_send_dbmail to send out…
2 replies
We have a name and name_address table in our iMIS database. The name_address table stores three se…
9 replies
This seems simple enough, I'm trying to get a count of employees by different indicators. First tot…
1 replies
All: The DB I'm working with stores a date in a varchar field (don't blame me - I didn't design it)…
16 replies
hi , INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test.…
4 replies
Maximum Number of rows allowed in sql server 2005 tables ? Maximum Number of columns allowed in sql…
5 replies
hi , use msdb select * from dbo.sysjobhistory i know this query to see detail of all jobs but i w…
4 replies
In below 2 procedures are created i want build a query with Temparary table in 1st SP and pass int…
4 replies
I work on a data warehouse that loads lots of static (config) data from Excel spreadsheets using DT…
2 replies
my data like this id | username | event 1 a 1 2 …
7 replies
Hi , in my table i have values 'FAHEEM' and 'faheem',Now i have to select 'faheem' but SQL treat bo…
4 replies
Viewing 15 topics - 10,561 through 10,575 (of 12,230 total)
You must be logged in to create new topics.