Tag Info

New answers tagged

1

If you need to execute sql file use sqlcmd documented in the MSDN: Run Transact-SQL Script Files Using sqlcmd This did the trick for me: sqlcmd -S serverName\instanceName -i script.sql -o output.txt


0

There are at least two drawback when using a query to check if URL exist: Sending an extra query to database, will include additional network delay to your overall response time and also more network traffic. no matter what value you insert, database will still check for duplicate key. therefore, the search on primary key is performed twice when two query ...


1

What you are asking is to be able to create a report name dynamically, which is not something that can be programmed, on download, say, from Report Manager. You can (although I've never tested this) possibly do this through a subscription using @ParameterName @ReportName. citation from msdn It's about the best you can do for now, and there's a link on the ...


0

If you want to use that as a naming convention, yes you can do that. If you want the parameters to show on the report you can do that too. You can add them to the title, a header, footer or anywhere you want on the report as an expression. If you are talking about saving the report output using parameters in tge name... i don't believe you could enforce ...


1

You can use an array constructor: select array( select zone from mytable) as areas;


0

Yes this design is poor, just imagine to add another hour. This is a better aproach: Students(**StudentID**, LastName, ...[other Student Details]) Courses(**CouseID**, Description, ...[any other Course Specific Stuff]) or to whatever they attend. If you can be sure that there is and will always be only ONE you can skip this If possible have something ...


0

Killing the connection processes did not work for me since the clients do not have permission to see process ID's. In hopes that this might help someone else, this is what I ended up doing; call into SqlConnection.ClearAllPools immediately prior to trying to delete a User. This will truly disconnect any remaining connections by the open application (i.e. if ...



Top 50 recent answers are included