- keep sql-injection in mind ! Check http://qa.sqlservercentral.com/columnists/chedgate/sqlinjection.asp- just define your variables as sp-parameters and handle your statement in your sp. You will soon discover it's best to work with known predicates.- check http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html
2004-03-03
If doing it manually is an option, then you can use Enterprise Manager. If you want a script to remove it you can go to the design view in Enterprise Manager, set identity = No, and then click the Save Change Script button.
2004-02-20
http://www.sqldts.com/default.aspx?292 Quoted from above article. "Move or Rename File This shows a simple file move operation, using hardcoded source and destination filenames. There is no explicit rename method in the scripting object, but a move is just the same. ' Move File Option Explicit Function Main() Dim oFSO Dim sSourceFile Dim sDestinationFile Set oFSO = […]
2003-12-22
1 reads
Go back and check the SQL Server logs from the time of the power outage and you can verify if SQL Server was shutdown gracefully. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-12-10
2 reads
From what I understand, above 8GB, you need to leave the OS 1GB for PAE. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-01
quote: I am trying to figure out how to export the results of a query to Excel with some specific formatting. Is this possible to do without using DTS? One method could be -- Inputs:File name of the excel document. -- Returns:The query result, written directly in Excel document! DECLARE @err_desc varchar(255) DECLARE @i int […]
2003-08-27
I am looking for what severs are controlling the active clusters.
2003-08-25
1 reads
2003-07-28
Hi Zambrtp, quote: Would that always insert a tick ....this has only occurred once so far...if it always inserts a tick then the data would not be correct.. My insert statement passes the VALUES as ''('values','values')'' so that the insert statment is bulit as values ('values', 'value') in here is where the data had the […]
2003-07-25
There is absolutely no shame in asking a valid question. The only poor question is the one not asked. Please keep forum posts respectful of other's abilities and experience levels.
2003-07-25
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers