Viewing 15 posts - 8,251 through 8,265 (of 11,676 total)
Siva Ramasamy (1/30/2012)
(CategoryId int, NameCategory varchar(245))
INSERT INTO Category ( CategoryId, NameCategory) VALUES (1,'A')
INSERT INTO Category ( CategoryId, NameCategory) VALUES (2,'B')
INSERT INTO...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 12:03 am
Coolroof (1/30/2012)
how to configure Encryption for particular column in sql server 2008..?pls give me the step..?
How to: Encrypt a Column of Data
First google result for sql server encrypt column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 12:00 am
You should ask the Human Resource department.
Ok, seriously now, how are we supposed the answer the question when we have no idea what the tables are like, how the columns...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 11:58 pm
Hmmmm, this is arguable.
MSDN says that it can only use columns for the same table.
And a computed column can't reference a column outside another table, it can reference a UDF...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 11:28 pm
yuvipoy (1/20/2012)
Hi,Using VS.NET 2005 and SQL 2005 Windows XP SP3.
What has SP3? SQL Server or Windows XP?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 11:11 pm
rajiv.kumarb (1/30/2012)
u can use Single For Loop,( assign the file name into variable,)and u can use scriptTask to read the fileName (from variable) and move the file to relavant location.
thanks,
rajivkumar
Why...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 11:08 pm
Capt. Sigerson (1/30/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 11:04 am
Sri8143 (1/30/2012)
I am using ssis not ssms ....and they want to do it thru ssis ..
Use an Execute SQL Task to create a backup of the database.
Use another Execute SQL...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 6:19 am
How to: Map Result Sets to Variables in an Execute SQL Task
(Google is a wonderful thing)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 6:16 am
In the For Each Loop you can specify a wildcard search for which files the For Each Loop should pick up.
So you configure 5 For Each Loops. Each loop picks...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 6:14 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2012 at 6:02 am
Prashant Mhaske (1/27/2012)
Hi,I can not afford 64bit operating on server at this moment .
Could you please suggest any other option ?
Thanks in advance !
Process the data in smaller chunks instead...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 29, 2012 at 12:15 am
GSquared (1/27/2012)
Completely agreed. Didn't mean to sound like I was coming down on your answer, just wanted to clarify that IMEX won't fix the lost digits piece.
I know.
If Excel...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2012 at 6:34 am
Brandie Tarvin (1/27/2012)
I'm...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2012 at 5:15 am
Gianluca Sartori (1/27/2012)
SQL Kiwi (1/27/2012)
Google indexes scarily fastNot always 😀
That's because they probably censored it. Google and scary in one sentence, what did you expect?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2012 at 5:12 am
Viewing 15 posts - 8,251 through 8,265 (of 11,676 total)