Forum Replies Created
Viewing 15 posts - 1,876 through 1,890 (of 13,460 total)
-
RE: Validate URL
ZZartin (3/19/2015)
I'm sure you could write some kind of CLR function that would go ping your URL's, that'll tell you whether they're valid or not 😀Trying to rely on regular...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Report of fields and data types
well, all the information's in the metadata;
here's something i use myself, where i check if there are any extended property descriptions as well.
does this get you started?
select
--objz.object_id,
objz.name As TableName,
ISNULL(tabz.value,'')...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Find not existing calls in stored procedures or functions.
still using sys.sql_expression_dependencies, this seems to work for me, but gives some falsepositives due to CTE names appearing in the dependancies as well.
i deleted some staging tables that i know...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Legal / Illegal XML Characters list
The Tally Table is a reference to a single column table from 1 to {some large number}
the example shown only needs 8000 chars;
this was the origianl definition from years ago:
SELECT...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: HELP evaluating rows and selecting specific records
well i doinked aroudn getting the data, but row number snot going to find consecutive montsh... here;s the data as a consumable post at least.
;WITH MyCTE([PERSON ID],[MONTH ORDERED],[Note])
AS
(
SELECT 'JD12345','4','' UNION...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Iterate throught database tables
techzone12 (3/18/2015)
How to add one more condition that the table name ends with "Temp"I am trying to do an inner join, so far no success yet.
here's a full example:
select
...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Iterate throught database tables
you can find every column namedDateStamp, and it's tablename (but it might be VIEWNAME !!) you can join to sys.tables and then sys.columns as instead
select
'delete from '...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: default database setting question
my shop is the opposite;
i never receive scripts that contain settings from developers. s
o i'd say since my default conection settings from SSMS will have those settings set at...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Count on table with million data too slow
GilaMonster (3/18/2015)
Lowell (3/18/2015)
also, why not count(*)? it would be faster, i would think.In this case it's unlikely to be faster as the column in the count is already in the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Count on table with million data too slow
there a nice softball of a suggested missing index right there.....i bet you could hit that one out of the park.
also, why not count(*)? it would be faster, i would...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SSRS 2012 - Repalce Datasource name in all reports
watching this post for a better way; i couldn't figure out a way to cleanly edit a report programmaticly to change the datasourc.e
when i cleaned up this same issue(2005 to...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Try It
g.britton (3/16/2015)
What I especially <sarcasm>love</sarcasm> is students that post homework questions without making any attempt to solve the problem or even, apparently, work on it at all.so true! i wonder...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: What was the previous value
SQL doesn't have a concept of previous row, so you have to have a structure that supports being able to identify a row and some sort of row order explicitly.
here's...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: weird login failure user name
well, a web.config file or application.config, if it was using a SQL login, might have something like this in it:
<connectionStrings>
...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: xp_cmdshell - vbscript
senthil.k (3/16/2015)
Hi ,Can you send me the SQL script for calling a EXE from SQL server . I have tried to use xp_cmdshell from my stored procedure . But it...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 1,876 through 1,890 (of 13,460 total)