Topics
Started by
Posts
Last post
Hi Experts, I have a database with more than 600+ tables. Some of the table are very big ranging fr…
1 replies
I have written following query in which I have not written Index anywhere... declare @strColumns va…
3 replies
Hi, I need to get the file size in by…
26 replies
By: Anonymous
How can I remove Carriage Return -> char(13) from a normal string in tsql because I don't succe…
3 replies
Some help needed here. I've got a store procedure that reads an XML file, and then uses it to updat…
8 replies
When I add a variable to my dynamic SQL the entire query is truncated at 4K. Without the variable i…
28 replies
What is the preferred datatype for storing Credit card info?
25 replies
ok this is something of a best practice of mine in my queries I always do WHERE 1 = 1 I can't rem…
52 replies
The code that is building the table variable works great outside of the code creating the function.…
10 replies
Hi Experts, Len() - Will give the length of the character used,instead of length of the bit,exclude…
11 replies
I am working with EVENT_LOCATOR varchar(40) value. An example EVENT_LOCATOR would be "20…
17 replies
Hi, Running SQL 2008 x64 SP1 I added a linked server, an excel file using OLE DB 12.0 I can read my…
7 replies
I am trying to write multiple lines to a DOS file with xp_cmdshell. This works: DECLARE @cmd …
9 replies
I would like to extract the first part of the post code. for example I have AA1 2BB A1 2B A4 2BB I…
15 replies
When I remove columns from my excel spread sheet and my code is as follows, it gives me an error. I…
6 replies
Viewing 15 topics - 151 through 165 (of 17,082 total)
You must be logged in to create new topics.